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

Popular posts from this blog

java - org.apache.http.ProtocolException: Target host is not specified -

java - Gradle dependencies: compile project by relative path -

ruby on rails - Object doesn't support #inspect when used with .include -