Access denied for user 是for 哪个user,如果你设定了这个用户的密码,比如你设了root密码,要进入mysql: mysql -u root也会提示Access denied ..的。必须明确指定-p: mysql -u root -p,输入密码才能进入mysql。你可以进入mysql后,use mysql,进入mysql库,select * from user,看看有没你的这个被denied的user@???,若没有,可以grant all on *.* to user@???,然后再试。
使用root用户或者给该用户分配权限都可以解决此问题。
mysql>grant all on *.* to qqhong@'%' identified by '111';
#2005-1-27 9:42:19#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions[mysqld]
basedir=C:/mysql
#bind-address=192.168.1.4
default-character-set=gbk
datadir=C:/mysql/data
#language=C:/mysql/share/your language directory
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=C:/mysql/bin/mysqld-nt.exe
user=root
password=admin为什么连接用 root 密码 admin 还提示 ERROR 1045: