Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::General Support

Support::General Support Post all topics here having to do with errors while trying to connect to an EQEMu server but not about the setup/running of the Server itself.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 07:47 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3