Apache Friends Support Forum

Hello I had sql up and running just fine this past weekend....I logged into my computer to continue on my work and now all the databases seem to be missing the main sql database with users and permissions which I spent alot of time setting up and getting it working is gone. It is only seeing two DB information schema and test. They were there and I can not imagine they disappeared not to mention I spent hours creating the database and tables I needed to only see that that is also missing. I am using Ubuntu 13.04 with xampp 1.8.1. Thank you in advance.

Edit: Apparently the tables exist but now in a different folder than they were originally it seems that they were in /opt/lampp/var/mysql/mysql but now they seem to be in the /opt/lampp/share/mysql.....How could they possibly move themselves. Am I missing something? It was working.

I was wrong apparently I dont the proper credentials can someone help me fix this I used SELECT * FROM mysql.user WHERE user = 'root' and got this response
#1142 - SELECT command denied to user ''@'localhost' for table 'user'

would have liked to have learned what the issue was but just dont have the hours, great resource i re-extracted the tar

Any@localhost / %@localhost / @localhost is an anonymous user
MySQL chooses the user to login by sorting all users first for HOST and then for username.
If your Anonymous user is the one which matches most of multiple users (e.g. because you don't have a specific root user for host localhost but just for Any Host), then it will be the user to choose.

shizoma wrote:but just dont have the hours, great resource

You are getting free support from volunteer users here. I don't know what you expected