Yes I did run that line, even though someone above said I didnt need to, I did anyways.
|
I said you didnt need to run the GRANT ALL PRIVILAGES command.
But the one that I mentioned and the one that angelox mentioned have to be run in mysql 5.x. EQEmu was built for mysql 4, and the password system has changed between 4 and 5 so that command is a must. Mine was for the root account. Angelox mentioned the eq account that you may have created. Given that line I mentioned in my last post about 'eq'@'localhost' error you had in one of your logs, that would mean that in your eqemu_config.xml file under that database information you would have the username as eq instead of root. ON the contrary though. You posted your xml file that had root in it and also you said that you were using root. So why is this error showing up for you? You have had to change the xml file at some point and put eq in there. If you did this, you need to create the account in mysql, assign it a password. Then run the GRANT all privilages command from a very early post. This will give 'eq'@'localhost' permision ot accesee and modify the peq databse. You will then also have to run the set password command angelox mentioned to to fix the password scheme from 5.x to make it compatible with 4.x type applications |
Quote:
or do I have to do that C:\mysql\bin\mysql -u root peq, because the last time I tried typing that in I got an error... And do I need to change eq@localhost to root@localhost since Im using root? Thanks |
Heres the best way to do this. Download the GUI Tools from Mysql
Open up Mysql Administator Go to User Administration in the bottom left corner, see if you have two users, on being root, the other being eq, if you only have root do this At the bottom right, click on Add New User, and fill in the information for user name and password, ingnore the rest. Once this is done click Apply changes Now click on the eq user in the bottom left window. Then go to Schema Privilages. Click on the peq databse, then click the << buttone in the middle to assign all available privilages. Once that is done, Open up the mysql command thing, and then type in the command angelox said earlier. Code:
set password for 'eq'@'localhost = OLD_PASSWORD('newpwd'); This will set up a accoutn name eq that has the same ability as the root account if you followed the guide from the wiki. Personaly, if you have issues using the root account, your still going to have issues with the eq account. |
Ok I did what you said, but it didnt work, and said that eq@localhost didnt exist, so I clicked the eq user on the serveradministater UI thing, and it said eq@anyhost, so then I clicked add host changed the name to local host, it was then eq@localhost. I then typed in the code to change the password, it worked but it said 0 rows affected, like it changed nothing. But then I tried the start.bat, it did the same thing it always does, starts up real quick, world dissapears instantly and the other screen stays blank, so I went back to the log and it said -- ------------------------------
[05.03. - 21:48:34] Starting Log: logs/eqemu_debug_world_3872.log [05.03. - 21:48:34] [WORLD__INIT] Loading server configuration.. [05.03. - 21:48:34] [WORLD__INIT] Log settings loaded from log.ini [05.03. - 21:48:34] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEMu 0.7.0 [05.03. - 21:48:34] [WORLD__INIT] Connecting to MySQL... [05.03. - 21:48:34] [WORLD__INIT_ERR] Cannot continue without a database connection. so now the other problem is gone (I think), and were back to this one, The only thing I think could screw this up is a firewall or router blocking it ,and I turned my firewall off and unblocked 3306. And 5999 even though its not nessacary, so now the only thing I think could be the problem is my LoginServer.ini and my eqemu_config.xml . So I'm going to post what the have in them, see if I have anything wrong -- eqemu_config.xml <?xml version="1.0"> <server> <world> <shortname>JGT</shortname> <longname>JGTs Server</longname> <!-- Only specify these two if you really think you need to. --> <!--<address>192.168.1.105</address>--> <!--<localaddress>127.0.0.1</localaddress>--> <!-- Loginserver information. --> <loginserver> <host>127.0.0.1</host> <port>3306</port> <account></account> <password></password> </loginserver> <!-- Sets the shared key used by zone/launcher to connect to world --> <key>some long random string</key> <!-- Enable and set the port for the HTTP service. --> <http port="9080" enabled="true" mimefile="mime.types" /> </world> <!-- Database configuration, replaces db.ini. --> <database> <host>127.0.0.1</host> <port>3306</port> <username>root</username> <password>everquest</password> <db>PEQ</db> </database> </server> and LoginServer.ini ### --- This file tells world.exe what loginserver to connect to. ### --- Leave the account and password field BLANK. ### --- Public Login is un-supported as is LAN playing. We reccomend using the EQEmu.net Loginserver ALWAYS. ### --- NOTE: Starting 6-1-2002, you can no longer use the word "Server" in worldname. ### --- NOTE2: the word "Server" is added to each server automaticly. # READ README.TXT [LoginServer] loginserver=127.0.0.1 loginserver2=newlogin1.eqemulator.net loginport=3306 loginport2=3306 worldname=JGTs Server worldaddress=127.0.0.1 locked=false account= password= [WorldServer] Defaultstatus= Unavailzone= [ChatChannelServer] worldshortname= chataddress= chatport= [LoginConfig] ServerMode=Minilogin ServerPort=3306 |
may be stupid on my part but you might try going under mysql and typing in CONNECT **the name of your database here**. sometimes when you restart mysql it won't restart with the DB connected
|
All times are GMT -4. The time now is 10:31 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.