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:
-
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?
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:
Post a pastebin link to the connection string in your code.