mysql 源码安装

glibc 需求：/usr/local/mysql24/usr/local/mysql24/data步骤：1、创建用户组# id mysqluid=27(mysql) gid=27(mysql) groups=27(mysql)2、下载mysql5.6.24的软件包，并解压tar -xf /soft/mysql-5.6.24-linux-glibc2.5-x86_64.tar.gz -C /soft3、做软连接，将解压的所有文件连接到mysql的安装目录ln -s /soft/mysql-5.6.24-linux-glibc2.5-x86_64 /usr/local/mysql244、进入到/usr/local/mysql24目录里# chown -R mysql.mysql .5、安装mysql数据库scripts/mysql_install_db --user=mysql目的：在mysql的数据目录里初始化数据文件（/usr/local/mysql24/data）6、更改mysql安装目录的属主和数据目录的属主chown -R root .chown -R mysql ./data7、后台启动数据库bin/mysqld_safe --user=mysql &é—®é¢˜ï¼šå¯åŠ¨å¤±è´¥åŽŸå› ï¼šå½“å‰ç³»ç»Ÿä¸­æœ‰ä¸€ä¸ª5.6.19çš„mysql数据库在启动解决：先停止掉5.6.19çš„mysql数据库8、创建mysql24的启动脚本文件cp support-files/mysql.server /etc/init.d/mysql24注意：修改脚本文件中的basedir=/usr/local/mysql24datadir=/usr/local/mysql24/data9、用脚本再次测试验证service mysql24 restartè¯¾å ‚ç»ƒä¹ ï¼šæ•°æ®å®‰è£…ç›®å½•ï¼š/mysql24数据目录：/mysql24/dataé—®é¢˜ï¼šæ€Žæ ·åœ¨åŒä¸€å°æœåŠ¡å™¨ä¸Šå¯åŠ¨å®žä¾‹ï¼Ÿæ€è·¯ï¼š1、需要给不同的数据库指定不同的端口2、每个数据库的安装目录和数据目录不同3、通过修改配置文件来更改端口以及数据目录/etc/my.cnf /etc/mysql/my.cnf /usr/etc/my.cnf ~/.my.cnf 5.6.19：MySQL  ——>/var/lib/mysql——>my.cnfvim /var/lib/mysql/my.cnf[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sockuser=mysqllog-error=/var/log/mysqld.logpid-file=/var/run/mysqld/mysqld.pidport=33065.6.24:mysql   ——>/usr/local/mysql24——>my.cnfvim /usr/local/mysql24/my.cnf basedir = /usr/local/mysql24 datadir = /usr/local/mysql24/data port = 3307 socket = /tmp/mysql.sock访问：mysql -p  ——>5.6.19mysql -S /var/lib/mysql.sockmysql -P3306 -p/usr/local/mysql24/bin/mysql ——>5.6.24mysql -S /tmp/mysql.sockæºç åŒ…å®‰è£…mysql：1ã€ä¸‹è½½æºç åŒ… www.mysql.com# md5sum mysql-5.6.25.tar.gz 37664399c91021abe070faa700ecd0ed  mysql-5.6.25.tar.gz2、解压并且进入到解压的目录# tar -xf mysql-5.6.25.tar.gz # cd mysql-5.6.253、安装三步曲（配置、编译、安装）需求：安装目录：/mysql25数据目录：/mysql25/data端口：3308sock：/mysql25/mysql.sockCMAKE_INSTALL_PREFIX=/mysql25   指定安装基目录DEFAULT_CHARSET=   默认的字符集DEFAULT_COLLATION= 字符集的排序ENABLED_LOCAL_INFILE=  æ˜¯å¦åŠ è½½å¤–éƒ¨æ–‡ä»¶ 默认off 1代表开启；0代表关闭MYSQL_TCP_PORT       端口号MYSQL_UNIX_ADDR     指定sock文件位置SYSCONFDIR         系统配置文件所在路径MYSQL_DATADIR      数据库的数据目录WITH_EXTRA_CHARSETS 扩展字符集  WITHOUT_xxx_STORAGE_ENGINE  不将存储引擎编译到mysql的静态库里WITH_xxx_STORAGE_ENGINE 将存储引擎编译到mysql的静态库里cmake . \-DCMAKE_INSTALL_PREFIX=/mysql25 \-DENABLED_LOCAL_INFILE=1 \-DMYSQL_DATADIR=/mysql25/data \-DSYSCONFDIR=/mysql25/ \-DWITH_INNOBASE_STORAGE_ENGINE=1 \-DWITH_PARTITION_STORAGE_ENGINE=1 \-DMYSQL_UNIX_ADDR=/mysql25/mysql.sock \-DDEFAULT_CHARSET=utf8 \-DDEFAULT_COLLATION=utf8_general_ci \-DWITH_EXTRA_CHARSETS=all \-DMYSQL_USER=mysql \-DMYSQL_TCP_PORT=3308# cmake . -DCMAKE_INSTALL_PREFIX=/mysql25 -DENABLED_LOCAL_INFILE=1...准备工作：# yum -y install cmake# mkdir /mysql25# chown -R mysql. /mysql25错误提示：-- Could NOT find Curses  (missing:  CURSES_LIBRARY CURSES_INCLUDE_PATH)CMake Error at cmake/readline.cmake:85 (MESSAGE):  Curses library not found.  Please install appropriate package,# yum -y install ncurses-devel# rm -f CMakeCache.txtbash cmake.shmakemake installå­—ç¬¦é›†å’Œå­—ç¬¦ç¼–ç ï¼šå­—ç¬¦ï¼šæ‰€æœ‰ç¬¦å·çš„æ€»ç§°å­—ç¬¦é›†ï¼šunicode（统一字符集）：ASCII:GB2312:中文字符集GBK：gb2312的扩展字符集GB18030：gbkçš„è¶…çº§å­—ç¬¦é›†ï¼ŒåŒ…å«ä¸­ã€æ—¥ã€éŸ©ä¸‰ä¸ªå›½å®¶çš„å­—ç¬¦é›†å­—ç¬¦ç¼–ç ï¼šUTF-8 UTF-16 UCS-2 UCS-4GBK/GB2312GB18030å­—ç¬¦ç¼–ç         每个字符字节数ASCCii        1UTF-8（UNICODE）  1-6UTF-16       2-4GBK/GB2312   1-2GB18030      1-4错误提示：CMake Error at /usr/share/cmake/Modules/CMakeCXXInformation.cmake:17 (GET_FILENAME_COMPONENT):  get_filename_component called with incorrect number of argumentsCall Stack (most recent call first):  CMakeLists.txt:3 (PROJECT)CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguageCMake Error: Internal CMake error, TryCompile configure of cmake failed-- Performing Test HAVE_PEERCRED - Failed解决：yum -y install gcc-*