LAMP MYsql configuration-1045

LAMPConfigurationFor MYsql 1045Problem:

When installing a mysql database in a windows operating system and encountering an Error of Error 1045 (28000) Access Denied for user 'root' @ 'localhost' (Using password: NO), you need to reset the password.

The specific method for LAMP to configure MYsql-1045 is as follows:

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

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

Mysql5.1 and error1045 are installed in Windows 7. After the instance is deleted, the service cannot be started. After trying many methods, it cannot be solved. Finally, a 6.0 beta version is reinstalled, the initial error 5.1 is displayed when 1045 is installed. The final error is resolved:

1. mysql-u root

2. use mysql

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

4. flush privileges;

In this way, Error 1045 (28000) Access Denied for user 'root' @ 'localhost' (Using password: NO) Error 1045 can be solved!

MySQL cannot be remotely connected under LAMP in Ubuntu Server 1130

MySQL cannot be remotely connected under LAMP in Ubuntu Server 10061

Five Simple Methods for optimizing the LAMP application: optimizing the database