can`t log into sql-server

[mmmaniac]

I`m using eqemu 0.4.3
WindowsXP pro
mysql4.0.12
I

[Trumpcard]

You're not doing the GRANT right apparently...

GRANT gives the user name and password you specify in the Loginserver.ini privileges to the database...

Verify you can log in with the username and password you did the grant with (mysql -u username -P password or some such, you can find the exact instructions on the mysql website).

If it doesnt work, you need to do the grant command correctly...

[mmmaniac]

I tried to login with
mysql -u eqemu -p blahblah
it appears a question for the password and when I type it
it says:
Error 1045: Access denied for user: 'eqemu@127.0.0.1' (using password: yes)

I definitly used the accountname and password I created at the install of mysql

[Trumpcard]

Well then, your grant privileges command didnt work, and you need to try it again.


Do a search on 'grant all privileges' on the forums and you'll find about 50 posts with the exact instructions.

[monitor]

had the same problem a while ago, went back to old mysql 3.23 and everything seemed to work

Balsca

[monitor]

had the same problem a while ago, went back to old mysql 3.23 and everything seemed to work

Balsca

[Elrach]

Try this:

The syntax clearly says that the password must not be separated with a space from the '-p'. If you do, it takes our password as the database name. And of course, that won't exist.


mysql -u <username> -p<passwd> <database>

or

mysql -u <username> -p <database>

The second one will just prompt you for a password afterwards. Key it in, and voila![/code]

[Elrach]

Grrr, double post.