The other day I executed by mistake a SQL sentence and everything seems to disappear.
GRANT ALL PRIVILEGES ON `net`.* TO 'shevek'@'localhost'
Shevek seems to have all the privileges as it was the user I created since installing MySQL and every was ok.
If I type "show grants for shevek;" it shows
GRANT ALL PRIVILEGES ON *.* TO 'shevek'@'%' IDENTIFIED BY PASSWORD 'encrypted pass' WITH GRANT OPTION |
1 row in set (0.00 sec)
But I type "show grants for shevek@localhost;" it shows
GRANT USAGE ON *.* TO 'shevek'@'localhost' IDENTIFIED BY PASSWORD 'encrypted pass' |
GRANT ALL PRIVILEGES ON `netjuke`.* TO 'shevek'@'localhost'
I cant see any databases I had created and any command I type to revoke it says "Access denied for user: 'shevek@localhost' (Using password: YES)"
Any help?
GRANT ALL PRIVILEGES ON `net`.* TO 'shevek'@'localhost'
Shevek seems to have all the privileges as it was the user I created since installing MySQL and every was ok.
If I type "show grants for shevek;" it shows
GRANT ALL PRIVILEGES ON *.* TO 'shevek'@'%' IDENTIFIED BY PASSWORD 'encrypted pass' WITH GRANT OPTION |
1 row in set (0.00 sec)
But I type "show grants for shevek@localhost;" it shows
GRANT USAGE ON *.* TO 'shevek'@'localhost' IDENTIFIED BY PASSWORD 'encrypted pass' |
GRANT ALL PRIVILEGES ON `netjuke`.* TO 'shevek'@'localhost'
I cant see any databases I had created and any command I type to revoke it says "Access denied for user: 'shevek@localhost' (Using password: YES)"
Any help?