Problems with the Linux version of XAMPP, questions, comments, and anything related.
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?
- Posts: 1
- Joined: 21. August 2010 09:28
If you changed the priviliges of "root", you cannot reset priviledges and actually have destroyed your Database. You should install from scratch again.
- Posts: 9058
- Joined: 09. March 2008 13:04
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;
- 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 5 guests