论坛交流
首页办公自动化| 网页制作| 平面设计| 动画制作| 数据库开发| 程序设计| 全部视频教程
应用视频: Windows | Word2007 | Excel2007 | PowerPoint2007 | Dreamweaver 8 | Fireworks 8 | Flash 8 | Photoshop cs | CorelDraw 12
编程视频: C语言视频教程 | HTML | Div+Css布局 | Javascript | Access数据库 | Asp | Sql Server数据库Asp.net  | Flash AS
当前位置 > 文字教程 > Sql Server教程
Tag:注入,存储过程,分页,安全,优化,加密,索引,日志,压缩,base64,函数,内存,PDF,迁移,结构,破解,编译,配置,进程,分词,触发器,socket,安装,sqlserver2000,sqlserver2005,sqlserver2008,视频教程

centos系统安装php+mysql的apache服务器方法

文章类别:Sql Server | 发表日期:2012-3-13 11:49:51



CentOS 5.x yum安装LAMP(Apache+MySQL+PHP)

      LAMP是Linux,Apache,MySQL,PHP的缩写。这个教程主要是讲在centos安装有php和mysql支持的apache web服务器。在这个教程我使用主机名server1.example.com对应IP地址192.168.0.100。这些设置可能不同于你,你必须替换成你正确的。

添加外部源,保证MySQL和PHP最新

因为系统基本的源的MySQL和PHP程序比较旧,所以我们添加比较新的外部源。

1 # rpm --import http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka
2 # vi /etc/yum.repos.d/CentOS-Base.repo

在底部增加下面信息

1 [utterramblings]
2 name=Jason's Utter Ramblings Repo
3 baseurl=http://www.jasonlitka.com/media/EL$releasever/$basearch/
4 enabled=1
5 gpgcheck=1
6 gpgkey=http://www.jasonlitka.com/media/RPM-GPG-KEY-jlitka

安装MySQL

执行yum程序安装MySQL

1 yum install mysql mysql-server

添加MySQL进启动项(这样系统启动时会自动启动MySQL),并立即启动MySQL服务器:

1 chkconfig --levels 235 mysqld on
2 /etc/init.d/mysqld start

设置MySQL root帐号密码:

1 mysql_secure_installation
01 NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
02 SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
03
04 In order to log into MySQL to secure it, we'll need the current
05 password for the root user. If you've just installed MySQL, and
06 you haven't set the root password yet, the password will be blank,
07 so you should just press enter here.
08
09 Enter current password for root (enter for none):
10 OK, successfully used password, moving on...
11
12 Setting the root password ensures that nobody can log into the MySQL
13 root user without the proper authorisation.
14
15 Set root password? [Y/n] <-- ENTER
16 New password: <-- 你的MySQL root密码
17 Re-enter new password: <-- 你的MySQL root密码
18 Password updated successfully!
19 Reloading privilege tables..
20 ... Success!
21
22 By default, a MySQL installation has an anonymous user, allowing anyone
23 to log into MySQL without having to have a user account created for
24 them. This is intended only for testing, and to make the installation
25 go a bit smoother. You should remove them before moving into a
26 production environment.
27
28 Remove anonymous users? [Y/n] <-- ENTER
29 ... Success!
30
31 Normally, root should only be allowed to connect from 'localhost'. This
32 ensures that someone cannot guess at the root password from the network.
33
34 Disallow root login remotely? [Y/n] <-- ENTER
35 ... Success!
36
37 By default, MySQL comes with a database named 'test' that anyone can
38 access. This is also intended only for testing, and should be removed
39 before moving into a production environment.
40
41 Remove test database and access to it? [Y/n] <-- ENTER
42 - Dropping test database...
43 ... Success!
44 - Removing privileges on test database...
45 ... Success!
46
47 Reloading the privilege tables will ensure that all changes made so far
48 will take effect immediately.
49
50 Reload privilege tables now? [Y/n] <-- ENTER
51 ... Success!
52
53 Cleaning up...
54
55 All done! If you've completed all of the above steps, your MySQL
56 installation should now be secure.
57
58 Thanks for using MySQL!

安装Apache

Apache在CentOS软件包可用,因此我们可以使用yum安装:

1 yum install httpd

设置系统启动时自启动Apache

1 chkconfig --levels 235 httpd on

并启动Apache

1 /etc/init.d/httpd start

现在你直接在你的浏览器键入http://192.168.0.100,你就应该会看到Apache的测试页面。

安装PHP

我们可以按照下面的命令安装PHP和Apache PHP模块:

1 yum install php

然后重启Apache服务器:

1 /etc/init.d/httpd restart

安装相关模块使用PHP支持MySQL

为了让PHP支持MySQL,我们可以安装php-mysql软件包。你也可以安装其它的php模块。可以使用以下命令搜索可用的php模块:

1 yum search php

选择一些你需要的模块进行安装:

1 yum install php-mysql php-common php-mbstring php-gd php-imap php-ldap php-odbc php-pear php-xml php-xmlrpc

现在重启Apache:

1 /etc/init.d/httpd restart

安装phpMyAdmin

phpMyAdmin是一个可视化管理你的MySQL数据库的软件。
安装很简单,下载解压到根目录即可.
下载地址:http://www.phpmyadmin.net/home_page/downloads.php
接着我们配置phpMyAdmin,为了使用phpMyAdmin不仅仅只允许localhost连接,我们修改一下apache的配置。

1 vi /etc/httpd/conf.d/phpmyadmin.conf

填入如下内容:

01 #
02 # Web application to manage MySQL
03 #
04
05 #<directory share="" phpmyadmin?="" usr="" ?="">
06 # Order Deny,Allow
07 # Deny from all
08 # Allow from 127.0.0.1
09 #</directory>
10
11 Alias /phpmyadmin /usr/share/phpmyadmin
12 Alias /phpMyAdmin /usr/share/phpmyadmin
13 Alias /mysqladmin /usr/share/phpmyadmin

重启apache:
/etc/init.d/httpd restart
然后你就可以通过http://192.168.0.100/phpmyadmin/进入phpMyAdmin了。

视频教程列表
文章教程搜索
 
Sql Server推荐教程
Sql Server热门教程
看全部视频教程
购买方式/价格
购买视频教程: 咨询客服
tel:15972130058