- 新建文件夹/opt/mysql,并cd进去
cd /opt
mkdir mysql
cd mysql
-
运行wget http://dev.mysql.com/get/mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar,下载mysql安装包
PS:centos7.6自带的类mysql数据库是mariadb,会跟mysql冲突,要先删除。 -
查询mariadb相关安装包
rpm -qa|grep mari
-
卸载mariadb
rpm -e --nodeps mariadb-libs
-
解压
tar -xvf mysql-5.7.26-1.el7.x86_64.rpm-bundle.tar
-
然后开始真正安装mysql,依次运行以下几条
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-client-5.7.26-1.el7.x86_64.rpm rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm
-
开启mysql服务
systemctl start mysqld.service
-
查看初始密码
grep "password" /var/log/mysqld.log
-
登录
mysql -uroot -p
-
然后使用该命令设置用户密码(因为他有密码强度的需要,所以这里直接初始密码复制然后加个1)
ALTER USER USER() IDENTIFIED BY '密码在初始密码上加个1';
-
然后设置密码的保密程度(用来更改密码)
set global validate_password_policy=0; # 保密级别 set global validate_password_length=1; # 密码长度
-
更改密码
alter user 'root'@'localhost' identified by '123456';