The MySQL database is actually green software and can still be used after reloading the system.
1. After reinstalling the system, keep the original MySQL installation directory and data directory.
2. Make a batch file to start MySQL: "Run.bat" The file is stored under the bin in the MySQL installation directory.
Mysqld.exe--defaults-file=. /my-default.ini--console
3, the implementation of Run.bat can be.
If the following error occurred while connecting to the database: "Access denied for user ' root ' @ ' IP '"
1. Admin login system, stop MySQL service or end mysqld process
2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is d:\mysql\, CMD enters the command line
3. Run d:\mysql\bin\mysqld-nt--skip-grant-tables start MySQL, turn off check of permissions
4. Run d:\mysql\bin\mysqladmin-u root flush-privileges password "newpassword" Reset root password
5. Restart the MySQL service
Linux systems can be used in the following ways:
Method One:
#/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: < Enter the newly set password newpassword>
Mysql>
Method Two:
Use the user name and password provided directly in the [client] section of the/etc/mysql/debian.cnf file:
# mysql-udebian-sys-maint-p
Enter Password: < Enter the password for the [client] section >
mysql> UPDATE user SET Password=password (' NewPassword ') where user= ' root ';
mysql> FLUSH privileges;
Mysql> quit
# mysql-uroot-p
Enter Password: < Enter the newly set password newpassword>
Mysql>