3

Today I changed my username and password in MySQL and I logged into phpmyadmin to see that all my databases were gone.

I've tried changing the datapath but then I realized I didn't see any of my databases in the data folder either!

Can I get back my databases? Are they stored somewhere else?

My Data Folder

All My databases gone...

  • 4
    look into "C:\ProgramData\MySQL\MySQL Server 5.6"..as programdata usually have the files on by default...what was the old path...can u share variable value in my.ini – Nawaz Sohail Jun 11 '15 at 21:40
  • You saved my a** on this one, Thank you so much. – AutoJukebox Jun 11 '15 at 22:06
  • Hey @NawazSohail you should post your comment as an answer. I'd like to upvote it. – RolandoMySQLDBA Jun 11 '15 at 23:55
  • For backing up, you really should be exporting an SQL file rather than relying on backing up the files. – ibennetch Jun 13 '15 at 14:01
4

Data is present in data folder of MySQL which is usually in ProgramData for windows installations. look into "C:\ProgramData\MySQL\MySQL Server 5.6"..as programdata usually have the files on by default

  • As promised, +1 for making your comment an answer !!! – RolandoMySQLDBA Jun 16 '15 at 16:03
2

You're not seeing your databases in phpMyAdmin because you are logged in as the anonymous user. Log in using the new username and password you've created/changed to and you should see your old databases.

By default, phpMyAdmin uses the "cookie" authentication mode, which means you're prompted when logging in. If you've changed that to be "config" you'll have to edit the corresponding user and password fields of config.inc.php to match the new information.

-3

All the data used to be in default location of pc in fact wherever we are located doesn't matter so the default location is Ubuntu 9.10

Moving the database from /var/lib/mysql to /data/databases/mysql you can go and check your data there. It will be stored there and sometimes data may be hidden we can unlock it for seeing as a guest. If we are admin then we can see easily and if we are some unknown user for the system then we have to get some privileges for seeing the data.

  • 1
    Have you seen that the question is about a Windows installation? – ypercubeᵀᴹ Jun 15 '15 at 12:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.