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

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.

Update

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 IP for which MySQL server is bind in ‘my.cnfinstead oflocalhost or 127.0.0.1`.

Related Posts:

  1. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  2. Cannot add or update a child row: a foreign key constraint fails
  3. How to make MySQL table primary key auto increment with some prefix
  4. MySQL error 2006: mysql server has gone away
  5. sql query with multiple where statements
  6. Cannot delete or update a parent row: a foreign key constraint fails
  7. Syntax error due to using a reserved word as a table or column name in MySQL
  8. MySQL root password change
  9. Installation of MySQL for Visual Studio 1.2.8 failed
  10. How do I import an SQL file using the command line in MySQL?
  11. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  12. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  13. Select from multiple tables without a join?
  14. SQL Query Where Field DOES NOT Contain $x
  15. How to join two tables by multiple columns in SQL?
  16. How to get size of mysql database?
  17. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  18. SQL – Update multiple records in one query
  19. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  20. mysqladmin: connect to server at ‘localhost’ failed
  21. mysql update multiple columns with same now()
  22. Usage of MySQL’s “IF EXISTS”
  23. Simple Random Samples from a Sql database
  24. Generating a random & unique 8 character string using MySQL
  25. MySQL > Table doesn’t exist. But it does (or it should)
  26. SQL select only rows with max value on a column
  27. Trying to perform MINUS operation in MySQL
  28. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  29. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  30. MySQL config file location – redhat linux server
  31. How to create a foreign key in phpmyadmin
  32. Can’t create test file lower test start server mysql
  33. MySQL delete multiple rows in one query conditions unique to each row
  34. Create boolean column in MySQL with false as default value?
  35. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  36. Is there a naming convention for MySQL?
  37. CAST to DECIMAL in MySQL
  38. Is merge statement available in MySQL
  39. GROUP_CONCAT comma separator – MySQL
  40. Failed to Connect to MySQL at localhost:3306 with user root
  41. How do you properly prepare a %LIKE% SQL statement?
  42. Set page template for all pages?
  43. SQL query to update post_date (one post = one single date & time)
  44. My WordPress site always displays a cached version of its homepage
  45. How to copy post titles to post slug in phpmyadmin
  46. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  47. Proper way to work with wpdb to get user’s firstname
  48. Inserting Hundreds of Thousands of Posts at Once
  49. wp_admin edit.php slow with lots of queries
  50. Database: Custom table: sprintf value for DateTime column
  51. can database and media folder be moved to a different drive?
  52. What is the most secure way to set up the MySQL user in WPMU?
  53. WP_USE_EXT_MYSQL
  54. Distinction on meta value on pre_get_posts
  55. How to get data from WordPress site sql file
  56. WordPress with php5-fpm and nginx
  57. MySQL Rank & $wpdb
  58. WordPress post_status is future, manually added
  59. How are multiple WordPress WPDB queries handled?
  60. $wpdb to insert html form information
  61. Proper usage of $wpdb->update()?
  62. Regarding “Insert query error” in wordpress
  63. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  64. WordPress plugin overloading with tmp tables
  65. Site not responding error – taking long to load [closed]
  66. What should a WordPress developer know about MySQL? [closed]
  67. Copyright: Get first and last date of post type
  68. WordPress(wpdb class) and mysql stored procedures
  69. WordPress plugins for database queries
  70. WordPress doesn’t display accents after migration
  71. WordPress $wpdb get posts from category and sort by custom meta
  72. Replace a character in all post titles and slugs
  73. Understanding custom php that reads from WP MYSQL
  74. $wpdb->get_var multiple queries in one database check
  75. List users with the most posts in the last 30 days
  76. Way to extract wordpress data from folder backup
  77. Data is not constatntly loading from custom wordpress table
  78. Mysql Server keeps crashing
  79. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  80. How to search usermeta table
  81. How to add virtual column in wpdb get_result statement
  82. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  83. I want to share local developement and staging DB — Is this very smart or very stupid?
  84. Extract all users along with yoast metadata description
  85. WordPress asks to install, but is already installed?
  86. Mysql Error in querying form entries in Gravity Form plugin
  87. Deleting a table row through query
  88. An SQL query to find orphaned image attachments and their meta
  89. Weird characters displayed when importing WordPress MySQL db
  90. Simple SQL Query in wordpress
  91. MySQL errors after a WordPress clone
  92. optimise SQL wordpress call
  93. problem with quotes on new post
  94. WP_Query with LIKE returns strange query
  95. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  96. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  97. How do I load a sql.gz file to my database? (importing)
  98. How to find source of these strange SQL queries?
  99. Batch Replace URLs in WordPress Database
  100. How to reduce uncached page generation time?

Leave a Comment

tech