Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers

Support::Windows Servers Support forum for Windows EQEMu users.

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-08-2002, 01:44 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default Possible fix for 2006 error in mysql

From Trumpcard.


Quote:
Mysql has a very explicit permissions system for security, even if you have set the username/password, you may still get the 2006 error
if mysql thinks you are coming in from another machine.

The fix for this is very simple..

type mysql from the c:\mysql\bin directory


Need to set the permissions on user at that ip..


mysql>GRANT ALL PRIVILEGES ON eq.* TO someid@localhost
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

or, the less secure but more useful technique that will allow you to log on with that user name from any machine.

mysql> GRANT ALL PRIVILEGES ON eq.* TO someid@"%"
IDENTIFIED BY 'somepass' WITH GRANT OPTION;

This option is useful if you are wanting to run EQAdmin from a different machine than your database box, or running your world/zone servers on a seperate box than your database.

Note, if you dont use the database name 'eq', you can replace whatever it is in the example above. Some people have suggested using *.*, but I discourage that as it gives someone the ability to drop your entire database if they could figure out the db password/userid. This might not be an issue for some people but alot of us use mysql for more than just the emulator..
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
  #2  
Old 04-18-2002, 06:37 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

Also, Try running Winmysqladmin.exe in the backround or minimized if all elce fails.
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
  #3  
Old 04-25-2002, 03:39 AM
veggita2099
Sarnak
 
Join Date: Apr 2002
Posts: 62
Default

Should this say Query OK 0 rows effected in 0.0 sec when your finished??
  #4  
Old 04-25-2002, 03:49 AM
Shawn319
Demi-God
 
Join Date: Jan 2002
Posts: 2,073
Default

as long as it didnt say syntax error your fine.

that message is normal.
__________________
Shawn319
Semi-Retired EQ Addict

(Retired)EQEmu Lead Tester
(Retired)EQEmu Tech Support

(Retired)Host/ServerOP - [LIVE] Official EQEmu Test Server
(Retired)Host/ServerOP - Shawn319's All-GM Dev Test Server
(Retired)ServerOP - EQEmu Beta Server
(Retired)ServerOP - GuildWars Server
(Retired)ServerOP - Raid Addicts
--------------------------
  #5  
Old 04-25-2002, 05:20 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Here is the way to test your EQEMU id /password


cd to mysql/bin

mysql -u <user id> -p

It will ask for the password.

If it lets you in, your permissions are probably good.

If you get an 'Access Denied' , you need to apply the permissions fix.
  #6  
Old 04-30-2002, 07:56 PM
Void
Fire Beetle
 
Join Date: May 2002
Posts: 2
Default

****EDIT****

Im too stupid for words , fixed my problem i hope , i appologize for taking up space on your message boards lol.

Void

P.S. my problem was that i had tabbed a space after my user name in db.ini , and that was what was causing my problems.
  #7  
Old 05-01-2002, 12:03 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

Happens to the best of us man.. Whitespace errors are usually the hardest to catch.
  #8  
Old 05-01-2002, 05:14 AM
Vn188zV7ZPc=
Fire Beetle
 
Join Date: Apr 2002
Posts: 8
Default omfg

thx for the tab after name fix idea =(
i was going bonkers trying to figure out what i had wrong.....
  #9  
Old 05-31-2002, 04:41 PM
Arcalyn
Hill Giant
 
Join Date: Apr 2002
Location: Columbus, Ohio
Posts: 143
Default Nice Info here

Good INFO!
__________________
RTFM? ----> Does it come in braille?
  #10  
Old 06-01-2002, 11:03 AM
chocobo
Hill Giant
 
Join Date: May 2002
Posts: 114
Default hmm

Now what does this fix?
Closed Thread


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 03:55 PM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3