OS: Red Hat Enterprise Linux Server release 4.0
MySQL: 5.1.59
源码 放置在 /root/insatll/mysql , 安装目的地是/usr/local/mysql-5.1
1.准备
创建一个用户来运行 MySQL 守护进程。
# groupadd mysqlg
# useradd –g mysqlg –r mysql
# cd /root/insatll/mysql
# tar zxvf mysql-5.1.59.tar.gz
2.配置编译选项,编译、安装
# cd mysql-5.1.59
# ./configure --prefix=/usr/local/mysql-5.1 \
--with-charset=utf8 \
--with-extra-charsets=all \
--with-tcp-port=3306 \
--with-unix-socket-path=/tmp/mysql.sock \
--with-mysqld-user=mysqld \
--with-federated-storage-engine \
--wih-mysqld-user=mysqld \
--with-plugins=innobase,myisam \
--enable-assembler \
--without-isam \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static
# make && make install
3. 初始化数据库
# scripts/mysql_install_db
4. 配置
在 MySQL 提供的支持文件中复制一个合适的配置档到 MySQL 数据目录中,并命名为 my.cnf
# cp support-files/my-media.cnf /etc/my.cnf
完成编辑此配置档后,记得顺便修改一下 MySQL 数据目录的 ownership:
# cd /usr/local
# chown –R mysql mysql-5.1
--------------------------------------------------------------------------------------------------------------------
OS: Red Hat Enterprise Linux Server release 4.0
MySQL: 5.5.16
1.安装CMAKE & ncurses-devel
下载cmake-2.8.6-Linux-i386.tar.gz包,放置在/root/install/tool下
#tar xzf cmake-2.8.6-Linux-i386.tar.gz
下载ncurses-devel-5.9-2.20110716.fc16.i686.rpm,放置在/root/install/tool下
#rpm -ivh --nodeps ncurses-devel-5.9-2.20110716.fc16.i686.rpm
2.安装准备
下载mysql-5.5.16.tar.gz包 ,放置到/root/install/mysql目录下
#tar xzf mysql-5.5.16.tar.gz
#cd mysql-5.5.16
3.编译安装
#/root/install/tool/cmake-2.8.6-Linux-i386/bin/cmake . LH
#/root/install/tool/cmake-2.8.6-Linux-i386/bin/cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MYIASM_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
#make && make install
4.配置
share/mysql/my-medium.cnf /etc/my.cnf
chown -R mysql /etc/my.cnf
修改配置文件 配置数据文件、日志的路径
vi /etc/my.cnf
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/logs/err
初始MySQL配置表(用户表 权限表等)
./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
MySQL: 5.1.59
源码 放置在 /root/insatll/mysql , 安装目的地是/usr/local/mysql-5.1
1.准备
创建一个用户来运行 MySQL 守护进程。
# groupadd mysqlg
# useradd –g mysqlg –r mysql
# cd /root/insatll/mysql
# tar zxvf mysql-5.1.59.tar.gz
2.配置编译选项,编译、安装
# cd mysql-5.1.59
# ./configure --prefix=/usr/local/mysql-5.1 \
--with-charset=utf8 \
--with-extra-charsets=all \
--with-tcp-port=3306 \
--with-unix-socket-path=/tmp/mysql.sock \
--with-mysqld-user=mysqld \
--with-federated-storage-engine \
--wih-mysqld-user=mysqld \
--with-plugins=innobase,myisam \
--enable-assembler \
--without-isam \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static
# make && make install
3. 初始化数据库
# scripts/mysql_install_db
4. 配置
在 MySQL 提供的支持文件中复制一个合适的配置档到 MySQL 数据目录中,并命名为 my.cnf
# cp support-files/my-media.cnf /etc/my.cnf
完成编辑此配置档后,记得顺便修改一下 MySQL 数据目录的 ownership:
# cd /usr/local
# chown –R mysql mysql-5.1
--------------------------------------------------------------------------------------------------------------------
OS: Red Hat Enterprise Linux Server release 4.0
MySQL: 5.5.16
1.安装CMAKE & ncurses-devel
下载cmake-2.8.6-Linux-i386.tar.gz包,放置在/root/install/tool下
#tar xzf cmake-2.8.6-Linux-i386.tar.gz
下载ncurses-devel-5.9-2.20110716.fc16.i686.rpm,放置在/root/install/tool下
#rpm -ivh --nodeps ncurses-devel-5.9-2.20110716.fc16.i686.rpm
2.安装准备
下载mysql-5.5.16.tar.gz包 ,放置到/root/install/mysql目录下
#tar xzf mysql-5.5.16.tar.gz
#cd mysql-5.5.16
3.编译安装
#/root/install/tool/cmake-2.8.6-Linux-i386/bin/cmake . LH
#/root/install/tool/cmake-2.8.6-Linux-i386/bin/cmake . \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
-DSYSCONFDIR=/etc \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MYIASM_STORAGE_ENGINE=1 \
-DMYSQL_UNIX_ADDR=/tmp/mysqld.sock \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
#make && make install
4.配置
share/mysql/my-medium.cnf /etc/my.cnf
chown -R mysql /etc/my.cnf
修改配置文件 配置数据文件、日志的路径
vi /etc/my.cnf
basedir = /usr/local/mysql
datadir = /usr/local/mysql/data
log-error = /usr/local/mysql/logs/err
初始MySQL配置表(用户表 权限表等)
./scripts/mysql_install_db --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data