How do yo Create new database 1

[knuckle05]

Hi All,

I'm new to MySQL. I've installed the package in a Windows 2000 environment and now would like to create my first db.

I open the winmysqladmin.exe utility but on the database tab, I am not able to create a new db. I only have the Flush options.

Am I missing something?

Thx!

 

[QatQat]

MysqlAdmin is not a tool for administering databases but simply to perform server related tasks.

Open command prompt,

cd mysql\bin
mysql -u root -p
enter you password

Now in mysql prompt
mysql>create database dbname;

I strongly suggest however that you download the manual from

http://www.mysql.com.

Bye

Qatqat

Life is what happens when you are making other plans.

 

[TonyGroves]

Another useful tool is the MySQL Control Centre, free from the MySQL site. That allows you create tables, run queries, etc., from a nice GUI interface. It's still beta as far as I know, but the bugs are minor and few.