Navicat连接时报错解决

update mysql.user set authentication_string=PASSWORd('root'),plugin='mysql_native_password' where user='root';

flush privileges;  刷新操作

use mysql;

  update user set Host='%' where User='root';

 修改bind_address

    vim/etc/mysql/mysql.conf.d/mysql.cnf

    修改43行的bind_address=127.0.0.1为bind_address=0.0.0.0

 注意在云服务器上开放3306端口

   重启mysql服务 service mysql restart

	使用navicat远程连接root用户
		在xshell环境中，进入到mysql，然后修改其他主机可以使用root用户远程登录。
			首先需要设置云服务的root用户的可连接的主机
				登录mysql环境，use mysql;    使用mysql数据库
				查看mysql数据库中的user表中的host和user字段
					select host,user from user;
				update user set Host='%' where User='root';
				update user set Host='%' where User='briup';
			修改bind_address
				vim /etc/mysql/mysql.conf.d/mysqld.cnf
				修改43行的bind_address=127.0.0.1为bind_address=0.0.0.0
			重启mysql服务
				service mysql restart
			开放3306端口
				阿里云控制台，防火墙，开放3306端口

  在云服务器下进入MySQL

root@iZuf61hxamnn64sbn0yjm0Z:~# mysql -uroot -p

  输密码

mysql>use mysql
 Database changed

mysql> select user,host from user;
+------------------+-----------+
| user             | host      |
+------------------+-----------+
| root             | %         |
| debian-sys-maint | localhost |
| mysql.infoschema | localhost |
| mysql.session    | localhost |
| mysql.sys        | localhost |
+------------------+-----------+
5 rows in set (0.00 sec)

 注意root在localhost下是%

mysql> ALTER USER 'root'@'%' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.01 sec)

  输入自己的密码，假如为123

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123';
Query OK, 0 rows affected (0.01 sec)

  刷新

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)