Solved

Can't view any table in phpMyAdmin, MySQL shows an error of 'Got an error reading communication packets' HELP!!! :-)

Posted on 2004-08-11
9
486 Views
Last Modified: 2006-11-17
Hi,

I'm running MySQL 4.0.20-log and PHP Version 5.0.0-dotdeb on Debian 3.0R2. Everything works fine untill i try and browse any table in phpMyAdmin. All i get is a blank page saying "The page cannot be displayed". When i check the MySQL logs i'm getting the following errors :

040811 10:54:19 Aborted connection 9 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)
040811 10:54:19 Aborted connection 10 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)
040811 10:54:19 Aborted connection 11 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)
040811 10:54:19 Aborted connection 12 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)
040811 10:54:26 Aborted connection 14 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)
040811 10:54:26 Aborted connection 15 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)
040811 10:54:27 Aborted connection 16 to db: 'dads' user: 'root' host: `localhost' (Got an error reading communication packets)

This means absolutely nothing to me, so why should there be errors on a new installation like this? does anyone know how to fix it, its driving me mad! ;-)
0
Comment
Question by:matd_
[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
9 Comments
 
LVL 5

Expert Comment

by:winglis4
ID: 11772130
Have you properly setup the path to the phpMyAdmin root directory in /phpMyAdmin/config.inc.php? I have not seen the errors you list from your log, though....

Look for this section - it is right near the top of the file
/**
 * Your phpMyAdmin url
 *
 * Complete the variable below with the full url ie
 *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
 *
 * It must contain characters that are valid for a URL, and the path is
 * case sensitive on some Web servers, for example Unix-based servers.
 *
 * In most cases you can leave this variable empty, as the correct value
 * will be detected automatically. However, we recommend that you do
 * test to see that the auto-detection code works in your system. A good
 * test is to browse a table, then edit a row and save it.  There will be
 * an error message if phpMyAdmin cannot auto-detect the correct value.
 *
 * If the auto-detection code does work properly, you can set to TRUE the
 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
 */
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpMyAdmin/';
0
 

Author Comment

by:matd_
ID: 11772491
No, that has been set corectly. My guess this is some MySQL ro php > MySQL issue as even though it won't let me browse any tables i can still view and set privelages in the phpMyAdmin 'privelages' section.

Somthing else i noticed which i think is very odd, is that i can't type any new value in when i go to insert a record.
0
 
LVL 14

Expert Comment

by:psadac
ID: 11778562
i'm not sure it comes from mysql, but take a look at this  :

http://dev.mysql.com/doc/mysql/en/Communication_errors.html

with php 5 mysql extension is not enabled by default, and there's a new mysql extension called mysqli which does not work with phpmyadmin.  so you should check if the mysql extension is enabled in your phpinfo()
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Expert Comment

by:draconius22
ID: 11988325
Are you shure your firewall accepts connections through the 3306 port at least for your other servers which will access it?
0
 

Author Comment

by:matd_
ID: 13645257
Hi periwinkle,

Please close this question and refund my points. I have solved this problem myself by updating my php and mysql to the latest versions.

Thank you.
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 13692240
PAQed, with points refunded (170)

ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Get Database Help Now w/ Support & Database Audit

Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

734 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