《源码安装MySQL》由会员分享，可在线阅读，更多相关《源码安装MySQL（7页珍藏版）》请在金锄头文库上搜索。
1、 . . . . . Mysql 源码安装一、文章说明 最近接触到mysql数据库，因此闲来研究一下，今天演示一下用源码安装mysql，如果使用rpm包安装的话个人感觉挺简单的。 环境说明： 操作系统：rhel 5.4 x86 Mysql版本：mysql-5.5.22二、安装cmake(mysql5.5以后是通过cmake来编译的) 在mysql5.5之前的话直接编辑就可以，而在5.5以后需要通过cmake来编译，在附录中介绍一下直接编译。 下载cmake-2.8.4.tar.gz，本人是在度娘搜的。rootnode4 # tar -zxvf cmake-2.8.4.tar.gzrootnod
2、e4 # cd cmake-2.8.4rootnode4 cmake-2.8.4# ./configure -prefix=/usr/local/cmake-在这里可以使用# gmake & make installrootnode4 cmake-2.8.4# makerootnode4 cmake-2.8.4# make install 备注：configure需要执行编译到目录。三、创建mysql的安装目录及数据库存放目录rootnode4 # mkdir -p /opt/mysql5.5rootnode4 # mkdir -p /opt/mysql5.5/data 四、创建mysql用户
3、及用户组rootnode4 # groupadd mysqlrootnode4 # useradd -r -g mysql mysql五、安装mysqlrootnode4 # tar -zxvf mysql-5.5.22.tar.gzrootnode4 # cd mysql-5.5.22-编译出现以下错误，需要ncurses-develrootnode4 mysql-5.5.22#/usr/local/cmake/bin/cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql5.5 -DMYSQL_DATADIR=/opt/mysql5.5/data -DDEFAULT
4、_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1- MySQL 5.5.22- Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH) CMake Error at cmake/readline.cmake:83 (MESSAGE): Curses library not found. Please install appropriate package, remove CM
5、akeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.Call Stack (most recent call first): cmake/readline.cmake:127 (FIND_CURSES) cmake/readline.cmake:217 (MYSQL_USE_BUNDLED_LIBEDIT) CMakeLists.txt:268 (MYSQL_CHECK_READLINE)- Conf
6、iguring incomplete, errors occurred!-查看ncurses是否安装：rootnode4 mysql-5.5.22# rpm -qa|grep necursesncurses-5.5-24.20060715-安装ncurses-develrootnode4# rpm -ivh ncurses-devel-5.5-24.20060715.i386.rpm warning: ncurses-devel-5.5-24.20060715.i386.rpm: Header V3 DSA signature: NOKEY, key ID 37017186Preparing.
7、 # 100% 1:ncurses-devel # 100%-删除CMakeCache.txtrootnode4 mysql-5.5.22# find / -name CMakeCache.txt/root/mysql-5.5.22/CMakeCache.txt/root/cmake-2.8.4/CMakeCache.txt/root/cmake-2.8.4/Tests/ComplexOneConfig/Cache/CMakeCache.txt/root/cmake-2.8.4/Tests/Complex/Cache/CMakeCache.txt/root/cmake-2.8.4/Tests/
8、CMakeFiles/CheckFortran/CMakeCache.txt/root/cmake-2.8.4/Tests/ComplexRelativePaths/Cache/CMakeCache.txtrootnode4 mysql-5.5.22# rm /root/mysql-5.5.22/CMakeCache.txtrm: remove regular file /root/mysql-5.5.22/CMakeCache.txt? yesrootnode4 mysql-5.5.22# rm /root/cmake-2.8.4/CMakeCache.txtrm: remove regul
9、ar file /root/cmake-2.8.4/CMakeCache.txt? yesrootnode4 mysql-5.5.22# rm /root/cmake-2.8.4/Tests/ComplexOneConfig/Cache/CMakeCache.txtrm: remove regular file /root/cmake-2.8.4/Tests/ComplexOneConfig/Cache/CMakeCache.txt? yesrootnode4 mysql-5.5.22# rm /root/cmake-2.8.4/Tests/Complex/Cache/CMakeCache.t
10、xtrm: remove regular file /root/cmake-2.8.4/Tests/Complex/Cache/CMakeCache.txt? yesrootnode4 mysql-5.5.22# rm /root/cmake-2.8.4/Tests/CMakeFiles/CheckFortran/CMakeCache.txtrm: remove regular file /root/cmake-2.8.4/Tests/CMakeFiles/CheckFortran/CMakeCache.txt? yesrootnode4 mysql-5.5.22# rm /root/cmak
11、e-2.8.4/Tests/ComplexRelativePaths/Cache/CMakeCache.txtrm: remove regular file /root/cmake-2.8.4/Tests/ComplexRelativePaths/Cache/CMakeCache.txt? yes-再次进行编译：rootnode4 mysql-5.5.22#/usr/local/cmake/bin/cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql5.5 -DMYSQL_DATADIR=/opt/mysql5.5/data -DDEFAULT_CHARSET=utf
12、8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DENABLED_LOCAL_INFILE=1rootnode4 mysql-5.5.22#make & make install 备注：-DCMAKE_INSTALL_PREFIX=/usr/local/mysql /安装目录-DINSTALL_DATADIR=/usr/local/mysql/data /数据库存放目录-DDEFAULT_CHARSET=utf8 /使用utf8字符-DDEFAULT_COLLATION=utf8_general_ci /校验字符-DEXT
13、RA_CHARSETS=all /安装所有扩展字符集-DENABLED_LOCAL_INFILE=1 /允许从本地导入数据 注意事项： 重新编译时，需要清除旧的对象文件和缓存信息。 #make clean #rm -f CMakeCache.txt #rm -rf /etc/f六、设置目录权限rootnode4 # cd /opt/mysql5.5/rootnode4 mysql5.5# chown -R root:mysql . /把当前目录中所有文件的所有者设为root，所属组为mysql rootnode4 mysql5.5# chown -R mysql:mysql data/七、设置
14、mysql配置文件rootnode4 mysql5.5# cp support-files/my-f /etc/f /将mysql的启动服务添加到系统服务中rootnode4 mysql5.5# cp support-files/my-f frootnode4 mysql5.5# more f -在mysqld下面添加basedir = /opt/mysql5.5 datadir = /opt/mysql5.5/data mysqldport = 3306socket = /tmp/mysql.sockskip-external-lockingkey_buffer_size = 16Mmax_allowed_packet = 1Mtable_open_cache = 64
