EQEmulator Forums - permissions fix?

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

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

- - permissions fix? (https://www.eqemulator.org/forums/showthread.php?t=9190)

permissions fix?

Ok I got the problem fixed finally but now when I try and run world.exe it gives me the 2006 error, and I read on this page where someone said if you get an error you need to permissions fix, where do I find the permissions fix? I'm assuming it's a patch is why I ask :)

The permissions fix is not a patch. Go into MySQL (C:\mysql\bin\mysql.exe) and type the following:

Code:

GRANT ALL ON (name of your database).* TO 'yourmysqlusername'@'localhost' IDENTIFIED BY 'yourmysqlpassword WITH GRANT OPTION;

Now, if you get access denied when you try to do this, go into MSDOS (cmd or command in Run), go to your MySQL dir (uasually C:\mysql\bin) and type

Code:

mysql -u root

and then type the GRANT ALL ON... thing. If you already set a root password (by default it is blank), type in MSDOS:

Code:

mysql -u root -p(rootpasswd)

Hope this helps - MySQL can be a pain to work with if you dont know how to use it :x . I would recommed buying a book on MySQL. It helps to know it to run a server (And it works great with PHP too)