ubuntu18 安装mysql8安装包_Centos 8下Mysql8的安装，以及远程Navicat适配（面向纯小白）...

mkdir /usr/local/Mysql

tar -xvf mysql-8.0.21-1.el8.x86_64.rpm-bundle.tar

rpm -ivh mysql-community-client-8.0.21-1.el8.x86_64.rpm
rpm -ivh mysql-community-server-8.0.21-1.el8.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.21-1.el8.x86_64.rpm

mysql -V

service mysqld start

service mysqld status

grep "password" /var/log/mysqld.log

mysql -u root -p '所得密码'

alter user user() identified by '你的新密码';

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

flush privileges;

mysql -u root -p
enterpassword:输入密码

use mysql;

select user,host from user; 

update user set host = ‘%’ where user = ‘root’; 

flush privileges;

mysql -u root -p -h远程主机ip地址 -P3306

firewall-cmd --zone=public --add-port=3306/tcp --permanent

mysql -u root -p

mysql> use mysql;

mysql> select user,host from user;

+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| admin            | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
| zhangj           | localhost |
+------------------+-----------+

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '新的简单密码';

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '新的简单密码';