no tables found in database
Posted by: tdelios (---.cpe.net.cable.rogers.com)
Date: November 19, 2013 02:55AM

Hello.. I am using WAMP Server for my PrestaShop installed on my windows xp (32bit) machine.

I want to backup my tables on my database, but when I click on my table within phpmyadmin, the screen on the right says 'no tables found in database'.

I know the tables are there and they are fully populated. But for some reason I cannot access them in phpmyadmin.

what do I need to configure in order to see these tables in phpmyadmin and utilize the 'Export' menu function to export out my information.

Your help is much needed and I would appreciate any help you can give.

thanks
tom

Options: ReplyQuote
Re: no tables found in database
Posted by: RiggsFolly (---.as13285.net)
Date: November 19, 2013 01:13PM

What version of WAMP are you using

What version of Apache , MySQL , PHP, phpMyAdmin

Are you using the 'root' userid on MySQL, if so have you set a password? Or are you using the default?

Options: ReplyQuote
Re: no tables found in database
Posted by: tdelios (---.cpe.net.cable.rogers.com)
Date: November 19, 2013 01:55PM

I'm using wampServe r2.4.

apache: 2.4.4

PHP: 5.4.16

phpmyadmin: 4.0.4


I've tried logging in a 'tdelios' and 'admin' both of which have no password. Either way, some message is displayed.

What is the default 'root' userid of mysql? What would be the default 'root' userid and default 'root' password?

thanks
tom

Options: ReplyQuote
Re: no tables found in database
Posted by: RiggsFolly (---.as13285.net)
Date: November 19, 2013 02:44PM

Its documented on the MySQL site.

MySQL ALWAYS COMES WITH THE 'root' SuperUser userid configured and the password in not set.

What makes you thnk you can just invent a userid????

So login using

Username = root
Password = blank, just leave it empty

Then set a password on all 3 root userid, best to make them all the same. Yes there are 3

root@localhost
root@127.0.0.1
root@::1

Options: ReplyQuote
Re: no tables found in database
Posted by: tdelios (---.corp.salesforce.com)
Date: November 19, 2013 04:47PM

Thanks! your previous post gave me the hint to use 'root' as the username and with no password, I was able to see it..

Thanks Again!

Tom

Options: ReplyQuote


Sorry, only registered users may post in this forum.