mysql 源码安装步骤,记录以备忘
源码安装好处,据说速度更快
也不用分32位,64位,也就是说不分平台.
mysql 源码安装步骤
一。解压
tar zxvf mysql-5.1.53.tar.gz
二。建启动用户
groupadd mysql
useradd -g mysql mysql
三。配置
./configure --prefix=/usr/local/mysql -localstatedir=/home/mysql --with-unix-socket-path=/tmp/mysql.sock --enable-thread-safe-client --with-charset=utf8 --with-extra-charsets=all --with-federated-storage-engine --with-plugins=csv,innobase,myisam,heap,federated,partition --without-debug
四编译
make
五 安装
make install
六 初始化配置文件
/etc/my.cnf
修改
'skip-locking'为
'skip-external-locking'
七初始化库
bin/mysql_install_db --user=mysql
八 目录权限
cd /usr/local/mysql
chown -R root .
chown -R mysql /home/mysql (数据目录)
chgrp -R mysql .
启动
bin/mysqld_safe --user=mysql &
八、添加服务,设置为自动启动
cp /usr/local/mysql/share/mysql/mysql.server /etc/rc.d/init.d/mysqld
chmod 755 /etc/rc.d/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
service mysqld start
九、修改密码
mysqladmin -u root password ' 密码 ' ;
delete from user where password = '';
5.5源码安装
5.5 需要cmake编译安装
一、安装cmake(mysql5.5以后是通过cmake来编译的)
# wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz
# tar zxvf cmake-2.8.4.tar.gz
# cd cmake-2.8.4
#.configure
# make && make install
二、编译
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql/ -DMYSQL_DATADIR=/home/mysql/ /
-DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 /
-DDEFAULT_CHARSET=utf8 -DEXTRA_CHARSETS=all -DDEFAULT_COLLATION=utf8_general_ci /
-DWITH_DEBUG=0
然后 是make && make install
其它步骤参考5.1