View Single Post
  #23  
Old 05-27-2004, 08:08 AM
mikenune
Discordant
 
Join Date: Apr 2004
Location: Gukta
Posts: 359
Default

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.
__________________
THE POSTER assumes no warranty, guarantee, or representation as to the accuracy
or sufficiency of the information presented herein, and THE POSTER assumes no
responsibility or liability regarding the use or misuse of such information.
Furthermore THE POSTER assumes no responsibility and makes no warranty, guarantee,
or representation for the content of any web or FTP sites linked to or from this
post.

THE POSTER reserves the right to change the terms, conditions, and notices under
which THE POSTER presents information. It is the responsibility of THE READER to
regularly review these terms, conditions, and notices. THE READER understands that
the reading of any content including or covered by this disclaimer constitutes THE
READER's acceptance of and agreement to such changes.

THE POSTER retains the right to in any way alter the content of this post at any
time with or without prior notice to THE READER.
Reply With Quote