ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
MysqlMysql Error-2003Mysql Problem Overview
I use the following command:
mysql -u root -h 127.0.0.1 -p
And the error message is:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111)
How can I fix it?
Mysql Solutions
Solution 1 - Mysql
If you are using Ubuntu, you have to use the following steps to avoid this error (if there is no replication enabled):
- run the command
vim /etc/mysql/my.cnf
- comment
bind-address = 127.0.0.1
using the # symbol - 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.
Solution 2 - Mysql
Try localhost instead of 127.0.0.1 to connect or in your connection-config
. It worked for me on a Debian 6.0 (Squeeze) Server.
Solution 3 - Mysql
This happens when you forget to start the database before connecting to it:
mysql.server start
Then
mysql -u root -p -h 127.0.0.1
Solution 4 - Mysql
In my case (remote connection), it helped turning off the firewall on the server:
service iptables stop
Solution 5 - Mysql
On Windows, this problem may occur because your MySQL server is not installed and running.
To do that, start a command prompt as administrator and enter the command:
"C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld" --install
If you get "service successfully installed" message then you need to start the MySQL service. To do that: go to Services window (Task Manager → Services → Open Services). Search for MySQL and start it from the top navigation bar. Then if trying to open mysql.exe, it will work.
Solution 6 - Mysql
Look at the my.cnf
file. If it contains a [client]
section, and the port
is other than the real listen port (default 3306), you must connect the server with an explicit parameter, -P 3306
, e.g.
mysql -u root -h 127.0.0.1 -p -P 3306
Solution 7 - Mysql
If you are here with the same error message and you use Docker - try to use the name of the database service as a host.
services:
app:
blablabla
db:
blablabla
I mean, instead of:
127.0.0.1 or localhost
use:
db
Solution 8 - Mysql
You need to change the bind-address parameter to 127.0.0.1 in the MySQL configuration file (my.ini or my.cnf) or use the one that is defined there.
If that doesn't work you should check that the MySQL service is actually running.
Solution 9 - Mysql
In case you are running on a non-default port, you may try using --port=<port num>
provided --skip-networking
is not enabled.
Solution 10 - Mysql
I was also facing the same issue.
The following helped me fix the problem
Go to Control Panel → Administrative Tools → Services. Inside this you will most certainly see the MySQL service: right click and say start (force start).
Solution 11 - Mysql
I just have this problem... running in Windows 7 and WAMP server ... after reading this.
I found that Antivirus Firewall had caused the problem.
Solution 12 - Mysql
For Docker users - When trying to connect to the local SQL database server using mysql -u root -h 127.0.0.1 -p
and your database is running in a Docker container, make sure the MySQL service is up and running (verify using docker ps
and also check that you are in the right port as well). If the container is down you'll get connection error.
The best practice is to set the IP addresses in /etc/hosts
on your machine:
127.0.0.1 db.local
And running it by mysql -u root -h db.local -p
.
Solution 13 - Mysql
Check if it is open port 3306 (more here):
nmap -p3306 127.0.0.1
If you receive something like:
Starting Nmap 7.92 ( https://nmap.org ) at 2022-01-07 11:55 CET
Nmap scan report for localhost (127.0.0.1)
Host is up (0.000082s latency).
PORT STATE SERVICE
3306/tcp closed mysql
Nmap done: 1 IP address (1 host up) scanned in 0.08 seconds
then open port 3306:
sudo iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
Or sudo ufw allow 3306
if you use UFW.
Check: netstat -lnp | grep mysql
you should get something like this:
cp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 2048/mysqld
tcp6 0 0 :::33060 :::* LISTEN 2048/mysqld
unix 2 [ ACC ] STREAM LISTENING 514961 2048/mysqld /var/run/mysqld/mysqld.sock
unix 2 [ ACC ] STREAM LISTENING 514987 2048/mysqld /var/run/mysqld/mysqlx.sock
Solution 14 - Mysql
If you have tried all of the above and it still did not work. Check firewall.
I was trying to connect from a windows machine to a MySql Server 5.7.32 installed on a VirtualBox machine with CentOs7. I have tried everything and it was not working, even though i could ping the machine i couldn't connect to the MySql Server.
On CentOs7 the commands to check the firewall are:
Step 1: Check the status of your firewall service:
systemctl status firewallid.service
Step 2: Disable the firewall service
systemctl stop firewallid.service
Solution 15 - Mysql
I had this problem when I tried to connect to the MySQL server in the Docker container
I fixed by following the steps below.
- Go inside the container:
docker exec -it mysql bash
- Run this command:
echo "bind-address = 0.0.0.0" >> /etc/mysql/conf.d/mysql.cnf
- Exit from the container
exit
- Restart the container
docker restart mysql
- Go inside the container
docker exec -it mysql bash
- Connect to the MySQL server, and enter your password
mysql -u root -p
Solution 16 - Mysql
I just restarted my MySQL server and the problem was solved.
On Windows, net stop MySQL
, and then net start MySQl
.
On Ubuntu (Linux): sudo service start mysql
Solution 17 - Mysql
I changed the installation directory on re-install, and it worked.
Solution 18 - Mysql
Please make sure your MySQL server is running on localhost.
On Linux
To check if MySQL server is running:
sudo service mysql status
To run MySQL server:
sudo service mysql start
On Windows
To check if MySQL server is running:
net start
If MySQL is not in list, you have to start/run MySQL.
To run MySQL server:
net start mysql