Shawn319
04-08-2002, 01:44 AM
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..
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..