ubuntu 安裝 Apache2 + PHP5 + MySQL + phpMyAdmin

參考： http://eeepage.info/ubuntu-apache2-php5-mysql-phpmyadmin/

一步一步安裝完後 …可能會遇到

Lost connection to MySQL server at 'reading initial communication packet', system error: 111

修改  /etc/mysql/my.cnf 裡的 bind-address 改成對外 IP


然後 chmod 644 /etc/mysql/my.cnf  並重開 mysql

接著又有可能遇到

ERROR 1130: Host 'xxxx' is not allowed to connect to this MySQL server

解決方法


# mysql -u root -p
<輸入密碼>

mysql > GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '密碼' WITH GRANT OPTION;

參考：http://blog.yam.com/carl44/article/20131178