MySQL 重新初始化实例
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、重复安装过程中创建用户的步骤，修改默认密码，重新创建数据库和用户即可
/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;