Log in

View Full Version : SQL ..


bubbles
04-26-2004, 07:46 PM
I'm having a real hard time finding out how to make an SQL username for the EQEmu Admin Tool that I downloaded. Actually, the whole Database section. Anyone got some time that could help me get through it?

Thanks :D

smogo
04-26-2004, 08:55 PM
The username you are going to use is the one you set for EQEMu database, as described in SECOND STEP of that post :
http://www.eqemulator.net/forums/viewtopic.php?t=13403
There is a line like :
grant all privileges on *.* to username@localhost identified by 'password' with grant option;

If you've done that, you ahve a user name, and a password for the DB

Then, edit eqadmin.ini, and near the top you should find :
DBNAME=mydbname
DBHOST=myserverip
DBUSERNAME=myusername
DBPASSWORD=mypassword
Set the mydbname to your dbname
Set the myserverip to your database server IP (or 127.0.0.1 if you run on same machine that yourun EQAdmin on)
Set the mydbname to your the user name you set in the GRANT PRIVILEGES command (no @localhost)
Set mypassword to the password you used in the GRANT PRIVILEGES command.

You should be able to connect then.

i hope that helps