mysql-5.5.33编译安装
来源:互联网 发布:吉百利巧克力知乎 编辑:程序博客网 时间:2024/06/05 10:50
下载mysql编译工具:cmake,网站:https://cmake.org/download/
tar xf cmake-3.5.2.tar.gz
./bootstrap
make
make install
或者用yum安装:yum install cmake
创建mysql用户和组:
groupadd -r mysql -g 36
useradd mysql -g mysql -u 36 -r
安装编译工具:
yum -y install ncurses-devel
yum install -y gcc-c++
编译mysql:
mkdir /data/db/mysql/port/{data,binlog} -pv
chown -R mysql:mysql /data/db/
cd mysql-5.5.33
cmake . -DCMAKE_INSTALL_PREFIX=/data/db/mysql/ -DMYSQL_DATADIR=/data/db/mysql/port/data/ -DSYSCONFDIR=/data/db/mysql/etc -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DMYSQL_UNIX_ADDR=/data/db/mysql/port/mysql.sock -DWITH_LIBWRAP=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make
make install
配置mysql:
cd /data/db/mysql/
mkdir etc
cp support-files/my-large.cnf etc/my.cnf
grep -v '^#' etc/my.cnf
[client]
port = 3306
socket = /data/db/mysql/port/mysql.sock
[mysqld]
port = 3306
socket = /data/db/mysql/port/mysql.sock
datadir = /data/db/mysql/port/data
skip-external-locking
key_buffer_size = 256M
max_allowed_packet = 1M
table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
log-bin = /data/db/mysql/port/binlog
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
ln -sv /data/db/mysql /usr/local/mysql
./scripts/mysql_install_db --datadir=/data/db/mysql/port/data/ --user=mysql
mysql-5.5.33报错:CMake Error: CMAKE_CXX_COMPILER not set:
系统环境:Centos 6.5 64位
数据库版本:mysql-5.5.33.tar.gz
准备工作:
# yum install cmake
新建用户以安全方式运行进程:
# groupadd -r mysql
# useradd -g mysql -r -s /sbin/nologin -M -d /data/mysql mysql
# chown -R mysql:mysql /data/mysql
卸载系统中旧的mysql版本
# rpm -e mysql-libs --nodeps
将源码包放到 /usr/local/src下并解压
# tar xf mysql-5.5.33.tar.gz && cd mysql-5.5.33
编译安装mysql
# cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql \
>-DSYSCONFDIR=/etc -DMYSQL_DATADIR=/data/mysql \
>-DWITH_INNOBASE_STORAGE_ENGINE=1 \
>-DWITH_ARCHIVE_STORAGE_ENGINE=1 \
>-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
>-DWITH_READLINE=1 -DWITH_SSL=system \
>-DWITH_ZLIB=system -DWITH_LIBWRAP=0 \
>-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
>-DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
检查系统环境过程中报错:
CMake Error at /usr/share/cmake/Modules/CMakeCXXInformation.cmake:37 (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
-- Configuring incomplete, errors occurred!
See also "/usr/local/src/mysql-5.5.33/CMakeFiles/CMakeOutput.log".
See also "/usr/local/src/mysql-5.5.33/CMakeFiles/CMakeError.log".
个人感觉比较诡异,在网上查了片刻,有的是需要安装 gcc相关的编译器,感觉似乎是这样
# yum install gcc gcc-c++
删除产生的CMakeCache.txt文件,然后重新运行cmake
# rm -r CMakeCache.txt
-- Configuring done
CMake Warning (dev) in sql/CMakeLists.txt:
Policy CMP0022 is not set: INTERFACE_LINK_LIBRARIES defines the link
interface. Run "cmake --help-policy CMP0022" for policy details. Use the
cmake_policy command to set the policy and suppress this warning.
Target "mysqld" has an INTERFACE_LINK_LIBRARIES property which differs from
its LINK_INTERFACE_LIBRARIES properties.
INTERFACE_LINK_LIBRARIES:
-lpthread;sql;mysys
LINK_INTERFACE_LIBRARIES:
rt
This warning is for project developers. Use -Wno-dev to suppress it.
-- Generating done
-- Build files have been written to: /usr/local/src/mysql-5.5.33
说明编译环境ok
接下来可以 make && makeinstall 了,这个需要时间会长一点,看机器的性能了。
为了在安装过程中尽量少出现报错,最好先 yum安装一些必需的编译工具和库文件(安装的比较多,方便以后编译安装php、nginx等):
# yum install make autoconf automake curl curl-devel gcc gcc-c++ gtk+-devel zlib-devel openssl openssl-devel pcre-devel perl kernel-headers compat* cpp glibc libgomp libstdc++-devel keyutils-libs-devel libsepol-devel libselinux-devel krb5-devel libXpm* freetype freetype-devel freetype* fontconfig fontconfig-devel libpng* ncurses* libtool* libxml2-devel bison libaio-devel
- mysql-5.5.33编译安装
- 编译安装MySQL-5.5
- MySQL安装:编译安装5.5
- MySQL 5.5 源码编译安装
- 编译安装mysql-5.5.11
- 编译安装Mysql 5.5.x
- mysql 5.5 版本编译安装
- CentOS 5.5 编译安装MySQL 5.5
- Ubuntu下编译安装mysql 5.5.8
- ubuntu 10.10 源码编译安装mysql 5.5
- CentOS下编译安装mysql 5.5.10
- 源码编译mysql 5.5+ 安装过程全记录
- centos下 MySQL 5.5.14 编译安装
- centos源码编译安装mysql-5.5.13
- 源码编译安装 MySQL 5.5.13 实践
- ubuntu12.04编译安装mysql-5.5.13
- Redhat Linux 编译安装MySQL-5.5.27
- Centos 5.6编译安装mysql 5.5.11
- Angular2学习之懒加载(Lazy)路由(router)问题
- Gradle学习笔记(三)java项目编译
- 瀑布流封装
- 安卓学习笔记-3
- 读《聪明人用方格笔记本》有图了有内容了
- mysql-5.5.33编译安装
- 学习python的第二十四天-Web
- POJ 1477 Box of Bricks G++
- 一些题目
- Native.js学习(二):利用Native.js实现Android与HTML数据的交互
- Android之drawable state各个属性详解
- MySQL Where 条件语句介绍和运算符小结
- 解说:C++难在了哪里?
- HTML5-service worker进行缓存控制