How to solve the problem of LAMP configuring MYsql 1045

This article will explain in detail how to solve the LAMP configuration MYsql 1045 problem, Xiaobian thinks it is quite practical, so share it with you as a reference, I hope you can gain something after reading this article.

LAMP configuration MYsql 1045 Question:

Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)

LAMP configuration MYsql Question-1045 specific methods are:

1. First find the my.ini configuration file in the installation directory and open the configuration file.

2. Find the line [mysqld], add skip-grant-tables below, save the file, and restart mysql service;

Windows 7 installed mysql5.1,error1045, after deleting the instance the service can not start, tried a lot of methods can not be solved, *** reinstalled a beta 6.0, appeared when just installed 5.1 initial error error 1045 final error resolution:

1、mysql -u root

2、use mysql

3、update user set password=old_password('scf') where user='root' and host='localhost' ;

4、FLUSH PRIVILEGES;

Error 1045(28000) Access Denied for user 'root'@'localhost' (Using password:NO)

About "how to solve the LAMP configuration MYsql 1045 problem" this article is shared here, I hope the above content can be of some help to everyone, so that you can learn more knowledge, if you think the article is good, please share it for more people to see.