系统环境:centos7.6
步骤一:首先下载mysql的yum源配置
步骤二:安装mysql的yum源
yum -y install mysql57-community-release-el7-11.noarch.rpm
步骤三:yum方式安装mysq
yum -y install mysql-server --nogpgcheck
--nogpgcheck (不校验数字签名)
步骤四:使用mysql
1.启动mysql
systemctl start mysqld
systemctl status mysqld
1) 初始化MySQL:mysqld --initialize --console
2) 修改mysql的权限:chown -R mysql:mysql /var/lib/mysql/
3) 查看MySQL的临时密码:cat /var/log/mysql/mysqld.log | grep localhost
1. 临时密码glYRtFCGk8-j
4) 启动MySQL服务:systemctl start mysqld
登录mySQL : mysql -uroot -p 临时密码
5) 使用临时密码连接MySQL之后修改密码:alter user 'root'@'localhost' identified by '1234';
6) 修改root用户的登录IP限制(开启远程登录)
a) use mysql;
update user set host ='%' where user='root';
修改登录限制(版本高会限制登录方式密码无法访问)
注意修改密码设置:ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'ylfys@hlzds';
7) 重启MySQL的服务
systemctl restart mysqld