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.
精彩评论