MySQL database name

[Pookie]

im using windows xp pro with MySQL 5.0

This program told me that i need to setup a database using MySQL. I go to the command line of mysql, type in the command to show the status and the database name is blank, shows the user and password tho. how can i create a new database and name it. it didnt give me an option to setup a database, only thing it asked me to put in is a root password for security.
_________________
~TRU~

[olly86]

You can use the consol method, but I prefer to use two utilities provided by MySQL to this instead.

MySQL Administrator: http://www.mysql.com/products/tools/administrator/
MySQL Query Browser: http://www.mysql.com/products/tools/query-browser/

The first will alow you to setup new database, and manage permishions/user accouts. The second allows you to create, alter, and delete tables. As well as adding content.
_________________
Olly

[aprelium]

Pookie,

Install PhpMyAdmin to have full control on MySQL and to be able to create/delete/update/browse databases.

Otherwise, you can use the MsYQL command line tool and issue commands to do what you want. To create a database, use CREATE DATABASE: http://dev.mysql.com/doc/refman/5.0/en/create-database.html .
_________________
Support Team
Aprelium - http://www.aprelium.com

[phirez]

My sql when installed is not a single database. My sql is a server that creates the databases. You create the databases using adminstrative gui. I recommend flashmyadmin go to: http://flashmyadmin.org/english/flashmyadmin.org.php