try mysql5.5.8

最新推荐文章于 2025-08-10 13:24:43 发布

转载最新推荐文章于 2025-08-10 13:24:43 发布 · 122 阅读

文章标签：

#数据库

本文详细记录了 MySQL 5.5.8 版本从源码安装的过程，包括环境配置、编译参数设置、初始化数据库等关键步骤，并提供了在安装过程中遇到的问题及解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

install mysql558[@more@]

首先阅读下官方文档说明http://dev.mysql.com/doc/refman/5.5/en/source-installation.html

按照cmake吧，就不说了,下载源码，改bug

http://bugs.mysql.com/bug.php?id=58350
http://lists.mysql.com/commits/126782

编译

CC='/usr/bin/gcc'
CFLAGS='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -fPIC -Wall -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF'
CXX='/usr/bin/gcc'
CXXFLAGS='-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -felide-constructors -fno-exceptions -fno-rtti -fPIC -Wall -Wno-unused-parameter -fno-implicit-templates -fno-exceptions -fno-rtti -O3 -g -static-libgcc -fno-omit-frame-pointer -fno-strict-aliasing -DDBUG_OFF'
LDFLAGS=''
ASFLAGS=''
cmake -DCMAKE_INSTALL_PREFIX=$MYSQL_HOME
-DDEFAULT_CHARSET=gbk
-DMYSQL_UNIX_ADDR=$MYSQL_HOME/run/mysql.sock
-DWITH_INNOBASE_STORAGE_ENGINE=1
-DWITH_PERFSCHEMA_STORAGE_ENGINE=1
-DWITHOUT_ARCHIVE_STORAGE_ENGINE=1
-DWITHOUT_BLACKHOLE_STORAGE_ENGINE=1
-DWITHOUT_EXAMPLE_STORAGE_ENGINE=1
-DWITHOUT_FEDERATED_STORAGE_ENGINE=1
-DWITHOUT_PARTITION_STORAGE_ENGINE=1
-DWITHOUT_ARCHIVE_STORAGE_ENGINE=1 .

make -j 16

make install

InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
101221 13:51:32 InnoDB: Using Linux native AIO
101221 13:51:32 InnoDB: Initializing buffer pool, size = 32.0G
101221 13:51:33 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
101221 13:51:33 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
101221 13:51:33 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 500 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
101221 13:51:34 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 500 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200 300 400 500
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
101221 13:51:37 InnoDB: 1.1.4 started; log sequence number 0
101221 13:51:37 [Warning] 'user' entry 'root@userext4-ztb' ignored in --skip-name-resolve mode.
101221 13:51:37 [Warning] 'user' entry '@userext4-ztb' ignored in --skip-name-resolve mode.
101221 13:51:37 [Warning] 'proxies_priv' entry '@ root@userext4-ztb' ignored in --skip-name-resolve mode.
101221 13:51:37 [Note] Event Scheduler: Loaded 0 events
101221 13:51:37 [Note] /home/oracle/mysql/bin/mysqld: ready for connections.
Version: '5.5.8-log' socket: '/home/oracle/mysql/run/mysql.sock' port: 3306 Source distribution