Error 1044 and 1045

[Kalen]

This is for after you unzip EQEmu, Install MySQL, copy db.sql, setup username and password using winmysqladmin.exe, run mysql and enter "create database eq;" "use eq" "source db.sql", and setup the .ini files in EQEmu directory. (Steps in http://www.eqemu.net/documents/readme.html (Part 2 - Hosting your own server on EQEmu) all the way to text with green highlight)

If you getting ERROR 1044 and ERROR 1045: Access denied to user@host blah blah blah, and you HAVE already done all the steps named above, THIS is the CORRECT syntax to use when changing privileges on accounts:

C:\MYSQL\BIN> mysql -u root mysql
mysql> GRANT ALL PRIVILEGES ON eq.* TO <user>@localhost
-> IDENTIFIED BY '&lt;pass>' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON eq.* TO <user>@"%"
-> IDENTIFIED BY '&lt;pass>' WITH GRANT OPTION;

Basicly go to your mysql\bin directory in dos and run "mysql -u root mysql". Type it in like that EXACTLY without quotation marks. Then type "GRANT ALL PRIVILEGES ON eq.* TO <user>@localhost" (fill in user with the username you setup using winmysqladmin.exe) and hit enter. Then press space five times and type "IDENTIFIED BY '&lt;pass>' WITH GRANT OPTION;" (fill in pass with the password you setup using winmysqladmin.exe) and hit enter.

Then type "GRANT ALL PRIVILEGES ON eq.* TO <user>@"%"" (fill in user with the username you setup using winmysqladmin.exe) (keep the double qoutes (" ") around % ("%"))and hit enter. Then press space five times and type "IDENTIFIED BY '&lt;pass>' WITH GRANT OPTION;" (fill in pass with the password you setup using winmysqladmin.exe) and hit enter.

So if Bob Hill made the username "gdogg" and the password "zonk", his screen would look like this afterwards:

C:\MYSQL\BIN> mysql -u root mysql
mysql> GRANT ALL PRIVILEGES ON eq.* TO gdogg@localhost
-> IDENTIFIED BY 'zonk' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON eq.* TO gdogg@"%"
-> IDENTIFIED BY 'zonk' WITH GRANT OPTION;

If you have any questions please email me at jlsarvis16spam@yahoospam.com
Remember to take both instances of the word spam out of that email address.

-KALEN