Troubleshooting remote connections to MySQL on Linux

If you encounter a problem when trying to remotely connect to MySQL on Linux, make sure that the bind-address property in the configuration file (/etc/mysql/my.cnf) is set to the machine’s host name. I wasted a considerable amount of time before resolving this issue.

“If the server was started with –bind-address=127.0.0.1, it will listen for TCP/IP connections only locally on the loopback interface and will not accept remote connections.”

source: MySQL documentation

I hope this saves somebody some time.

Advertisements
Troubleshooting remote connections to MySQL on Linux

2 commands to install LAMP and phpMyAdmin on Ubuntu 9.10

I only takes two command lines to install LAMP and phpMyAdmin on Ubuntu 9.10.

sudo tasksel install lamp-server
sudo apt-get install phpmyadmin

What a beautiful thing. Details on installing LAMP on Ubuntu 7.x and greater can be found here and phpMyAdmin here.

2 commands to install LAMP and phpMyAdmin on Ubuntu 9.10