Error 1045

[Bladees1739]

I am getting this error I looked through all the guilds and most of the search.


ERROR 1045: Access denied for user: '@localhost' (Using password: NO)

The My.ini looks like this.

[mysqld]
basedir=E:/mysql
#bind-address=192.168.1.101
datadir=E:/mysql/data
#language=E:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=E:/mysql/bin/mysqld-nt.exe
user=loser
password=fast

chancer are you didnt get the "grant" command done correcly.

[Muuss]

or didn't even fullfilled db.ini (from eqemu), since it says that there's no account passed as mysql login, re-read your server install guide.

[Lanfo]

I had this problem, and fixed it by changing my password and user name in my.ini then just re-did the GRANT ALL PRIV command.

open cmd promtp

(I had to use this method because it kept getting an error)

cd c:\mysql\bin
mysql -u root mysql

GRANT ALL PRIVILEGES TO *.* user@localhost IDENTIFIED BY 'pass' WITH GRANT OPTION;

[kiladiveus]

i was having this issue too when i need to enter new query. This might be noob stuff but it worked for me.

type mysql -u USERNAME -p
then it will prompt for mysql password.

i guess this would work as well
type mysql -u USERNAME -p PASSWORD