8.0mysql远程

8.0mysql

修改密码

mysql -uroot -p

use mysql;

ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘123456’;

配置远程：

mysql -uroot -p
use mysql;
//Mysql默认不允许远程登录，所以需要开启远程访问权限
select user,authentication_string,host from user;
update user set host = ‘%’ where user = ‘root’;
FLUSH PRIVILEGES;
//navicat 连接 mysql 出现Client does not support authentication protocol requested by server

alter user ‘root’@’%’ identified with mysql_native_password by ‘123456’;

配置文件路径：

/etc/mysql/mysql.conf.d

bind-address =0.0.0.0

skip-grant-tables #绕过权限检测