QUOTE : As explained in the very first post on this thread: the 2006 error is a MySQL permissions related one.
Basically, it's saying that EQEMu can't connect to your MySQL database because of a bad username/password.
The simplest (and WORST) way to fix this is to give EQEMu the "root" username and password. (Note: DO NOT DO THIS!!!! IT'S A BAD IDEA!!!)
Barring that, the best thing to do is make sure you've run the series of statements in my last post. Be sure to replace the words in yellow with your information.
Quote:
USE mysql;
GRANT ALL on eq.* TO 'user'@'localhost' IDENTIFIED BY 'password' WITH GRANT OPTION;
Once you have run these statements, you can easily check if they worked by attempting to log in to MySQL as your EQEUm user. This is by running the following statements from the command prompt.
Quote:
C:\> cd \mysql\bin
C:\mysql\bin\> mysql -u user -p eq
This should make MySQL prompt you for your password. Be sure to use the same one you used when running the GRANT statement.
If you can get logged in, then everything should be fine! If not, then I'd try using a MySQL administration program like winmysqladmin (shipped with MySQL, it can be found in the C:\mysql\bin folder), or MySQL-Front.
Ok thakks for the info I would have replied sooner but been busy lately. This is what I am not understanding at the dos prompt i can access mysql by typing the "test" thing mysql -u (username) -p and it prompts me for a password and I enter it and it works fine comes up with the mysql and all the other stuff. So my access should be ok it excepts it which is great I go back run world.exe and then comes up again with the 2006 error now how can it allow me to access it through a prompt but when I run world.exe it does the mysql gone away stuff.. that is what I am not understanding and haveing problems with. That is the fix I am looking for.
Sorry for all the trouble and confusion..
Jassy D.
|
Threaded Mode
