环境 centos 7.4
安装
rm -rf /var/lib/mysql[请选确保要先删除mysql这个文件夹,不然mysql 初始化不了,启动会失败]
- cd /usr/local/src [定位到这个目录下放rpm源]
- wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
- rpm -ivh mysql57-community-release-el7-11.noarch.rpm
- yum install -y mysql-server
- systemctl start mysqld 或 service mysqld start
- service mysqld status [输出的最后一句是Started MySQL Server表示启动成功]
- cat /var/log/mysqld.log | grep ‘temporary password’ [会输出初始密码 : 后面的就是]
- mysql -uroot -p [输入密码登入]
- set global validate_password_length=4; [设置新密码最小长度为4]
- set global validate_password_policy=0; [不校验密码规则]
- set global validate_password_mixed_case_count=0;
- validate_password_special_char_count=0;
- set global validate_password_number_count=0;
set password for ‘root’@’localhost’=password(‘intput you password here’);
安这个步骤来一般是没有问题的,如果有问题,可以查看/var/log/mysql.log中查看启动报错原因,一般都是权限和/var/lib/mysql文件没删除
卸载
- rpm -qa | grep mysql
- yum remove mysql mysql-server mysql-libs mysql-community-common mysql57-community-release
- rpm -qa | grep mysql [看下是否删除干净]
- rm -rf /var/lib/mysql [这个要删除,不然重新安装的时候报已有文件的错]
- rm -rf /etc/my.cnf