The solution to the disappearance of mysql database caused by an error in modifying root in mysql
An error occurred while updating the ROOT password today
Update user set password='123456' where user = "root" is wrong to write like this
Should be update user set password = password ('123456') where user = "root"
After the wrong operation, the mysql database disappeared.
Solution:
Close / etc/init.d/mysqld stop
Then, usr/bin/mysqld_safe-- skip-grant-tables
Start / etc/init.d/mysqld start
Mysql-u root
Mysql > use mysql
Mysql > UPDATE user SET Password=PASSWORD ('xxx') WHERE user='root'
