+ 1

Not able to find customers table under mysql. I've logged on to localhost/phpmyadmin server. How to proceed?

9th Nov 2016, 3:00 PM
Vidish Bhat
Vidish Bhat - avatar
3 ответов
+ 2
SELECT * FROM customers;
9th Nov 2016, 3:01 PM
Ruslan Madatov
Ruslan Madatov - avatar
+ 2
Use the following query to troubleshoot the issue, list databases by using the sql syntax: SHOW DATABASES; if mysql exists on the list, the check for its tables. first select the database you want to use: USE mysql; then list the tables of mysql database: SHOW TABLES; Check if customers table is present, if so query the table: SELECT * FROM customers; if you don't see the mysql database at all but you're sure it exists, check the user you used to login in phpmyadmin and make sure it has enough privileges to view the database. if none of the above applies, the customer's table isn't inside mysql database. check the other databases.
9th Nov 2016, 3:24 PM
Attila Antal
Attila Antal - avatar
0
show costumers;
11th Nov 2016, 12:04 PM
Arun Bhandari
Arun Bhandari - avatar