My SQL 远程连接

//打开数据库mysql -u root -p -P 3306;
//显示所有数据库show databases;
//退出数据库exit;

password字段改成了authentication_string
原SELECT User, password,FROM user;
现SELECT User, authentication_string,Host FROM user;

授权允许远程连接

1.所有用户和 指定IP地址的用户

create user 'xixi'@'192.168.1.140' identified by 'qaz904904' ;
grant all privileges on *.* to 'xixi' @'192.168.1.140' ;

创建用户create user 'UserName'@'localhost' identified by '123123';
赋予权限grant all privileges on . to 'UserName'@'localhost' ;

安装MySQL ODBC 3.51 Driver
安装MySQL ODBC_参考
c#远程访问MySQL数据库_参考

报错1：Access denied for user 'test'@'%' to database ';'
解决参考https://blog.csdn.net/roy_70/article/details/82669138

报错2：uthentication plugin 'caching_sha2_password' cannot be loaded: 找不到指定的模块

解决参考https://blog.csdn.net/u011182575/article/details/80821418

ALTER USER 'test'@'%'  IDENTIFIED BY '123' PASSWORD EXPIRE NEVER;
ALTER USER 'test'@'%'  IDENTIFIED WITH mysql_native_password BY '123'; 
alter user 'test'@'%'  identified by '123' ;