Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0

Someone here suggests that it might be a firewall problem:

I have just had this problem and found it was my firewall. I use PCTools Firewall Plus and it wasn’t allowing full access to MySQL. Once I changed that it was fine. Hope that helps.

Could that be it?

Also, someone here suggests that it might be because the MySQL server is bound to the loop-back IP (127.0.0.1 / localhost) which effectively cuts you off from connecting from “outside”.

If this is the case, you need to upload the script to the webserver (which is probably also running the MySQL server) and keep your server host as ‘localhost’

Related Posts:

  1. How to log in to phpMyAdmin with WAMP, what is the username and password?
  2. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  3. Fatal error: Call to undefined function mysql_connect()
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  6. PDOException SQLSTATE[HY000] [2002] No such file or directory
  7. Mysql query- How to use contains?
  8. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  9. Invalid column count in CSV input on line 1 Error
  10. Invalid column count in CSV input on line 1 Error
  11. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  12. PDO with INSERT INTO through prepared statements
  13. phpMyAdmin: secret passphrase?
  14. PDO bindParam() with prepared statement isn’t working
  15. Forbidden :You don’t have permission to access /phpmyadmin on this server
  16. Creating a search form in PHP to search a database?
  17. How can I do ‘insert if not exists’ in MySQL?
  18. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  19. MySqli Commands out of sync; you can’t run this command now
  20. Trying to get property of non-object in
  21. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  22. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  23. Commands out of sync; you can’t run this command now
  24. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  25. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  26. How can I do ‘insert if not exists’ in MySQL?
  27. Object of class DateTime could not be converted to string
  28. What does it mean to escape a string?
  29. Convert from MySQL datetime to another format with PHP
  30. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  31. mysqli::query(): Couldn’t fetch mysqli
  32. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  33. Uncaught Error: Call to undefined function mysql_escape_string()
  34. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  35. Call to a member function on null?
  36. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  37. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  38. MySQL query to get column names?
  39. What does MYSQLI_NUM mean and do?
  40. Mysql where id is in array
  41. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  42. What is the advantage of using try {} catch {} versus if {} else {}
  43. select * from table where column = value ^ column2= value
  44. Deprecated: mysql_query() [duplicate]
  45. No query results for model [App\Products] Laravel
  46. Fatal error: Call to a member function query() on null
  47. mysqlworkbench giving version error on exporting database
  48. How to make DROP INDEX IF EXISTS for mysql?
  49. What is the meaning of sprintf(): Too few arguments
  50. Having a problem getting mysqli_query to execute
  51. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  52. Can I store images in MySQL 
  53. MySQL Daemon Failed to Start – centos 6
  54. How to insert TIMESTAMP into my MySQL table?
  55. How to remove index.php from WordPress site URL
  56. PHP Like thing similar to MySQL Like, for if statement?
  57. How get value from URL
  58. How to use Memcached with PHP7?
  59. select count(*) from table of mysql in php
  60. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  61. regex match any whitespace
  62. How do I resolve a HTTP 414 “Request URI too long” error?
  63. Fatal error: Call to undefined function mysqli_connect()
  64. How do I run a file on localhost?
  65. Unable to locate package libapache2-mod-php7
  66. Returning JSON from PHP to JavaScript?
  67. How to create cron job using PHP?
  68. Fatal error: Call to undefined function sqlsrv_connect()
  69. NotFoundHttpException in RouteCollection.php line 161: in laravel 5
  70. Easy way to password-protect php page
  71. How to output JavaScript with PHP
  72. WRONGTYPE Operation against a key holding the wrong kind of value php
  73. Check if URL has certain string with PHP
  74. If variable equals value php [duplicate]
  75. PHP array delete by value (not key)
  76. PHP mail: Multiple recipients?
  77. How can you use php in a javascript function
  78. How to bypass (deprecated) reCAPTCHA V1?
  79. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  80. cannot change admin password, wordpress on godaddy
  81. How to properly insert data into custom table via plugin
  82. Searching users with WP_List_Table plugin
  83. Jquery ajax to custom php file: returning blank data
  84. Add value to usermeta without removing previous values?
  85. How can I call a row of user specific data from a custom table added to the WP Database
  86. Performance issues with large website [closed]
  87. Create a quick start wordpress installation [closed]
  88. 306 MB of wp_options occupied by WordPress SEO Plugin, is that normal? [closed]
  89. Ordering users by custom user meta
  90. Notice: Uninitialized string offset: 0 in social sharing mu-plugin
  91. Multiple meta_key in one global $wpdb;
  92. Most commented posts by time period (last 12h, last 24h and etc)
  93. Known Issues in WordPress When Upgrading PHP to ver 7
  94. Modify WooCommerce used to get all orders in dashboard
  95. How to get database connection details without longing to cpanel in WordPress?
  96. Weird fonts showing which are coming from database
  97. cant insert data in a custom table in phpmyadmin
  98. Foreach only outputs if id is 0
  99. How to pass username into form that sends data to database
  100. Your PHP installation appears to be missing the MySQL … After deleting and restarting from cpanel

Leave a Comment

error code: 523