How do I create a MySQL Database?

I need help creating a database... :( I'm completely confused. Can anyone help?

Try here: http://dev.mysql.com/doc/refman/5.0/en/tutorial.html

Actually, that was the page that made me start this thread in the first place. :P

I'm not sure I fully understand.

Another person told me there was a code I copy to set up the main database, and save it to my server- then all I had to do was add to it when neccessary.

Nope, it doesn't work quite like that. You either have a database or you don't, it's determined by your server specifications. Contact your server administrator and ask if a MySql database is set up. If so, they will probably give you a link to manage it (probably PHPmyadmin).

there are so many ways--and it depends on your system. Be more specific

If you need a graphical tool you can try heidisql

You have to have a database server running. If your host supports it, they should give you the address of that server and access details. Then, connect to it using the mysql client:

Code:

---

$ mysql -h mysqlserver.example.com -u your_username -p
Password:
mysql> create database database_name;

---

I was confused with this too, at first, but you have to play around with it for a while before you fully get it.

If you are using PHP, then MySQL is your best option as they are almost inseparable.

Not really: PostgreSQL has just as much support, as well as being a more advanced implementation capable of frightfully advanced operations that MySQL seems to lack, like, er, subqueries.

However, I'm not quite sure how this relates to the thread...