易截截图软件、单文件、免安装、纯绿色、仅160KB

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


相关文档:

初学MySQL哪些需要你知道

MySQL的基本命令
  [ ]中的内容为可选项
  --创建数据库
  mysql> create database 数据库名称
  --创建表
  mysql> create table 表名 (
  列的名字(id)类型(int(4))primary key(定义主键) auto_increment(描述 自增),
  ……,
  );
  --查看所有数据库
  mys ......

如何提高MySQL性能

一、问题的提出

  在应用系统开发初期,由于开发数据库数据比较少,对于查询SQL语句,复杂视图的的编写等体会不出SQL语句各种写法的性能优劣,但是如果将应用系统
提交实际应用后,随着数据库中数据的增加,系统的响应速度就成为目前系统需要解决的最主要的问题之一。系统优化中一个很重要的方面就是SQL语句的优化。 ......

Windows下php和memcahe开发

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/ ......

mysql单机多实例运行实践(1)

1.install mysql
get mysql
http://ftp.iij.ad.jp/pub/db/mysql/Downloads/MySQL-5.1/mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# tar -zxvf mysql-5.1.41-linux-i686-icc-glibc23.tar.gz
[root@localhost mysql]# cd mysql-5.1.41-linux-i686-icc-glibc23
[root@localhost mysql]# vim RE ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号