Shulou(Shulou.com)06/01 Report--

Environment: redhat 5.7with mysql 5.0installed

Mysql started successfully after installation, but login using mysql-uroot-p is yes, the password is wrong, make sure that the password has not been set

Error prompt: Access denied for user 'root'@'localhost' (using password: No)

The solution is as follows:

1. First shut down the mysql service xiaopeng# / etc/init.d/mysqld stop2. Enter the operation command xiaopeng# mysqld_safe-- user=mysql-- skip-grant-tables-- skip-networking & 3. Connect mysqlxiaopeng# mysql-uroot mysqlmysql > update user set Password=PASSWORD ('newpassword') where USER='root';mysql > flush PRIVILEGES;mysql > quit4. Restart the mysql service xiaopeng# / etc/init.d/mysqld restartxiaopeng# mysql-uroot-pEnter password:

For more resources, please visit www.arppinging.com

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.