ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)

by

If you are using Ubuntu, you have to use the following steps to avoid this error (if there is no replication enabled):

  1. run the command vim /etc/mysql/my.cnf
  2. comment bind-address = 127.0.0.1 using the # symbol
  3. restart your MySQL server once.

In Step 1, if you cannot find bind-address in the my.cnf file, look for it in /etc/mysql/mysql.conf.d/mysqld.cnf file.

Update in case of MySQL replication enabled

Try to connect MySQL server on the IP address for which MySQL server is bound in file my.cnf instead of localhost or 127.0.0.1.

More Related Contents:

  1. Can’t connect to MySQL server error 111 [closed]
  2. Access mysql remote database from command line
  3. In SQL Server how to get the count of child if both parent and child are available [closed]
  4. MySQL select 10 random rows from 600K rows fast
  5. Get a list of dates between two dates
  6. How to change max_allowed_packet size
  7. Simulate lag function in MySQL
  8. What does character set and collation mean exactly?
  9. How do MySQL indexes work?
  10. Get record counts for all tables in MySQL database
  11. Query to get all rows from previous month
  12. MySQL LIMIT clause equivalent for SQL SERVER
  13. How to get the next auto-increment id in mysql
  14. Importing a csv into mysql via command line
  15. MySQL dynamic-pivot
  16. Hyphens in column names in MySQL DB
  17. Deleting duplicate rows from a table
  18. Modeling Product Variants
  19. How do I find which transaction is causing a “Waiting for table metadata lock” state?
  20. MySQL LIKE query with underscore
  21. ERROR 2013 (HY000): Lost connection to MySQL server at ‘reading authorization packet’, system error: 0
  22. Compare only day and month with date field in mysql
  23. mysql, ifnull vs coalesce, which is faster?
  24. Pass parameter to MySQL script command line
  25. MySQL delimiter syntax error
  26. Can a MySQL query turn rows into columns?
  27. Should I always prefer MySQL InnoDB over MyISAM?
  28. MySQL add 12 hours to a time field
  29. OSX ld: library not found for -lssl
  30. MySQL: Find Missing Dates Between a Date Range

Leave a Comment