1、關閉mysql服務

service mysqld stop

2、清理datadir(本例中指定的是/var/lib/mysql)指定的目錄下的文件，將該目錄下的所有文件刪除或移動至其他位置

cd /var/lib/mysql

mv * /opt/mysql_back/

3、初始化實例

/usr/local/mysql/bin/mysqld --initialize --user=mysql

4、重復安裝過程中創(chuàng)建用戶的步驟，修改默認密碼，重新創(chuàng)建數(shù)據(jù)庫和用戶即可

/usr/local/mysql/bin/mysql -uroot -p

mysql> set password = 'mysqltest123';

mysql>create database ecology;

mysql> create user ecology identified with mysql_native_password by 'ecology123';

mysql> grant all privileges on *.* to 'ecology'@'%';

mysql> flush privileges;