ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0

by

From documentation:

More rarely, it can happen when the client is attempting the initial
connection to the server. In this case, if your connect_timeout value
is set to only a few seconds, you may be able to resolve the problem
by increasing it to ten seconds, perhaps more if you have a very long
distance or slow connection. You can determine whether you are
experiencing this more uncommon cause by using SHOW STATUS LIKE
‘aborted_connections’. It will increase by one for each initial
connection attempt that the server aborts. You may see “reading
authorization packet” as part of the error message; if so, that also
suggests that this is the solution that you need.

Try increasing connect_timeout in your my.cnf file

Another style:

MySQL: Lost connection to MySQL server at ‘reading initial communication packet’

  1. At some point, it was impossible for remote clients to connect to
    the MySQL server.

  2. The client (some application on a Windows platform) gave a vague
    description like Connection unexpectedly terminated.

  3. When remotely logging in with the MySQL client the following error
    appeared:

    ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 0

On FreeBSD this happens because there was no match found in /etc/hosts.allow. Adding the following line before the line saying ALL:ALL fixes this:

mysqld: ALL: allow

On non-FreeBSD Unix systems, it is worth to check the files /etc/hosts.allow and /etc/hosts.deny. If you are restricting connections, make sure this line is in /etc/hosts.allow:

mysqld: ALL

or check if the host is listed in /etc/hosts.deny.

In Arch Linux, a similar line can be added to /etc/hosts.allow:

mysqld: ALL

More Related Contents:

  1. MySQL – Get row number on select
  2. Delimiters in MySQL
  3. How to use GROUP_CONCAT in a CONCAT in MySQL
  4. MySQL query / clause execution order
  5. Group by clause in mySQL and postgreSQL, why the error in postgreSQL?
  6. How can I tell when a MySQL table was last updated?
  7. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  8. Operand Should Contain 1 Column – MySQL NOT IN
  9. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  10. Does adding ‘LIMIT 1’ to MySQL queries make them faster when you know there will only be 1 result?
  11. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  12. On duplicate key ignore? [duplicate]
  13. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  14. How to convert timestamp to datetime in MySQL?
  15. List of Stored Procedures/Functions Mysql Command Line
  16. Best practices for SQL varchar column length [closed]
  17. mySQL longitude and latitude query for other rows within x mile radius
  18. How to design a multi tenant mysql database
  19. How to get the count of each distinct value in a column? [duplicate]
  20. Get results that fall within marker radiuses from database
  21. Bash script to insert values in MySQL
  22. MySQL dynamic cross tab
  23. How to produce “phantom read” in REPEATABLE READ? (MySQL)
  24. Laravel join with 3 Tables
  25. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  26. ERROR: Loading local data is disabled – this must be enabled on both the client and server sides
  27. How do I split the output from mysqldump into smaller files?
  28. How to remove duplicate entries from a mysql db?
  29. MySQL Group By Hours
  30. RMySQL dbWriteTable with field.types

Leave a Comment