Missing SQL Tables

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

Missing SQL Tables

Postby shizoma » 28. May 2013 23:50

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.
shizoma
 
Posts: 3
Joined: 28. May 2013 22:56
XAMPP Version: 5.6.3
Operating System: Ubuntu 13.04

Re: Missing SQL Tables

Postby shizoma » 29. May 2013 00:24

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'
shizoma
 
Posts: 3
Joined: 28. May 2013 22:56
XAMPP Version: 5.6.3
Operating System: Ubuntu 13.04

Re: Missing SQL Tables

Postby shizoma » 29. May 2013 00:41

would have liked to have learned what the issue was but just dont have the hours, great resource i re-extracted the tar
shizoma
 
Posts: 3
Joined: 28. May 2013 22:56
XAMPP Version: 5.6.3
Operating System: Ubuntu 13.04

Re: Missing SQL Tables

Postby Altrea » 29. May 2013 05:20

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 :shock:
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 6836
Joined: 17. August 2009 13:05
XAMPP Version: 5.5.19
Operating System: Windows 10 Pro x64


Return to XAMPP for Linux

Who is online

Users browsing this forum: No registered users and 8 guests