Grant privileges for root user

Problems with the Windows version of XAMPP, questions, comments, and anything related.

Grant privileges for root user

Postby sushma » 17. March 2015 08:22

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.
sushma
 
Posts: 3
Joined: 17. March 2015 08:01
Operating System: windows 7

Re: Grant privileges for root user

Postby Nobbie » 17. March 2015 11:48

Nobbie
 
Posts: 8762
Joined: 09. March 2008 13:04

Re: Grant privileges for root user

Postby sushma » 17. March 2015 12:45

I have tried this also but its not allowing to do that giving access denied error.
sushma
 
Posts: 3
Joined: 17. March 2015 08:01
Operating System: windows 7

Re: Grant privileges for root user

Postby Altrea » 17. March 2015 12:52

Are you really sure you have started MySQL with the skip-grant-tables flag?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Grant privileges for root user

Postby sushma » 17. March 2015 13:07

skip-grant-tables is not working in mysql.
sushma
 
Posts: 3
Joined: 17. March 2015 08:01
Operating System: windows 7

Re: Grant privileges for root user

Postby Altrea » 17. March 2015 22:28

So? Why do you think it is described in the official MySQL documentation?
http://dev.mysql.com/doc/refman/5.6/en/ ... ant-tables
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8286
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 50 guests