January 8th, 2014, 01:25 AM
Granting Privileges to MySQL
this is my scenario, previously I added 3 users in my MySQL Database server (XAMPP), a while ago, I tried to delete some users by using
DROP USER 'username'@'host'
however I deleted user 'root' @ 'localhost' then all of a sudden it seems like my database has been deleted or whatever. I only see information_schema and test databases in my PHPMYADMIN. Is there a way to retrieve my database?
XAMPP prompts me that there is no privilege to (create user, grant privilege, create database) for user ''@'localhost' while I am using ROOT user which has all the privileges.
Any help would be appreciated!! Thank you and Happy new year!