LAMP(Linux+Apache+Mysql+PHP) 一组常用来搭建动态网站或者服务器的开源软件,本身都是各自独立的程序,但是因为常被放在一起使用,拥有了越来越高的兼容度,共同组成了一个强大的Web应用程序平台。
本文介绍一下在CentOS环境下LAMP开发环境的搭建和配置。采用yum形式,简单易操作,10分钟搞定!!!
以root用户登录Linux,进入终端模式,然后键入命令如下:
[root@lvshubao ~]# yum -y install httpd mysql mysql-server php php-mysql
等待1~2分钟就可以安装完毕,接下来进入配置阶段
首先,启动Apache服务:
[root@lvshubao ~]# /etc/rc.d/init.d/httpd start
出现:
正在启动 httpd:httpd: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
[确定]
[root@lvshubao ~]# ps aux | grep httpd
出现:
root 6492 0.2 0.3 27516 7556 ? Ss 15:47 0:00 /usr/sbin/httpd
apache 6495 0.0 0.2 27516 3920 ? S 15:47 0:00 /usr/sbin/httpd
apache 6496 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
apache 6497 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
apache 6498 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
apache 6499 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
apache 6500 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
apache 6501 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
apache 6502 0.0 0.2 27516 3904 ? S 15:47 0:00 /usr/sbin/httpd
root 6505 0.0 0.0 5980 736 pts/0 S+ 15:48 0:00 grep httpd
然后,进入/var/www/html目录下,编写一个php文件show.php如下,打开浏览器输入:localhost/show.php如果出现了php的主页就说明成功了!
<?php
echo phpinfo();
如果前面进展顺利的话,下一步就要配置mysql数据库了
[root@lvshubao html]# /etc/rc.d/init.d/mysqld start
[root@lvshubao html]# netstat -tulnp | grep :3306
如果出现以下的返回则表示开启成功了!
tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 6934/mysqld
配置mysql:
1.设置root密码
[root@lvshubao html]# mysqladmin -u root password '123456'
2.登录mysql服务器
[root@lvshubao html]# mysql -u root -p
3.下面是一些建表的语句和返回情况,我直接粘的我自己搭建时的东西!
mysql> create database demo;
Query OK, 1 row affected (0.00 sec)
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| demo |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)
mysql> use demo
Database changed
mysql> create table preson( id int auto_increment primary key, name varchar(255),de_flg int(2) default 0);
Query OK, 0 rows affected (0.08 sec)
mysql> show tables;
+----------------+
| Tables_in_demo |
+----------------+
| preson |
+----------------+
1 row in set (0.00 sec)
mysql> desc preson;
+--------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+--------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(255) | YES | | NULL | |
| de_flg | int(2) | YES | | 0 | |
+--------+--------------+------+-----+---------+----------------+
3 rows in set (0.00 sec)
mysql> insert into preson (id,name,de_flg) values (null,'lvshubao',1);
Query OK, 1 row affected (0.00 sec)
mysql> insert into preson (id,name,de_flg) values (null,'guoran',2);
Query OK, 1 row affected (0.00 sec)
mysql> insert into preson (id,name,de_flg) values (null,'lijiao',3);
Query OK, 1 row affected (0.00 sec)
mysql> insert into preson (id,name,de_flg) values (null,'zhuchenyu',4);
Query OK, 1 row affected (0.00 sec)
mysql> select * from preson;
+----+-----------+--------+
| id | name | de_flg |
+----+-----------+--------+
| 1 | lvshubao | 1 |
| 2 | guoran | 2 |
| 3 | lijiao | 3 |
| 4 | zhuchenyu | 4 |
+----+-----------+--------+
4 rows in set (0.00 sec)
最后,进入/var/www/html目录下,编写一个php文件test.php如下,打开浏览器输入:localhost/test.php如果成功调用数据库里面的数据就说明成功了!
<?php
header("Content-type:text/html;charest=utf-8");
$link = mysql_connect('localhost','root','123456');
mysql_select_db('demo',$link);
mysql_query('set names utf-8');
$query_sql = "select * from preson";
$result = mysql_query($query_sql);
$data = array();
while($row = mysql_fetch_assoc($result)){
$data[]=$row;
}
echo "<pre>";
print_r($data);