当前位置:数据库 > Access >>

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)2

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) ************** [root@centos mysql-5.0.41]# chown -R root /usr/local/mysql [root@centos mysql-5.0.41]# chown -R mysql /home/mysql [root@centos mysql-5.0.41]# chgrp -R mysql /usr/local/mysql [root@centos mysql-5.0.41]# cp support-files/mysql.server /etc/rc.d/init.d/mysqld [root@centos mysql-5.0.41]# chown root.root /etc/rc.d/init.d/mysqld [root@centos mysql-5.0.41]# chmod 755 /etc/rc.d/init.d/mysqld [root@centos mysql-5.0.41]# chkconfig --add mysqld [root@centos mysql-5.0.41]# chkconfig --list mysqld mysqld 0:off 1:off 2:on 3:on 4:on 5:on 6:off [root@centos mysql-5.0.41]# chkconfig --levels 245 mysqld off [root@centos mysql-5.0.41]# echo "/usr/local/mysql/bin/mysqld_safe --user=mysql &" >> /etc/rc.d/rc.sysinit [root@centos mysql-5.0.41]# /usr/local/mysql/bin/mysqld_safe --user=mysql & [1] 3123 [root@centos mysql-5.0.41]# Starting mysqld daemon with databases from /home/mysql [root@centos mysql-5.0.41]# netstat -tnl :::* LISTEN [root@centos mysql-5.0.41]# /usr/local/mysql/bin/mysql -u root mysql> use mysql; mysql> select Host,User,Password,Select_priv,Grant_priv from user; mysql> delete from user where user=''; mysql> select Host,User,Password,Select_priv,Grant_priv from user; mysql> use mysql; mysql> DELETE FROM mysql.user WHERE Host='localhost' AND User=''; mysql> select Host,User,Password,Select_priv,Grant_priv from user; mysql> FLUSH PRIVILEGES; mysql> delete from user where password=''; mysql> delete from user where host=''; mysql> select Host,User,Password,Select_priv,Grant_priv from user; mysql> select Host,User,Select_priv,Grant_priv from user; mysql> /usr/local/mysql/bin/mysql -u root [root@centos mysql-5.0.41]# /usr/local/mysql/bin/mysql -u root mysql> flush privileges; mysql> select user(); [root@centos mysql-5.0.41]# /usr/local/mysql/bin/mysql -u root 就这些! 我根本就没设置密码! 推出mysql 后 就进不去了 怎么解决啊!
Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,