- 进入官网
https://dev.mysql.com/downloads/
,选择MySQL Yum Repository,下载合适自己系统的版本wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
- 安装
sudo rpm -ihv mysql80-community-release-el7-3.noarch.rpm
- yum安装
sudo yum install mysql-community-server
- 修改密码,远程登录
查看密码
[root@xhx151 lib]# cat /var/log/mysqld.log |grep password
2019-12-28T22:19:56.048362Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: Pp.3WDzRVIe=
修改密码,权限
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.01 sec)
mysql> alter user 'root'@'localhost' identified with mysql_native_password by 'xuhaixing';
Query OK, 0 rows affected (2.81 sec)
mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
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)
mysql> update user set host='%' where user = 'root';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1 Changed: 1 Warnings: 0
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)
mysql> select user, host from user;
+------------------+-----------+
| user | host |
+------------------+-----------+
| root | % |
| mysql.infoschema | localhost |
| mysql.session | localhost |
| mysql.sys | localhost |
+------------------+-----------+
4 rows in set (0.00 sec)
mysql>
实时内容请关注微信公众号,公众号与博客同时更新:程序员星星