EQEmulator Forums - Possible fix for 2006 error in mysql

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Possible fix for 2006 error in mysql (https://www.eqemulator.org/forums/showthread.php?t=1065)

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..

Also, Try running Winmysqladmin.exe in the backround or minimized if all elce fails.

Should this say Query OK 0 rows effected in 0.0 sec when your finished??

as long as it didnt say syntax error your fine.

that message is normal.

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.

****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.

Happens to the best of us man.. Whitespace errors are usually the hardest to catch.

thx for the tab after name fix idea =(
i was going bonkers trying to figure out what i had wrong.....

Now what does this fix?