[Mysql] restoring mysql and & amp; quot; Accessdeniedf_MySQL after windows is reinstalled

[Mysql] restoring mysql and amp; quot; Accessdeniedforuseramp; amp; # x27; rootamp; amp; # x27; @ amp; a mysql database is actually a green software after windows is reinstalled, after the system is reinstalled, it can still be used.

1. reload the system and keep the original mysql installation directory and data directory.

2. create a batch file to start mysql: [run. bat] the file is stored in the bin under the mysql installation directory.

Mysqld.exe -- defaults-file = ../my-default.ini -- console

3. run. bat.

If the following error occurs during database connection: "Access denied for user 'root' @ 'IP '"

1. log on to the system as an administrator, stop the mysql service, or end the mysqld process.

2. go to the command line and go to the mysql installation directory. assume that the installation directory is d:/mysql/. run CMD to enter the command line.

3. run d:/mysql/bin/mysqld-nt -- skip-grant-tables to start mysql and disable permission check.

4. run d:/mysql/bin/mysqladmin-u root flush-privileges password

"Newpassword" reset root password

5. restart the mysql service.

In Linux, the following methods can be used:

Method 1:

#/Etc/init. d/mysql stop

# Mysqld_safe -- user = mysql -- skip-grant-tables -- skip-networking &

# Mysql-u root mysql

Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';

Mysql> flush privileges;

Mysql> quit

#/Etc/init. d/mysql restart

# Mysql-uroot-p

Enter password: <输入新设的密码newpassword>

Mysql>

Method 2:

Directly use the username and password provided in the [client] section of the/etc/mysql/debian. cnf file:

# Mysql-udebian-sys-maint-p

Enter password: <输入[client]节的密码>

Mysql> UPDATE user SET Password = PASSWORD ('newpassword') where USER = 'root ';

Mysql> flush privileges;

Mysql> quit

# Mysql-uroot-p

Enter password: <输入新设的密码newpassword>

Mysql>