Mysql windows命令

1.创建用户： CREATE USER 'txmysql'@'host' IDENTIFIED BY '112344';

2. 查询所有用户 ：select user,host from mysql.user;

3.使用：use mysql;

4.修改用户所有都能访问： update user set host='%' where user='txmysql';

4.数据库权限：GRANT ALL PRIVILEGES ON *.* TO 'txmysql'@'%';

如果提示error 1410   ,使用下面的命令：

GRANT ALL ON *.* TO 'txmysql'@'%';
 flush privileges;  

用navicat连接还是报错：Client does not support authentication protocol requested by server; 

原因是mysql8默认的加密方式为caching_sha2_password 与mysql5的加密方式mysql_native_password 不同

5.解决方法-更新用户加密方式：

ALTER USER 'txmysql'@'%' IDENTIFIED WITH mysql_native_password BY '1234';