CentOS6.7通过cmake编译安装mysql5.5.32

Cmake安装mysql-5.5.32

一、查看系统信息

[root@mysql ~]# cat /etc/redhat-release

CentOS release 6.7 (Final)

[root@mysql ~]# uname -r

2.6.32-573.el6.x86_64

二、安装环境准备

[root@mysql ~]# mkdir /tools

rz上传cmake、mysql源码包

[root@mysql ~]# ls /tools/

cmake-2.8.8.tar.gz  mysql-5.5.32.tar.gz

[root@mysql tools]# tar xf cmake-2.8.8.tar.gz

[root@mysql tools]# cd cmake-2.8.8

[root@mysql cmake-2.8.8]# ./configure

-- Searching 16 bit integer

-- Check size of unsigned short

-- Check size of unsigned short - done

-- Using unsigned short

-- Check if the system is big endian - little endian

-- Looking for wsyncup in /usr/lib64/libcurses.so

-- Looking for wsyncup in /usr/lib64/libcurses.so - found

-- Looking for elf.h

-- Looking for elf.h - found

-- Enable ninja generator.

-- Looking for a Fortran compiler

-- Looking for a Fortran compiler - /usr/bin/f95

-- Could NOT find Qt4 (missing:  QT_QMAKE_EXECUTABLE QT_MOC_EXECUTABLE QT_RCC_EXECUTABLE QT_UIC_EXECUTABLE QT_INCLUDE_DIR QT_LIBRARY_DIR QT_QTCORE_LIBRARY)

-- Configuring done

-- Generating done

-- Build files have been written to: /tools/cmake-2.8.8

---------------------------------------------

CMake has bootstrapped.  Now run gmake.

[root@mysql cmake-2.8.8]# gmake

[ 99%] Built target CMakeLibTests

Scanning dependencies of target runcompilecommands

[100%] Building CXX object Tests/CMakeLib/CMakeFiles/runcompilecommands.dir/run_compile_commands.cxx.o

Linking CXX executable runcompilecommands

[100%] Built target runcompilecommands

Scanning dependencies of target foo

[100%] Building CXX object Tests/FindPackageModeMakefileTest/CMakeFiles/foo.dir/foo.cpp.o

Linking CXX static library libfoo.a

[100%] Built target foo

 

[root@mysql cmake-2.8.8]# gmake install

-- Installing: /usr/local/doc/cmake-2.8/cmake-policies.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-properties.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-variables.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-modules.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-commands.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-compatcommands.txt

-- Installing: /usr/local/doc/cmake-2.8/ctest.txt

-- Installing: /usr/local/doc/cmake-2.8/ctest.docbook

-- Installing: /usr/local/doc/cmake-2.8/cpack.txt

-- Installing: /usr/local/doc/cmake-2.8/cpack.docbook

-- Installing: /usr/local/doc/cmake-2.8/ccmake.txt

-- Installing: /usr/local/doc/cmake-2.8/ccmake.docbook

-- Installing: /usr/local/share/aclocal/cmake.m4

[root@mysql cmake-2.8.8]# echo $?     

0    #####验证安装成功

Cmake安装成功,下一步安装mysql,首先安装mysql依赖包

[root@mysql cmake-2.8.8]# yum -y install ncurses-devel libaio-devel

[root@mysql ~]# useradd mysql -s /sbin/nologin -M

[root@mysql tools]# tar xf mysql-5.5.32.tar.gz

[root@mysql tools]# ls

cmake-2.8.8  cmake-2.8.8.tar.gz  mysql-5.5.32  mysql-5.5.32.tar.gz

[root@mysql tools]# cd mysql-5.5.32

[root@mysql mysql-5.5.32]# cmake . -DCMAKE_INSTALL_PREFIX=/app/mysql-5.5.32 \

> -DMYSQL_DATADIR=/app/mysql-5.5.32/data \

> -DMYSQL_UNIX_ADDR=/app/mysql-5.5.32/tmp/mysql.sock \

> -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \

> -DENABLED_LOCAL_INFILE=ON \

> -DWITH_INNOBASE_STORAGE_ENGINE=1 \

> -DWITH_FEDERATED_STORAGE_ENGINE=1 \

> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

> -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

> -DWITHOUT_PARTITION_STORAGE_ENGINE=1 \

> -DWITH_FAST_MUTEXES=1 \

> -DWITH_ZLIB=bundled \

> -DENABLED_LOCAL_INFILE=1 \

> -DWITH_READLINE=1 \

> -DWITH_EMBEDDED_SERVER=1 \

> -DWITH_DEBUG=0

 

-- Found Curses: /usr/lib64/libcurses.so 

-- Looking for tputs in /usr/lib64/libcurses.so

-- Looking for tputs in /usr/lib64/libcurses.so - found

-- Looking for include file libaio.h

-- Looking for include file libaio.h - found

-- Looking for io_queue_init in aio

-- Looking for io_queue_init in aio - found

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS - Success

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC - Success

-- Check size of pthread_t

-- Check size of pthread_t - done

-- Performing Test HAVE_PEERCRED

-- Performing Test HAVE_PEERCRED - Success

-- Configuring done

-- Generating done

-- Build files have been written to: /tools/mysql-5.5.32

[root@mysql mysql-5.5.32]#

[root@mysql mysql-5.5.32]# make && make install

 

-- Installing: /app/mysql-5.5.32/man/man1/mysql_find_rows.1

-- Installing: /app/mysql-5.5.32/man/man1/myisamchk.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql_install_db.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql.server.1

-- Installing: /app/mysql-5.5.32/man/man1/myisam_ftdump.1

-- Installing: /app/mysql-5.5.32/man/man1/mysqlslap.1

-- Installing: /app/mysql-5.5.32/man/man1/comp_err.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql_plugin.1

-- Installing: /app/mysql-5.5.32/man/man1/my_print_defaults.1

-- Installing: /app/mysql-5.5.32/man/man1/mysqladmin.1

-- Installing: /app/mysql-5.5.32/man/man1/mysqlbinlog.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql_fix_extensions.1

-- Installing: /app/mysql-5.5.32/man/man1/resolve_stack_dump.1

-- Installing: /app/mysql-5.5.32/man/man8/mysqld.8

-- Installing: /app/mysql-5.5.32/support-files/solaris/postinstall-solaris

 

安装成功后,创建软连接

 [root@mysql /]# ln -s /app/mysql-5.5.32/ /app/mysql 

[root@mysql /]# ll /app

total 4

lrwxrwxrwx  1 root root   18 Sep  8 14:53 mysql -> /app/mysql-5.5.32/

drwxr-xr-x 13 root root 4096 Sep  8 14:51 mysql-5.5.32

备份my.cnf

[root@mysql /]# ls /etc/my.cnf

/etc/my.cnf

[root@mysql /]# mv /etc/my.cnf /etc/my.cnf.bak

[root@mysql mysql-5.5.32]# \cp support-files/my-small.cnf /etc/my.cnf

[root@mysql mysql-5.5.32]# chown -R mysql.mysql /app/mysql/data

###授权mysql管理

[root@mysql mysql-5.5.32]#echo 'PAHT=/app/mysql/bin:$PATH' >> /etc/profile

[root@mysql mysql-5.5.32]#.  /etc/profile

###修改全局路径,并生效

下一步初始化数据库

[root@mysql mysql-5.5.32]# cd /app/mysql/scripts/

[root@mysql scripts]# ./mysql_install_db  --basedir=/app/mysql --datadir=/app/mysql/data/ --user=mysql

#####加./ 是为了避免初始化过程中系统执行默认路径的mysql_install_db

WARNING: The host 'mysql' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Installing MySQL system tables...

OK

Filling help tables...

OK

 

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

 

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

 

/app/mysql/bin/mysqladmin -u root password 'new-password'

/app/mysql/bin/mysqladmin -u root -h mysql password 'new-password'

 

Alternatively you can run:

/app/mysql/bin/mysql_secure_installation

 

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

 

See the manual for more instructions.

 

You can start the MySQL daemon with:

cd /app/mysql ; /app/mysql/bin/mysqld_safe &

 

You can test the MySQL daemon with mysql-test-run.pl

cd /app/mysql/mysql-test ; perl mysql-test-run.pl

 

Please report any problems with the /app/mysql/scripts/mysqlbug script!

出现两个ok代表初始化成功

[root@mysql scripts]# cd /tools/mysql-5.5.32

[root@mysql mysql-5.5.32]# \cp support-files/mysql.server /etc/init.d/mysqld

[root@mysql mysql-5.5.32]# chmod +x /etc/init.d/mysqld

[root@mysql mysql-5.5.32]# /etc/init.d/mysqld start

Starting MySQL...                                  

 

Mysql安装完毕,并启动成功

 

 

 

Cmake安装mysql-5.5.32

一、查看系统信息

[root@mysql ~]# cat /etc/redhat-release

CentOS release 6.7 (Final)

[root@mysql ~]# uname -r

2.6.32-573.el6.x86_64

二、安装环境准备

[root@mysql ~]# mkdir /tools

rz上传cmake、mysql源码包

[root@mysql ~]# ls /tools/

cmake-2.8.8.tar.gz  mysql-5.5.32.tar.gz

[root@mysql tools]# tar xf cmake-2.8.8.tar.gz

[root@mysql tools]# cd cmake-2.8.8

[root@mysql cmake-2.8.8]# ./configure

-- Searching 16 bit integer

-- Check size of unsigned short

-- Check size of unsigned short - done

-- Using unsigned short

-- Check if the system is big endian - little endian

-- Looking for wsyncup in /usr/lib64/libcurses.so

-- Looking for wsyncup in /usr/lib64/libcurses.so - found

-- Looking for elf.h

-- Looking for elf.h - found

-- Enable ninja generator.

-- Looking for a Fortran compiler

-- Looking for a Fortran compiler - /usr/bin/f95

-- Could NOT find Qt4 (missing:  QT_QMAKE_EXECUTABLE QT_MOC_EXECUTABLE QT_RCC_EXECUTABLE QT_UIC_EXECUTABLE QT_INCLUDE_DIR QT_LIBRARY_DIR QT_QTCORE_LIBRARY)

-- Configuring done

-- Generating done

-- Build files have been written to: /tools/cmake-2.8.8

---------------------------------------------

CMake has bootstrapped.  Now run gmake.

[root@mysql cmake-2.8.8]# gmake

[ 99%] Built target CMakeLibTests

Scanning dependencies of target runcompilecommands

[100%] Building CXX object Tests/CMakeLib/CMakeFiles/runcompilecommands.dir/run_compile_commands.cxx.o

Linking CXX executable runcompilecommands

[100%] Built target runcompilecommands

Scanning dependencies of target foo

[100%] Building CXX object Tests/FindPackageModeMakefileTest/CMakeFiles/foo.dir/foo.cpp.o

Linking CXX static library libfoo.a

[100%] Built target foo

 

[root@mysql cmake-2.8.8]# gmake install

-- Installing: /usr/local/doc/cmake-2.8/cmake-policies.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-properties.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-variables.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-modules.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-commands.txt

-- Installing: /usr/local/doc/cmake-2.8/cmake-compatcommands.txt

-- Installing: /usr/local/doc/cmake-2.8/ctest.txt

-- Installing: /usr/local/doc/cmake-2.8/ctest.docbook

-- Installing: /usr/local/doc/cmake-2.8/cpack.txt

-- Installing: /usr/local/doc/cmake-2.8/cpack.docbook

-- Installing: /usr/local/doc/cmake-2.8/ccmake.txt

-- Installing: /usr/local/doc/cmake-2.8/ccmake.docbook

-- Installing: /usr/local/share/aclocal/cmake.m4

[root@mysql cmake-2.8.8]# echo $?     

0    #####验证安装成功

Cmake安装成功,下一步安装mysql,首先安装mysql依赖包

[root@mysql cmake-2.8.8]# yum -y install ncurses-devel libaio-devel

[root@mysql ~]# useradd mysql -s /sbin/nologin -M

[root@mysql tools]# tar xf mysql-5.5.32.tar.gz

[root@mysql tools]# ls

cmake-2.8.8  cmake-2.8.8.tar.gz  mysql-5.5.32  mysql-5.5.32.tar.gz

[root@mysql tools]# cd mysql-5.5.32

[root@mysql mysql-5.5.32]# cmake . -DCMAKE_INSTALL_PREFIX=/app/mysql-5.5.32 \

> -DMYSQL_DATADIR=/app/mysql-5.5.32/data \

> -DMYSQL_UNIX_ADDR=/app/mysql-5.5.32/tmp/mysql.sock \

> -DEXTRA_CHARSETS=gbk,gb2312,utf8,ascii \

> -DENABLED_LOCAL_INFILE=ON \

> -DWITH_INNOBASE_STORAGE_ENGINE=1 \

> -DWITH_FEDERATED_STORAGE_ENGINE=1 \

> -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \

> -DWITHOUT_EXAMPLE_STORAGE_ENGINE=1 \

> -DWITHOUT_PARTITION_STORAGE_ENGINE=1 \

> -DWITH_FAST_MUTEXES=1 \

> -DWITH_ZLIB=bundled \

> -DENABLED_LOCAL_INFILE=1 \

> -DWITH_READLINE=1 \

> -DWITH_EMBEDDED_SERVER=1 \

> -DWITH_DEBUG=0

 

-- Found Curses: /usr/lib64/libcurses.so 

-- Looking for tputs in /usr/lib64/libcurses.so

-- Looking for tputs in /usr/lib64/libcurses.so - found

-- Looking for include file libaio.h

-- Looking for include file libaio.h - found

-- Looking for io_queue_init in aio

-- Looking for io_queue_init in aio - found

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS

-- Performing Test HAVE_IB_GCC_ATOMIC_BUILTINS - Success

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC

-- Performing Test HAVE_IB_ATOMIC_PTHREAD_T_GCC - Success

-- Check size of pthread_t

-- Check size of pthread_t - done

-- Performing Test HAVE_PEERCRED

-- Performing Test HAVE_PEERCRED - Success

-- Configuring done

-- Generating done

-- Build files have been written to: /tools/mysql-5.5.32

[root@mysql mysql-5.5.32]#

[root@mysql mysql-5.5.32]# make && make install

 

-- Installing: /app/mysql-5.5.32/man/man1/mysql_find_rows.1

-- Installing: /app/mysql-5.5.32/man/man1/myisamchk.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql_install_db.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql.server.1

-- Installing: /app/mysql-5.5.32/man/man1/myisam_ftdump.1

-- Installing: /app/mysql-5.5.32/man/man1/mysqlslap.1

-- Installing: /app/mysql-5.5.32/man/man1/comp_err.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql_plugin.1

-- Installing: /app/mysql-5.5.32/man/man1/my_print_defaults.1

-- Installing: /app/mysql-5.5.32/man/man1/mysqladmin.1

-- Installing: /app/mysql-5.5.32/man/man1/mysqlbinlog.1

-- Installing: /app/mysql-5.5.32/man/man1/mysql_fix_extensions.1

-- Installing: /app/mysql-5.5.32/man/man1/resolve_stack_dump.1

-- Installing: /app/mysql-5.5.32/man/man8/mysqld.8

-- Installing: /app/mysql-5.5.32/support-files/solaris/postinstall-solaris

 

安装成功后,创建软连接

 [root@mysql /]# ln -s /app/mysql-5.5.32/ /app/mysql 

[root@mysql /]# ll /app

total 4

lrwxrwxrwx  1 root root   18 Sep  8 14:53 mysql -> /app/mysql-5.5.32/

drwxr-xr-x 13 root root 4096 Sep  8 14:51 mysql-5.5.32

备份my.cnf

[root@mysql /]# ls /etc/my.cnf

/etc/my.cnf

[root@mysql /]# mv /etc/my.cnf /etc/my.cnf.bak

[root@mysql mysql-5.5.32]# \cp support-files/my-small.cnf /etc/my.cnf

[root@mysql mysql-5.5.32]# chown -R mysql.mysql /app/mysql/data

###授权mysql管理

[root@mysql mysql-5.5.32]#echo 'PAHT=/app/mysql/bin:$PATH' >> /etc/profile

[root@mysql mysql-5.5.32]#.  /etc/profile

###修改全局路径,并生效

下一步初始化数据库

[root@mysql mysql-5.5.32]# cd /app/mysql/scripts/

[root@mysql scripts]# ./mysql_install_db  --basedir=/app/mysql --datadir=/app/mysql/data/ --user=mysql

#####加./ 是为了避免初始化过程中系统执行默认路径的mysql_install_db

WARNING: The host 'mysql' could not be looked up with resolveip.

This probably means that your libc libraries are not 100 % compatible

with this binary MySQL version. The MySQL daemon, mysqld, should work

normally with the exception that host name resolving will not work.

This means that you should use IP addresses instead of hostnames

when specifying MySQL privileges !

Installing MySQL system tables...

OK

Filling help tables...

OK

 

To start mysqld at boot time you have to copy

support-files/mysql.server to the right place for your system

 

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !

To do so, start the server, then issue the following commands:

 

/app/mysql/bin/mysqladmin -u root password 'new-password'

/app/mysql/bin/mysqladmin -u root -h mysql password 'new-password'

 

Alternatively you can run:

/app/mysql/bin/mysql_secure_installation

 

which will also give you the option of removing the test

databases and anonymous user created by default.  This is

strongly recommended for production servers.

 

See the manual for more instructions.

 

You can start the MySQL daemon with:

cd /app/mysql ; /app/mysql/bin/mysqld_safe &

 

You can test the MySQL daemon with mysql-test-run.pl

cd /app/mysql/mysql-test ; perl mysql-test-run.pl

 

Please report any problems with the /app/mysql/scripts/mysqlbug script!

出现两个ok代表初始化成功

[root@mysql scripts]# cd /tools/mysql-5.5.32

[root@mysql mysql-5.5.32]# \cp support-files/mysql.server /etc/init.d/mysqld

[root@mysql mysql-5.5.32]# chmod +x /etc/init.d/mysqld

[root@mysql mysql-5.5.32]# /etc/init.d/mysqld start

Starting MySQL...                                  

 

Mysql安装完毕,并启动成功

 

转载于:https://www.cnblogs.com/joolearn/p/9610143.html

一、安装MySQL 1、安装cmake cd /usr/local/src tar zxvf cmake-2.8.11.2.tar.gz cd cmake-2.8.11.2 ./configure make make install 2、安装MySQL groupadd mysql #添加mysql组 useradd -g mysql mysql -s /bin/false #创建用户mysql并加入到mysql组,不允许mysql用户直接登录系统 mkdir -p /data/mysql #创建MySQL数据库存放目录 chown -R mysql:mysql /data/mysql #设置MySQL数据库存放目录权限 mkdir -p /usr/local/mysql #创建MySQL安装目录 cd /usr/local/src #进入软件包存放目录 tar zxvf mysql-5.6.19.tar.gz #解压 cd mysql-5.6.19 #进入目录 cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/data/mysql -DSYSCONFDIR=/etc #配置 make #编译 make install #安装 rm -rf /etc/my.cnf #删除系统默认的配置文件(如果默认没有就不用删除) cd /usr/local/mysql #进入MySQL安装目录 ./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql #生成mysql系统数据库 ln -s /usr/local/mysql/my.cnf /etc/my.cnf #添加到/etc目录的软连接 cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld #把Mysql加入系统启动 chmod 755 /etc/init.d/mysqld #增加执行权限 chkconfig mysqld on #加入开机启动 vi /etc/rc.d/init.d/mysqld #编辑 basedir=/usr/local/mysql #MySQL程序安装路径 datadir=/data/mysql #MySQl数据库存放目录 :wq! #保存退出 service mysqld start #启动 vi /etc/profile #把mysql服务加入系统环境变量:在最后添加下面这一行 export PATH=$PATH:/usr/local/mysql/bin :wq! #保存退出 source /etc/profile #使配置立刻生效 下面这两行把myslq的库文件链接到系统默认的位置,这样你在编译类似PHP等软件时可以不用指定mysql的库文件地址。 ln -s /usr/local/mysql/lib/mysql /usr/lib/mysql ln -s /usr/local/mysql/include/mysql /usr/include/mysql mkdir /var/lib/mysql #创建目录 ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock #添加软链接 mysql_secure_installation #设置Mysql密码,根据提示按Y 回车输入2次密码
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值