Privileges

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

Privileges

Postby bobbe » 21. August 2010 10:29

I have installed XAMPP 1.7.3a on Ubuntu 10.04 and created 3 databases with phpmyadmin. After, in the label "privileges" di phpmyadmin i have cheked a box and now when i go in phpmyadmin, in section "Actions" - Mysql database i find the message "none privileges" red coulored and on the left there are not the 3 databases i have created. How can i restore the privileges?
Thank you.

bobbe
bobbe
 
Posts: 1
Joined: 21. August 2010 09:28

Re: Privileges

Postby Nobbie » 21. August 2010 10:51

If you changed the priviliges of "root", you cannot reset priviledges and actually have destroyed your Database. You should install from scratch again.
Nobbie
 
Posts: 8759
Joined: 09. March 2008 13:04

Re: Privileges

Postby glitzi85 » 23. August 2010 09:27

If you've changed the permissions for the root user, please carefully read the following document:
http://dev.mysql.com/doc/refman/5.1/en/ ... sions.html
Then scroll down to the comment of Cameron James from January 13 2010 2:41pm.
If you revoked yourself the GRANT_OPTION, then you have to use this statement instead:
Code: Select all
GRANT ALL PRIVILEGES ON *.* TO root@localhost WITH GRANT OPTION;


glitzi
User avatar
glitzi85
 
Posts: 1920
Joined: 05. March 2004 23:26
Location: Dahoim


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 6 guests