首先下载去mysql官网下载Yum 资源包:https://dev.mysql.com/downloads/repo/yum/
图里框起来的那一段就是文件名,替换下面这个链接,然后在服务器上下载
wget http://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm
rpm -ivh mysql-community-release-el7-5.noarch.rpm
yum update
yum install mysql-server
权限设置:
chown mysql:mysql -R /var/lib/mysql
初始化 MySQL:
mysqld –initialize
如果初始化失败,一般会提示修改mysql 的配置文件
配置my.cnf,加入user=mysql 即可
启动 MySQL:
service mysqld start
查看 MySQL 运行状态:
service mysqld status
查看临时密码:
grep “A temporary password” /var/log/mysqld.log;
登录
mysql -uroot -p
#修改密码验证规则,来设置简单的密码
set global validate_password.policy=0;
set global validate_password.length=1;
修改密码
ALTER USER user() IDENTIFIED BY ‘123456’;
查看root账户是否可以远程登录
use mysql;
select user,host from user;
+——————+———–+
| user | host |
+——————+———–+
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
| root | localhost |
+——————+———–+
4 rows in set (0.00 sec)
设置远程登录
update user set host = ‘%’ where user = ‘root’;
Query OK, 1 row affected (0.01 sec)
FLUSH PRIVILEGES;
这个时候会发现远程登录密码不对,继续改密码
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
这个时候就ok。