MySQL access denied problems ??

huno · 05-16-2002, 06:59 AM

i want to create new SQl database i write this in command line

mysqladmin create databasenk

but it shown this error

mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: root@localhost' (using passowrd: NO)'

what is the answer for this matter

kill-hup · 05-16-2002, 10:30 AM

Looks like you have a password set up for the root user in your mysql "user" table (good thing!).

You need to say "mysqladmin -p create dbname" to have it prompt you for the password. If you need to supply an alternate user instead of "root", use the "-u" option.