Page 1 of 1

Root User Deleted and database not found

PostPosted: 31. March 2012 20:37
by Geek101
The root user was mistakenly deleted in phpmyadmin. Using --skip-grant-tables, noticed that root exists in the mysql database. The password for this root was changed.
After all these, when trying to connect to mysql using the root user and updated password, the ff error appears: ERROR 2002(HY000) Cant connect to local mysql server though socket /opt/lampp/var/mysql/mysql.sock
Also, I realized that some databases are missing.

Can someone pls help!!!!

Re: Root User Deleted and database not found

PostPosted: 27. April 2012 21:13
by JonB
A. Since databases are held in filesets, I suspect a bit more went wrong than you believe.

B. Are you sure MySQl is actaully running?

in term as su or with sudo --

/opt/lampp/lampp status

Good Luck
8)