Can’t connect to MySQL server error 111 [closed]

by

It probably means that your MySQL server is only listening the localhost interface.

If you have lines like this :

bind-address = 127.0.0.1

In your my.cnf configuration file, you should comment them (add a # at the beginning of the lines), and restart MySQL.

sudo service mysql restart

Of course, to do this, you must be the administrator of the server.

More Related Contents:

  1. error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’ — Missing /var/run/mysqld/mysqld.sock
  2. How do I find the MySQL my.cnf location
  3. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  4. Stored procedure that Automatically delete rows older than 7 days in MYSQL
  5. MySQL – ERROR 1045 – Access denied
  6. ERROR 2003 (HY000): Can’t connect to MySQL server on ‘127.0.0.1’ (111)
  7. Bash script to insert values in MySQL
  8. How to change MySQL table names in Linux server to be case insensitive?
  9. Commit data in a mysql container
  10. libmysqlclient15-dev on macs?
  11. MySQL fails on: mysql “ERROR 1524 (HY000): Plugin ‘auth_socket’ is not loaded”
  12. Access mysql remote database from command line
  13. How to change the mysql root password
  14. Accessing a mysql database from external host/ip? (ie: mysql workbench)
  15. Linux shell script for database backup
  16. UTF-8: General? Bin? Unicode?
  17. Transposing Dynamic Columns to Rows
  18. LOAD DATA INFILE easily convert YYYYMMDD to YYYY-MM-DD?
  19. MyIsam engine transaction support
  20. When to use SELECT … FOR UPDATE?
  21. Setting column values as column names in the SQL query result
  22. MYSQL sum() for distinct rows
  23. Laravel join with 3 Tables
  24. phpMyAdmin – can’t connect – invalid setings – ever since I added a root password – locked out
  25. How to regex in a MySQL query
  26. How to remove duplicate entries from a mysql db?
  27. Syntax error on MERGE statement
  28. Update multiple rows with multiple ‘where’ clauses for each individual row
  29. WHERE datetime older than some time (eg. 15 minutes)
  30. Is there a way to use ON DUPLICATE KEY to Update all that I wanted to insert?

Leave a Comment