Need help with mysql

beeger20 · #1 05-18-2008, 12:58 AM

ok every time i try to do something with mysql i get this error

ERROR 1044: Access denied for user: '@localhost' to database 'peq'

i dont understand it

**trevius** · #2 05-18-2008, 04:53 PM

From the wiki for new server setups, here:

http://www.eqemulator.net/wiki/wikka...ka=ws992mysql5

You need to create the actual account to use for editing your database and set the password. You can use root or create a new account. Either way, you will need something with a password:

Code:

set password for 'root'@'localhost' = OLD_PASSWORD('newpwd');
FLUSH PRIVILEGES;
exit;

Make sure to set 'newpwd' to whatever you want your root password to be.

Then you can login from command prompt with:

Code:

mysql -u root -p

And put in the password you just set when it asks you for one. This should let you do whatever you want with your database.