mysql Client does not support authentication protocol requested by server; consider upgrading MySQL

安装mysql

1	sudo apt-get install mysql-server

设置mysql登录密码
1.用root 进入mysql后
mysql>set password =password('你的密码');
mysql>flush privileges;

首先我们授权一个叫Ubuntu（叫什么由你定）的账户，并授予它远程连接的权力，命令如下：

1	GRANT ALL PRIVILEGES ON *.* TO 'Ubuntu'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;

/etc/mysql/mysql.conf.d/mysqld.cnf

注释掉127.0.0.1

重启mysql

service mysql restart

　

Navicat连接MySQL Server8.0版本时出现Client does not support authentication protocol requested  by server；解决如下：

1、MySQL -u root -p

2、use mysql;

3、ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '你的密码';

4、ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的密码';

5、SELECT plugin FROM mysql.user WHERE User = 'root';

6、flush privileges;
---------------------