Create a database in MySQL 5.0

[FoxT2]

Hi,

How do I create a database in MySQL 5.0. I used to do it this way in the previous versions...

mysqladmin create myDataBase

also how do I assign a database user name and password.

Is there a graphical interface that comes with MySQL 5.0 like the one that was in the older versions. I use to use winmysqladmin.exe to bring up a GUI with information on your MySQL database.

Thanks.

 

[mbrooks]

To set the password on Windows

shell> mysql -u root
mysql> SET PASSWORD FOR ''@'localhost' = PASSWORD('password');
mysql> SET PASSWORD FOR ''@'%' = PASSWORD('password');

To create a database

% mysqladmin -p create [i]<db name>[/i]

M. Brooks

http://mbrooks.info