How do I create a MySQL Database?

[5starmember]

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

[motormichael12]

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

[5starmember]

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.

[mburt]

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).

[JShor]

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

[tfit]

If you need a graphical tool you can try heidisql

[Twey]

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:

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

[mburt]

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

[lulzury]

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

[Twey]

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...