Connect Error (2003) Can't connect to MySQL Server on '' (111)

Question

Ubuntu 14.04 x32.

Installed php, phpmyadmin, apache, mysql.

Created database, upload my website files and I’m getting this error message:

Connect Error (2003) Can’t connect to MySQL server on ‘myipaddress’ (111)

I tried these solutions:

1) In etc>mysql>my.cnf change these line:
secure.bind-address=127.0.0.1
to
secure.bind-address=myipaddress
Didn’t work.

2) mysql> GRANT ALL ON mydbname.* TO root@'myipaddress’
-> IDENTIFIED BY 'mymysqlpassword’;

It did'nt work, too.

What can i do sometimes?

Answer 1

kamaln7 October 7, 2014

Is MySQL running?

sudo ps wwaux | grep -i sql

If that does not output anything, try starting the MySQL service:

sudo service mysql start

Also, what hostname/port is MySQL listening on?

sudo netstat -plutn | grep -i sql

Reply Report

seabey October 7, 2014

This is first query’s output:

sudo ps wwaux | grep -i sql

mysql 17375 0.1 7.3 327804 37084 ? Ssl 12:21 0:00 /usr/sbin/mysq d
root 17682 0.0 0.1 4680 836 pts/0 S+ 12:27 0:00 grep –color=auto -i sql

This is last query’s output:

sudo netstat -plutn | grep -i sql

tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 17375/mysqld
Reply Report
kamaln7 October 7, 2014

Ok, so MySQL is running but is listening on the loopback interface (127.0.0.1) and not eth0 (your droplet’s public IP address). Set secure.bind-address back to 127.0.0.1 so that MySQL doesn’t listen on the public IP address once it is restarted and use $host = '127.0.0.1';. Does that work?
Reply Report
seabey October 7, 2014

It’s probably working now. Thank you so much. I love Israel.
Reply Report

Answer 2

seabey October 7, 2014

This is first query’s output:

sudo ps wwaux | grep -i sql

mysql 17375 0.1 7.3 327804 37084 ? Ssl 12:21 0:00 /usr/sbin/mysq d
root 17682 0.0 0.1 4680 836 pts/0 S+ 12:27 0:00 grep –color=auto -i sql

This is last query’s output:

sudo netstat -plutn | grep -i sql

tcp 0 0 127.0.0.1:3306 0.0.0.0:* LISTEN 17375/mysqld
Reply Report
kamaln7 October 7, 2014

Ok, so MySQL is running but is listening on the loopback interface (127.0.0.1) and not eth0 (your droplet’s public IP address). Set secure.bind-address back to 127.0.0.1 so that MySQL doesn’t listen on the public IP address once it is restarted and use $host = '127.0.0.1';. Does that work?
Reply Report
seabey October 7, 2014

It’s probably working now. Thank you so much. I love Israel.
Reply Report

Answer 3

seabey October 7, 2014

Here my connection codes:

Reply Report

Answer 4

ashmi October 22, 2016

in my system second query is not running

Reply Report

Answer 5

andrewsainz November 6, 2017

I have the same error but i get this when i entered

sudo ps wwaux | grep -i sql
root 14874 0.0 0.0 12944 936 pts/0 S+ 21:42 0:00 grep –color=auto -i sql
what should i do?

Reply Report

Answer 6

shylozidon May 10, 2018

[deleted]

Reply Report

Answer 7

abhilashkulk June 26, 2018

after changing the bind address and granting permission, restart mysql

$sudo service mysql restart

Reply Report

sudo ps wwaux | grep -i sql