Access Denied???

eclipze

ok. im just trying to create a database, and this is the error it gives me. Im doing it locally and i know the password and username is correct.

[username@peony mysql]$ mysqladmin -h localhost -u username -p create db
Enter password:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: 'username@localhost' to database 'db''

Last night i was using a database i created and then i dropped it. Would that cause any of this to happen? I also get the same error through phpmyadmin. Any insight would be much appreciated.

Peter

Anon

I've always used this syntax:
mysqladmin --user=<username> --pasword=<password> create db

They way you suggested in your post never worked for me!

Jon

eclipze

that doesnt work either

[username@peony home]$ mysqladmin --user=ysername --password=XXXXX create usersdb
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: 'username@localhost' to database 'usersdb''

any other suggestions?

intenz

/usr/local/mysql/bin/mysql_setpermissions --user=foo --password=foo

Try setting your password again for root or something.

eclipze

[username@peony bin]$ ./mysql_setpermission --user=username
Password for user username to connect to MySQL:
Can't make a connection to the mysql server.
The error: Access denied for user: username@localhost' to database 'mysql' at ./mysql_setpermission line 65, <STDIN> line 1.

ouch, no go again. anyone else have a clue. This isnt my machine. Its on a webserver hosting company (6star.net) so i dont think i have access to the root account. any idea?