PDA

View Full Version : Error 1045


Bladees1739
12-12-2004, 11:48 PM
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

mattmeck
12-13-2004, 01:16 AM
chancer are you didnt get the "grant" command done correcly.

Muuss
12-13-2004, 03:58 AM
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
12-13-2004, 10:04 PM
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
12-14-2004, 07:27 AM
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