how to install apache, PHP and MySQL on Linux
how to install apache, PHP and MySQL on Linux
This tutorial explains the installation of Apache web server, bundled with PHP and MySQL server on a Linux machine. The tutorial is primarily for SuSE 9.2, 9.3, 10.0 & 10.1 operating systems, but most of the steps ought to be valid for all Linux-like operating systems.
Contents:
MySQL 5 Installation
Prerequisites
Download the Source
Unpack, Copy, Configure
Create my.cnf File
Additional Settings
Start Server, Check It, Connect
Set the Root Password
Restart MySQL Server
Automatic Startup
Apache 2 Installation
PHP 5 Installation
MySQL 5.0 installation
Since Apache and MySQL servers must be installed prior to the PHP installation, I recommend installing the triad in this order: MySQL, Apache, PHP. You may well have some MySQL server already installed – in that case you can skip directly to the Apache 2 installation. However, it's a good idea to reinstall everything, in order to have the most recent versions of the software.
There are several options for how to install MySQL:
using YaST – the easiest and fastest way. However, the version of MySQL bundled with SuSE installation is usually NOT the best (i.e. the most recent) available,
RPM installation – supposedly also fast and simple, I've never tried though. The only drawback here is that MySQL is not installed into a single destination – it's scattered across several directories. I like to keep things tidy, so I skipped this option,
installing binaries – downloading precompiled files from the mysql.com website, copying them into a directory of your choice, and doing some simple configuration. I tried this, but it didn't work for me – for some reason the MySQL server wouldn't start,
installing from source – I would recommend this. Yes, it takes some time and effort, but you will get the most recent MySQL installed in a single location on your system, and everything will be configured accord
相关文档:
linux下 mysql 的卸载和安装
关键字: linux下 mysql 的卸载和安装
一、前期准备:
1
.由于redhat Enterprise 5 中自带一个mysql的版本,如果在安装linux前未选择mysql的安装此步就可跳过,因为我当时安装了现在将其卸载
,步骤如下:
&nb ......
引用 夜落古龙 的 MySql Administrator 的简单使用(图)
MySQL Administrator提供图形界面以帮助你管理MySQL数据库,Windows用户可以通过命令提示行运行MySQL
Administrator,在余下时间里我假定你已经安装了MySQL Administrator,并且将使用相关图例。
MySQL
Administrator主界面
创建数据库
......
MySQL易学易用,且附带丰富的技术文档,这二个因素使之被广泛应用。然而,随着MySQL发展之迅速,即使一个MySQL老手有时也会为该软件出其不意的功能感叹。本文将为你介绍这些不为人知的特性。
以XML格式查看查询结果
通过使用传统—xml
选项调用MySQL命令行客户程序,你可以以XML格式(而不是传统的列表形式)来查看M ......
最近在MySQL上做了点工作,发现很多人都在询问MySQL嵌套查询的问题,许多人都觉得MySQL不支持嵌套查询,其实MySQl从4.11版后已经完全支持嵌套查询了,那么下面我举些简单的嵌套查询的例子吧(源程序来自MySQL User Manual):
1. SELECT语句的子查询:
语法: SELECT ... from (subquery) AS name ...
先创建一个表:
......
memcached本地windows系统测试
用的是windows系统。
1.下载Memcache for win32
下载地址: http://jehiah.cz/projects/memcached-win32/
选择memcached 1.2.1 for Win32 binaries (Dec 23, 2006) 是exe的程序
memcached.exe -d install
memcached -d start
2.下载php_memcache.dll
下载地址: http://www.wesoho.com/ ......