sql - event scheduler won't turn on (mysql) -
When I tried this code:
for 'secret' @ local host Show the socket;
This is the result:
Grant for the secret @ localhost grant * *. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Give all the rights to the 'secret' @ 'localhost' on 'cryptic _db1x`. * 'Secret' @ 'localhost'
But when I want to set event_scheduler to
SET Global event_scheduler = "ON"
This error shows:
# 1227 - Access denied;
Then tried this code:
on grant * *. * To do this you need (at least one) Super privilege (s) for this work is required; Secret '' Domestic host '' was identified by 'secret'; Flush Pvt .;
and then error:
User denied 'login' to 'localhost' (using password: yes)
< / Pre>I know that I am using the root, I have used the username and password to access the control panel of my domain.
check this
I think you need the code: * All Trust Privileges * TO 'secret_user @ localhost'; Flush Pvt .;
Check for more information.
Comments
Post a Comment