开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜