安装 MySQL5.6
- 卸载 mariadb,否则安装 mysql 会出现冲突
执行命令rpm -qa | grep mariadb
列出所有被安装的 mariadb rpm 包
执行命令rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
- 添加官方的 yum 源,编辑文件,
vim /etc/yum.repos.d/mysql-community.repo
写入下列内容[mysql56-community] name=MySQL 5.6 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/ enabled=1 gpgcheck=0 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
- 安装 mysql 数据库
yum install mysql-community-server
- 启动mysql数据库
systemctl start mysqld.service
- 查看运行状态
systemctl status mysqld.service
- 登陆
mysql -uroot -p
没有密码。注:mysql 5.6 版本默认没有密码。 - 修改密码 SET PASSWORD = PASSWORD(“root”);
- 远程访问出错,修改
update user set host = '%' where user = 'root';
刷新 flush privileges;
安装 MySQL5.7
- 卸载 mariadb,否则安装 mysql 会出现冲突
执行命令rpm -qa | grep mariadb
列出所有被安装的 mariadb rpm 包
执行命令rpm -e --nodeps mariadb-libs-5.5.56-2.el7.x86_64
- 下载并安装MySQL官方的 Yum Repository ,下载命令:
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
,大概 25KB 的样子。使用命令安装:yum -y install mysql57-community-release-el7-10.noarch.rpm
- 安装 mysql 数据库
yum -y install mysql-community-server
- 启动mysql数据库
systemctl start mysqld.service
- 查看运行状态
systemctl status mysqld.service
- 查看MySQL 的初始密码:
grep "password" /var/log/mysqld.log
登陆mysql -uroot -p
- 修改密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
若密码过于简单会报错。可通过命令查看密码的设置规则:SHOW VARIABLES LIKE 'validate_password%';
,也可修改设置规则:
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
然后在执行修改密码的命令:ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
9. 远程访问出错,修改 update user set host = '%' where user = 'root';
刷新 flush privileges;