Liunx ubuntu Web apache2 + php + MySQL Installation

Ubuntu system under preparation phase update download source

apt-get update

Apache2 Installation

sudo apt-get install apache2

默认www目录在"var/www"下
安装目录/etc/apache2/

Launch Apache Service

/etc/init.d/apache2 start或sudo /etc/init.d/apache2 start

Restart Apache Service

/etc/init.d/apache2 restart或sudo /etc/init.d/apache2 restart

Stop Apache Service

/etc/init.d/apache2 stop或sudo /etc/init.d/apache2 stop

Port modification Apache

sudo vim /etc/apache2/ports.conf

Apache Configuration Modifications

sudo vim /etc/apache2/ports.conf

MySQL Installation

sudo apt-get install mysql-server

Apache2 and PHP configuration

sudo apt-get install libapache2-mod-php

PHP5.6 Installation

sudo apt-get install php5.6

PHP7.0 Installation

sudo apt-get install php7.0

php5.6 + MySQL Configuration

sudo apt-get install php5.6-mysql

See if MySQL starts the command

ps -aux | grep mysqld

See if MySQL is listening on the port command

netstat -tl | grep mysql

You will see something like the following to indicate the installation and startup success
TCP 0 0 : MySQL :* LISTEN

Extranet access MySQL

1. MySQL user has permission to access in the external network
   After MySQL is installed, the default root can only be accessed under 127.0.0.1, and the extranet is inaccessible.
   Here's how to fix it:

   1. Modify the table, log in to the MySQL database, switch to the MySQL database, and use the SQL statement to view the "select Host,user from User;"

      mysql -u root -pvmwaremysql>use mysql;mysql>update user set host = ‘%‘ where user =‘root‘;mysql>select host, user from user;mysql>flush privileges;

      Note: The last sentence is important in order for the changes to take effect. If you do not write, you still cannot connect remotely.

2, MySQL modify the configuration file, you can access the IP

修改bind-address  = 0.0.0.0

Reference Blog

3, Firewall restricted access to the port
4. Cloud Service Firewall restricted access

3. Debian/ubuntu Linux

1.启动：/etc/init.d/mysql start2.停止：/etc/init.d/mysql stop3.重启：/etc/init.d/mysql restart

About Bind-address

http://blog.csdn.net/chuck_perry/article/details/54907388

Linux has a lot of new versions of the software to split the configuration file, which is already a style, such as the environment variable configuration file/etc/profile has extended configuration folder/etc/ Profile.d,apache also, in addition to the main configuration file httpd.conf, http.conf also include CONF.D (do not know that there is no mistaken) directory under all the Conf end of the file, so you see the configuration file in the Include, You need to know what it means!
Finally, please feel that understanding also choose an answer, do not know the answer also hangs unanswered
1, use Find, locate and other commands to find all the my.cnf files. If there are multiple my.cnf, some are not loaded and only one is loaded.
2, if the real my.cnf file does not have the bind address, is your my.cnf did not write, the equivalent of comments out, you can write your own, and then restart MySQL.

(The following methods are not validated)Authorized user, you want root to connect to MySQL server from any host with password

GRANT all privileges on . To ' root ' @ '% ' identified by ' admin123 ' with GRANT OPTION;
Flush privileges;

If you want to allow user root to connect to a MySQL server from a host with IP 192.168.1.104

GRANT all privileges on . To ' myuser ' @ ' 192.168.1.104 ' identified by ' admin123 ' with GRANT OPTION;
Flush privileges;

Liunx ubuntu Web apache2 + php + MySQL Installation