安装
环境说明: centos7.6
myslq版本: mysql5.7
迅雷或者wget下载(别问我为啥用迅雷,因为快)
cd /usr/local/src
wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
mkdir -p /usr/local/mysql5.7 && cd /usr/local/mysql5.7
tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql5.7
卸载自带的mariadb
rpm -qa|grep mariadb
yum -y remove mariadb-libs
由于依赖关系,请按以下顺序执行安装
rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
启动mysqld 并设置开机启动
systemctl start mysqld
systemctl enable mysqld
systemctl status mysqld
从日志文件查找临时密码
grep "password" /var/log/mysqld.log
登录
mysql -uroot -p"zS+u&ro49wbo"
修改root的密码
alter user 'root'@'localhost' identified by 'root1234ABCD!@#$';
测试是否修改成功
mysql -uroot -proot1234ABCD\!\@\#\$
这是默认的密码复杂度及长度限制。我们修改一下,不然每次敲密码要死人。。。测试使用,可以这么干,生产还是保持默认的好点。。