授权用户,8.0版本创建用户和授权要分开写,密码方式也和5.5版本有区别 create user ‘aulgx’@’%’ identified by ‘passwd’; GRANT all PRIVILEGES ON . TO ‘aulgx’@’%’; ALTER USER ‘aulgx’@’%’ IDENTIFIED WITH mysql_native_password BY ‘passwd’;
如果不加WITH mysql_native_password 的话连接会报密码错误或者下面的错 ERROR 2059 (HY000): Authentication plugin ‘caching_sha2_password’ cannot be loaded: /wdata/server/mysql/lib/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory