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

c++ - C/pp Sockets, recv()/send() works only under gdb -

GO: Serve static pages -

objective c - How to open front/back camera at the same time in iOS developing? -