Missing database on reset?

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

Missing database on reset?

Postby interloperux » 27. April 2015 09:59

Hi,

I recently revisited a website I was designing last year but ran low on time to finish. I couldn't remember the password for phpMyAdmin so I poked around in my XAMPP directory and found resetroot.bat -- now I can access phpMyAdmin, but my database isn't listed. I'm presuming it's still in existence because restarting XAMPP didn't suddenly break everything. Clearly I should have googled a little harder before running some random reset script. Could anyone suggest a solution?

Thanks.
interloperux
 
Posts: 1
Joined: 27. April 2015 09:54
Operating System: Windows 7 x64

Re: Missing database on reset?

Postby Altrea » 27. April 2015 10:06

Hi,

I net you are not running as root but as anonymous user or accessing a wrong MySQL installation.
To prove that open phpmyadmin go to your SQL tag and type in the following command
Code: Select all
SELECT CURRENT_USER


To prove you are running the correct MySQL use this SQL
Code: Select all
SHOW VARIABLES WHERE Variable_Name = "basedir"


best wishes,
Altrea
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: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 115 guests