Error 1044 and 1045
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 '<pass>' WITH GRANT OPTION; mysql> GRANT ALL PRIVILEGES ON eq.* TO <user>@"%" -> IDENTIFIED BY '<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 '<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 '<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 |
did what you said.. error came up..
'GRANT" is not reconized as an internal or external command, operable program or batch file not sure what the deal is.. gonna look for another fix for this error |
Satransisu, that type of error is a windows/DOS command line error, it basically indicates that you don't have mysql.exe running when you type the GRANT command.
Maranwe |
Yes. He apparently isnt following directions..
a mysql error would have said ERROR: &*(& |
error 1044 for me.
|
LOl
YOu guys are not making any sense.. sound like a bunch of computer nerds! lol
|
Dev
use Dev's step-by-step above
helped me fix my access denied prob |
Error
Tried it.. didnt work.. here is what i did
Quote:
|
run
did you open mysql.exe through "run" in your start menu?
|
Hi I had the same problem
mysql -u root mysql I followed the directions but it still isnt working. |
Veragoan: the "mysql -u root mysql" is supposed to be done on the command line "c:\mysql\bin>". You want to skip that part if you are already in mysql. If you are at the mysql prompt "mysql>" they just try the grant lines.
Tolarn: This is probably your problem also. |
Re: Error
Quote:
I got absolutely the same error I'm using EQEmu v4.4 was anyone able tomake it work correctly? |
.
try to play around with the command. like replace localhost with 127.0.0.1. look at some other posts on the subject. theres like 50 other ways to type this command
|
Mine said that it works but I'm still gettting denied.
<0 ROWS EFFFECTED, 0 SECS> or something similar meaning that it did work but nothing happened. |
Could anyone PLEASE tell me EXACTLY what you are supposed to type at the dos program? I typed C:\mysql\bin>mysql -u root mysql but it said that C:\mysql\bin wasnt recognized as an internal or external command. HELP ME!!
|
All times are GMT -4. The time now is 04:12 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.