Question

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

  • Posted October 7, 2014

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?

Subscribe
Share

Post a pastebin link to the connection string in your code.


Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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

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

after changing the bind address and granting permission, restart mysql

$sudo service mysql restart

This comment has been deleted

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?

in my system second query is not running

Here my connection codes:

Here