下载mysql yum包
http://dev.mysql.com/downloads/repo/yum/
或者wget http://repo.mysql.com/mysql57-community-release-el7-10.noarch.rpm
安装软件源:
rpm -Uvh mysql57-community-release-el7-10.noarch.rpm
安装:
yum install -y mysql-community-server
启动,状态:
service mysqld start,systemctl start mysqld.service
service mysqld status ,systemctl status mysqld.service
修改密码:
在mysql5.7之后又密码了
查看 grep 'temporary password' /var/log/mysqld.log
登录
修改密码前有一个问题,mysql会设置密码的格式,我们将密码设置为最简单的格式,
如果不设置可能会出现错误
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
选择最简单的格式:
set global validate_password_policy=0;
设置密码的长度:
set global validate_password_length=1;
修改密码:
ALTER USER 'root'@'localhost' IDENTIFIED BY 'mypassword';
让其他host也可以登录:
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
完全卸载mysql
查看安装:yum list installed mysql*
rpm -qa|grep -i mysql
卸载:
yum remove mysql mysql-server mysql-libs compat-mysql51
rm -rf /var/lib/mysql
rm /etc/my.cnf
rpm -e “rpm -qa|grep -i mysql 命令查出的软件名”
查看残留:
whereis mysql
rm -rf ...