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

If You Appreciate What We Do Here On TecMint, You Should Consider:

  1. Stay Connected to: Twitter | Facebook | Google Plus
  2. Subscribe to our email updates: Sign Up Now
  3. Get your own self-hosted blog with a Free Domain at ($3.45/month).
  4. Become a Supporter - Make a contribution via PayPal
  5. Support us by purchasing our premium books in PDF format.
  6. Support us by taking our online Linux courses

We are thankful for your never ending support.

Aaron Kili

Aaron Kili is a Linux and F.O.S.S enthusiast, an upcoming Linux SysAdmin, web developer, and currently a content creator for TecMint who loves working with computers and strongly believes in sharing knowledge.

Your name can also be listed here. Got a tip? Submit it here to become an TecMint author.

RedHat RHCE and RHCSA Certification Book
Linux Foundation LFCS and LFCE Certification Preparation Guide

6 Responses

  1. Harikrishna Guggilla says:

    I am trying to connect to my master server database, but getting the below error.

    [[email protected] log]# mysql -u slave_user -p -h 192.168.177.52 -P 3306
    Enter password:
    ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.177.52' (113)
    

    but I can able to access my master database with same credentials from the same server, When am trying from slave server getting that error.

    Please do help on this.

    Regards,
    Harikrishna Guggilla
    +917347060544

    • Aaron Kili says:

      @ Harikrishna

      Have you enabled remote root access on the master server. This could be the issue; try to run the mysql_secure_installation script and allow remote root access.

  2. Dhwani says:

    Excellent page!! You solved my problem!

  3. ganesh says:

    you solved a great problem of mine
    Thanks buddy…!

Got something to say? Join the discussion.

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.