Root User Deleted and database not found

Problems with the Linux version of XAMPP, questions, comments, and anything related.

Root User Deleted and database not found

Postby Geek101 » 31. March 2012 20:37

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!!!!
Geek101
 
Posts: 1
Joined: 31. March 2012 20:16
XAMPP Version: 1.7.1
Operating System: Linux

Re: Root User Deleted and database not found

Postby JonB » 27. April 2012 21:13

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)
User avatar
JonB
AF Moderator
 
Posts: 3210
Joined: 12. April 2010 16:41
Location: Land of the Blazing Sun
XAMPP Version: 1.8.3-2
Operating System: Windows XP/7 - Fedora 15 1.7.7


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 4 guests