Page 1 of 1

Grant privileges for root user

PostPosted: 17. March 2015 08:22
by sushma
I have by mistakenly revoke all privileges of root user. I can not grant it again event i am not able to create new user for system.Please suggest mi solution.

Re: Grant privileges for root user

PostPosted: 17. March 2015 11:48
by Nobbie

Re: Grant privileges for root user

PostPosted: 17. March 2015 12:45
by sushma
I have tried this also but its not allowing to do that giving access denied error.

Re: Grant privileges for root user

PostPosted: 17. March 2015 12:52
by Altrea
Are you really sure you have started MySQL with the skip-grant-tables flag?

Re: Grant privileges for root user

PostPosted: 17. March 2015 13:07
by sushma
skip-grant-tables is not working in mysql.

Re: Grant privileges for root user

PostPosted: 17. March 2015 22:28
by Altrea
So? Why do you think it is described in the official MySQL documentation?
http://dev.mysql.com/doc/refman/5.6/en/ ... ant-tables