problem creating new database

[ceimon]

I tried to create a mysql database using the following command:
shell>bin/mysqladmin --password=pass create web_db

and got this error message:
bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

please help me resolve this issue.

 

[snowboardr]

Get MySQL Front... it will speed up your database development 100 fold.

http://www.vzio.com/tutorials/mysql_database.asp#link

That anchor goes directly the download link for mysql front, and then if you continue in the tutorail it gives you a quick tutorial on using it...

- Jason

 

[QatQat]

You have to specify a user
yhe correct usage for your statement is

mysqladmin --user=root --password=pass create databasename

I recommend you learn to use mysql without using any GUI. In future, when you know it better, you may want to look at a GUI to speed up something although I am pretty sure you won't feel a need for it anymore. MySQL is a very easy RDBMS. If you want to know it well a GUI is a wrong start.


Try download the full manual

http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual-a4.pdf&pick=mirror

Bye


Qatqat



Life is what happens when you are making other plans.

 

[QatQat]

You have to specify a user
yhe correct usage for your statement is

mysqladmin --user=root --password=pass create databasename

I recommend you learn to use mysql without using any GUI. In future, when you know it better, you may want to look at a GUI to speed up something although I am pretty sure you won't feel a need for it anymore. MySQL is a very easy RDBMS. If you want to know it well a GUI is a wrong start.


Try download the full manual

http://www.mysql.com/downloads/download.php?file=Downloads/Manual/manual-a4.pdf&pick=mirror

Bye


Qatqat

Life is what happens when you are making other plans.