glibc
需求:
/usr/local/mysql24
/usr/local/mysql24/data
æ¥éª¤ï¼š
1ã€åˆ›å»ºç”¨æˆ·ç»„
# id mysql
uid=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 /soft
3ã€åšè½¯è¿žæŽ¥ï¼Œå°†è§£åŽ‹çš„所有文件连接到mysql的安装目录
ln -s /soft/mysql-5.6.24-linux-glibc2.5-x86_64 /usr/local/mysql24
4ã€è¿›å…¥åˆ°/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 ./data
7ã€åŽå°å¯åŠ¨æ•°æ®åº“
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/mysql24
datadir=/usr/local/mysql24/data
9ã€ç”¨è„šæœ¬å†æ¬¡æµ‹è¯•éªŒè¯
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.cnf
vim /var/lib/mysql/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
port=3306
5.6.24:mysql ——>/usr/local/mysql24——>my.cnf
vim /usr/local/mysql24/my.cnf
basedir = /usr/local/mysql24
datadir = /usr/local/mysql24/data
port = 3307
socket = /tmp/mysql.sock
访问:
mysql -p ——>5.6.19
mysql -S /var/lib/mysql.sock
mysql -P3306 -p
/usr/local/mysql24/bin/mysql ——>5.6.24
mysql -S /tmp/mysql.sock
æºç 包安装mysql:
1ã€ä¸‹è½½æºç 包 www.mysql.com
# md5sum mysql-5.6.25.tar.gz
37664399c91021abe070faa700ecd0ed mysql-5.6.25.tar.gz
2ã€è§£åŽ‹å¹¶ä¸”进入到解压的目录
# tar -xf mysql-5.6.25.tar.gz
# cd mysql-5.6.25
3ã€å®‰è£…三æ¥æ›²ï¼ˆé…ç½®ã€ç¼–译ã€å®‰è£…)
需求:
安装目录:/mysql25
æ•°æ®ç›®å½•ï¼š/mysql25/data
端å£ï¼š3308
sock:/mysql25/mysql.sock
CMAKE_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.txt
bash cmake.sh
make
make install
å—符集和å—符编ç :
å—符:所有符å·çš„总称
å—符集:
unicode(统一å—符集):
ASCII:
GB2312:ä¸æ–‡å—符集
GBK:gb2312的扩展å—符集
GB18030:gbk的超级å—符集,包å«ä¸ã€æ—¥ã€éŸ©ä¸‰ä¸ªå›½å®¶çš„å—符集
å—符编ç :
UTF-8 UTF-16 UCS-2 UCS-4
GBK/GB2312
GB18030
å—符编ç æ¯ä¸ªå—符å—节数
ASCCii 1
UTF-8(UNICODE) 1-6
UTF-16 2-4
GBK/GB2312 1-2
GB18030 1-4
错误æ示:
CMake Error at /usr/share/cmake/Modules/CMakeCXXInformation.cmake:17 (GET_FILENAME_COMPONENT):
get_filename_component called with incorrect number of arguments
Call Stack (most recent call first):
CMakeLists.txt:3 (PROJECT)
CMake Error: CMAKE_CXX_COMPILER not set, after EnableLanguage
CMake Error: Internal CMake error, TryCompile configure of cmake failed
-- Performing Test HAVE_PEERCRED - Failed
解决:
yum -y install gcc-*
mysql 源码安装
最新推荐文章于 2023-10-13 01:25:53 发布