View Single Post
  #2  
Old 05-18-2008, 04:53 PM
trevius's Avatar
trevius
Developer
 
Join Date: Aug 2006
Location: USA
Posts: 5,946
Default

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.
__________________
Trevazar/Trevius Owner of: Storm Haven
Everquest Emulator FAQ (Frequently Asked Questions) - Read It!
Reply With Quote