内核问题

由于使用了ppoll所以需要内核版本>=4.10

  1. CREATE USER 'zc'@'%'; -- 创建用户
  2. drop user '#userName'@'#host'; -- 删除用户
  3. ALTER USER 'root'@'%' IDENTIFIED BY 'Mydb2019'; -- 设置用户密码
  4. CREATE USER 'myus'@'%' IDENTIFIED BY 'MY.2021us';
  5. -- 授权
  6. -- select host, user, authentication_string, plugin from mysql.user;
  7. GRANT all privileges on #databaseName.#table to '#userName'@'#host';
  8. GRANT select,insert,update,delete,create,index on #databaseName.#table to '#userName'@'#host';
  9. revoke #auth on #databaseName.#table from '#userName'@'#host'; -- 撤销权限
  10. SHOW GRANTS for '#userName'@'#host'; -- 查看授权
  11. FLUSH PRIVILEGES; -- 刷新修改
  12. USAGE -- 为默认权限，不可撤销
  14. GRANT Event ON *.* TO 'zc'@'%';
  15. GRANT Show databases ON *.* TO 'zc'@'%';
  17. -- Public Key Retrieval is not allowed
  18. allowPublicKeyRetrieval=true&useSSL=false