CentOS源码安装MySQL5.1.41

来源：互联网发布：淘宝大学讲师魔布编辑：程序博客网时间：2024/05/17 03:42

#安装需要的库   yum -y install ncurses ncurses-devel     #创建MySQL用户及用户组   groupadd mysql   useradd -g mysql -s /sbin/nologin mysql     cp /home/root/mysql-5.1.41.tar.gz /usr/local/src   cd /usr/local/src   tar zxvf mysql-5.1.41.tar.gz   chown -R mysql:mysql mysql-5.1.41  cd mysql-5.1.41  ./configure \   --prefix=/usr/local/mysql \   --localstatedir=/usr/local/mysql/data \   --with-unix-socket-path=/usr/local/mysql/data/mysql.sock \   --with-plugins=innobase,partition,myisam,heap \   --enable-assembler \   --with-charset=utf8 \   --enable-thread-safe-client \   --with-client-ldflags=-all-static \   --with-mysqld-ldflags=-all-static \   --enable-static=yes \   --with-big-tables     make   make install

#根据应用程序的负载选择对应的配置文件   mkdir /usr/local/mysql/etc   cp /usr/local/mysql/share/mysql/my-medium.cnf /usr/local/mysql/etc/my.cnf   vi /usr/local/mysql/etc/my.cnf     #在[mysqld]中添加：   pid-file = /usr/local/mysql/etc/mysql.pid   datadir = /usr/local/mysql/data   #设置pid位置及数据存放位     chown -R mysql:mysql /usr/local/mysql

#安装系统表   /usr/local/mysql/bin/mysql_install_db \   --basedir=/usr/local/mysql \   --defaults-file=/usr/local/mysql/etc/my.cnf \   --skip-external-locking \   --user=mysql     #启动MySQL   /usr/local/mysql/bin/mysqld_safe \   --defaults-file=/usr/local/mysql/etc/my.cnf \   --user=mysql &

#将MySQL添加到系统服务   cp /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld   chmod 700 /etc/init.d/mysqld   chkconfig --add mysqld