Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MySQL privileges

Status
Not open for further replies.

gasca

Programmer
Apr 2, 2003
22
ES
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top