Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

phpMyAdmin only showing first table in database

Posted on 2009-04-10
4
Medium Priority
?
391 Views
Last Modified: 2013-12-12
This one has me scratching my head.  I am creating a database with several tables.  All of the tables are there (I can see them using the GUI of MySQL) but phpMyAdmin only shows the first table (listed alphabetically).  Any idea what has caused this?  I've read as much of the phpMyAdmin documentation as I can understand, and have searched the web for this phenomenon, but so far, I'm not finding anything on this.  Any help would be greatly appreciated!  I've included a screen capture showing a database called SECURE, with two tables, but only showing one below the Database name in the left frame.

Thanks,
Picture-3.png
0
Comment
Question by:sully1958
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 9

Accepted Solution

by:
LinuxNubb earned 1000 total points
ID: 24120204
Very odd.  Have you tried the latest version of phpmyadmin?  What are the other database and table names?
0
 

Author Comment

by:sully1958
ID: 24120390
The other table name in "SECURE" is "Member."  The other databases are NCR, CSR, information_schema and mysql.  I created Member, NCR and CSR.  information_schema and mysql already existed.  I can see all the tables in the information_schema and mysql tables, but only one in the databases I created.  My phpMyAdmin version is 2.11.9.5.
0
 
LVL 9

Expert Comment

by:LinuxNubb
ID: 24123187
Are you creating the tables/databases inside phpmyadmin? If not, what happens if you do?
0
 

Author Closing Comment

by:sully1958
ID: 31569100
Updating to the latest version solved my problem.  Thanks!
0

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
There are times when I have encountered the need to decompress a response from a PHP request. This is how it's done, but you must have control of the request and you can set the Accept-Encoding header.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

715 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question