Access denied for user ‘xxx‘@‘xxx‘
使用root用户登录mysql:mysql -uroot
使用mysql数据库:use mysql;
创建用户:
create user xxx;(无密码)
create user xxx identified by xxx;(有密码)
授权用户权限:
grant all privileges on *.* to xxx;(无密码)
grant all privileges on *.* to xxx identified by xxx;(有密码)
...
原创
2021-08-21 14:28:27 ·
74 阅读 ·
1 评论