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 后 就进不去了
怎么解决啊!