Question
Connect Error (2003) Can't connect to MySQL Server on '' (111)
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?
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.
×
Post a pastebin link to the connection string in your code.