Possible fix for 2006 error in mysql

[Shawn319]

From Trumpcard.

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