教你玩转linux下部署php项目-Apache、php、mysql关联（分享）

1.下载mysql-service文件

[root@tele-1 ~]# wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

2.安装mysql-service文件

[root@tele-1 ~]# rpm -ivh mysql-community-release-el7-5.noarch.rpm

[root@tele-1 ~]# yum install mysql-community-server

[root@tele-1 ~]# service mysqld restart

[root@tele-1 ~]# mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 474801
Server version: 5.6.36 MySQL Community Server (GPL)

Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

<strong>2.使用命令进行密码修改</strong><br/>

mysql> set password for 'root'@'localhost' = password('你要修改的密码');
Query OK, 0 rows affected (0.06 sec)

1.操作mysql数据库表

mysql> use mysql;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>

2.查看user表中的数据（在mysql命令行中可以直接进行sql语句编写）

mysql> select * from user;
mysql>

mysql> update user set Host = '%' where ???

mysql> \q
Bye

[root@tele-2 ~]# yum install httpd

[root@tele-2 ~]# service httpd start
Redirecting to /bin/systemctl start  httpd.service
[root@tele-2 ~]# service httpd status
Redirecting to /bin/systemctl status  httpd.service
● httpd.service - The Apache HTTP Server
   Loaded: loaded (/usr/lib/systemd/system/httpd.service; enabled; vendor preset: disabled)
   Active: active (running) since Mon 2017-06-05 15:57:34 CST; 5s ago
     Docs: man:httpd(8)
           man:apachectl(8)
  Process: 54532 ExecStop=/bin/kill -WINCH ${MAINPID} (code=exited, status=0/SUCCESS)
  Process: 39046 ExecReload=/usr/sbin/httpd $OPTIONS -k graceful (code=exited, status=0/SUCCESS)
 Main PID: 54573 (httpd)
   Status: "Processing requests..."
   Memory: 15.8M
   CGroup: /system.slice/httpd.service
           ├─54573 /usr/sbin/httpd -DFOREGROUND
           ├─54576 /usr/sbin/httpd -DFOREGROUND
           ├─54577 /usr/sbin/httpd -DFOREGROUND
           ├─54578 /usr/sbin/httpd -DFOREGROUND
           ├─54579 /usr/sbin/httpd -DFOREGROUND
           └─54580 /usr/sbin/httpd -DFOREGROUND

Jun 05 15:57:34 tele-2 systemd[1]: Starting The Apache HTTP Server...
Jun 05 15:57:34 tele-2 systemd[1]: Started The Apache HTTP Server.

[root@tele-2 ~]# yum install php

[root@tele-2 ~]# service httpd start
Redirecting to /bin/systemctl start  httpd.service

<?php
 phpinfo();
?>

[root@tele-2 ~]# yum search php

[root@tele-2 ~]# yum install php-mysql php-gd php-imap php-ldap php-odbc php-pear php-xml  php-xmlrpc

数据库目录：/var/lib/mysql/

配置文件：/usr/share/mysql（mysql.server命令及配置文件）

相关命令：/usr/bin（mysqladmin mysqldump等命令）

my.cnf: /etc/my.cnf

启动脚本：/etc/rc.d/init.d/（启动脚本文件mysql的目录）

启动命令：service mysql start

停止命令：service mysql stop

运行状态：service mysql status

配置文件路径：/etc/httpd/conf/httpd.conf

启动命令：service httpd start

停止命令：service httpd stop

运行状态：service httpd status

php默认页面路径：/var/www/html