Privileges

[bobbe]

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

[Nobbie]

If you changed the priviliges of "root", you cannot reset priviledges and actually have destroyed your Database. You should install from scratch again.

[glitzi85]

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