开发者

I am logged into mysql as root but cannot grant extra privileges to users

开发者 https://www.devze.com 2023-04-10 14:50 出处:网络
I am logged into mysql as the root user and trying to setup MYSQL Replication. I have already setup my database as a Master but when I try the \'show master status;\' command its saying:

I am logged into mysql as the root user and trying to setup MYSQL Replication. I have already setup my database as a Master but when I try the 'show master status;' command its saying:

ERROR 1227 (42000): Access denied; you need the SUPER,REPLICATION CLIENT privile ge for this operation

When I try and add these privileges to the root user I am getting:

ERROR 1045 (28000): Acc开发者_Python百科ess denied for user 'root'@'%' (using password: YES)

Im lost as to what I can do at this point.

Any help would be greatly appreciated,

Thanks in advance!


It might be necessary that you have to be on localhost, not on a remote machine.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号