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

[Mysql] restoring mysql and amp; quot; Accessdeniedforuseramp; amp; #39; rootamp; amp; #39; @ amp; #3 the mysql database is actually a green software and can continue to be used after the system is reinstalled.

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" to reset the 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>

Zookeeper