EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Need help with mysql (https://www.eqemulator.org/forums/showthread.php?t=25260)

beeger20 05-18-2008 12:58 AM

Need help with mysql
 
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 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.


All times are GMT -4. The time now is 09:19 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.