If your MySQL development and production environments are Mac OS X or Windows, queries containing all lowercase or uppercase table names will work fine. This is because these platforms are case-insensitive. However, if you deploy to a Unix system, queries referencing table names in the incorrect case will not work. Consequently, adopting a standard naming convention across platforms is the best policy. I decided to go with all lowercase with underscores between words (my_table_name).
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.
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