【MySQL Database】install mysql 8.0 on centos 7.5


[root@wallet01 ~]# cat >> /etc/hosts <> /etc/security/limits.conf < select version();
+-----------+
| version() |
+-----------+
| 8.0.22    |
+-----------+
1 row in set (0.00 sec)
mysql> create user 'root'@'%' identified by 'abcd.1234';
Query OK, 0 rows affected (0.04 sec)

mysql> grant all privileges on *.* to `root`@`%`;
Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> alter user 'root'@'%' identified with mysql_native_password by 'abcd.1234';
Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)