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: In etc>mysql>my.cnf change these line:secure.bind-address=127.0.0.1tosecure.bind-address=myipaddressDidn’t work. mysql> GRANT ALL ON mydbname.* TO root@‘myipaddress’-> IDENTIFIED BY ‘mymysqlpassword’; It did’nt work, too. What can i do sometimes?

DigitalOcean

- Community
- DigitalOcean
- Community
- DigitalOcean

Question

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

Posted on October 7, 2014

By seabey

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:

In etc>mysql>my.cnf change these line: secure.bind-address=127.0.0.1 to secure.bind-address=myipaddress Didn’t work.
mysql> GRANT ALL ON mydbname.* TO root@‘myipaddress’ -> IDENTIFIED BY ‘mymysqlpassword’;

It did’nt work, too.

What can i do sometimes?

This textbox defaults to using Markdown to format your 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.