mysql单机安装-centos

1. 进入官网https://dev.mysql.com/downloads/，选择MySQL Yum Repository，下载合适自己系统的版本 wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
2. 安装 sudo rpm -ihv mysql80-community-release-el7-3.noarch.rpm
3. yum安装 sudo yum install mysql-community-server
4. 修改密码，远程登录

查看密码

[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> 

实时内容请关注微信公众号，公众号与博客同时更新：程序员星星