I am unable to ceate a database I get the following error

mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost'
to database 'testdb''

How can I give this account rights to create a datatbase


Microsoft Windows [Version 5.2.3790]

C:\Documents and Settings\Cedric>cd\

C:\>cd mysql

C:\mysql>cd bin

C:\mysql\bin>mysqladmin create testDB
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost'
to database 'testdb''

C:\mysql\bin>winmysqladmin

C:\mysql\bin>

Why won't you download MySql Control Center from http://dev.mysql.com/downloads/mysqlcc.html. Install it. Then, Open it, right click on localhost or whatever your server name is, and click edit. Change the parameters into root and connect. Then go to User Administration -> double click the user name, and you can change their priviliges here. It saves time than entering commands from the command line...

I hope this helps

The is that I am having is when I do the following

cd mysql/bin/

the default user of @localhost is used and ths user has no rights. I created a user call cedric how do I switch to that user??

If you want to operate as that user from within a PHP script, then pass that username and password. Most control panels (such as MySQL Ctrl Ctr and phpMyAdmin) operate as the admin user. To change that would require probably editing the respective configuration files to determine which login credentials are passed.