mysql-5.1.36编译安装.docxVIP

mysql-5.1.36.tar.gz编译安装2009-08-07 09:01cd /usr/local/srcwget ftp://mirror2.dataphone.se/pub/mysql/Downloads/MySQL-5.1/mysql-5.1.36.tar.gz???????? //下载mysql数据库#解压chmod 755 mysql-*tar zxvf mysql-5.1.36.tar.gzcd mysql-5.1.36#创建安装目录mkdir -pv /opt/mysql5136/#编译前的配置./configure --prefix=/opt/mysql5136/ --without-debug --enable-assembler --with-extra-charsets=all --with-pthread --enable-thread-safe-client#编译安装makemake install#创建mysql需要的用户和组/usr/sbin/groupadd mysql/usr/sbin/useradd -g mysql mysql#设置目录权限chmod +w /opt/mysql5136chown -R mysql:mysql /opt/mysql5136#创建要使用的目录并设置权限[root@localhost mysql-5.1.36]# mkdir -pv /opt/mysql5136/mysql/3306/[root@localhost mysql-5.1.36]# chmod +w /opt/mysql5136/mysql/3306/[root@localhost mysql-5.1.36]# chown -R mysql:mysql /opt/mysql5136/mysql/3306/[root@localhost mysql-5.1.36]# mkdir -pv /opt/mysql5136/mysql/3306/data[root@localhost mysql-5.1.36]# chmod +w /opt/mysql5136/mysql/3306/data/[root@localhost mysql-5.1.36]# chown -R mysql:mysql /opt/mysql5136/mysql/3306/data/[root@localhost mysql-5.1.36]# chown -R mysql:mysql /opt/mysql5136/mysql[root@localhost mysql-5.1.36]# cp support-files/f /opt/mysql5136/mysql/3306/f[root@localhost mysql-5.1.36]# cd ../#修改f文件vi /opt/mysql5136/mysql/3306/f ##########修改下列红色这几处################# Example MySQL config file for medium systems.## This is for a system with little memory (32M - 64M) where MySQL plays# an important part, or systems up to 128M where MySQL is used together with# other programs (such as a web server)## You can copy this file to# /etc/f to set global options,# mysql-data-dir/f to set server-specific options (in this# installation this directory is /opt/mysql5136/var) or# ~/.f to set user-specific options.## In this file, you can use all long options that a program supports.# If you want to know which options a program supports, run the program# with the --help option.# The following options will be passed to all MySQL clients[client]#password??? = your_passwordport??? ??? = 3306socket??? ???