Mysql-5.5.32 cmake安装的步骤

2025-03-18 技术教程

这篇文章主要介绍“Mysql-5.5.32 cmake安装的步骤”，在日常操作中，相信很多人在Mysql-5.5.32 cmake安装的步骤问题上存在疑惑，小编查阅了各式资料，整理出简单好用的操作方法，希望对大家解答”Mysql-5.5.32 cmake安装的步骤”的疑惑有所帮助！接下来，请跟着小编一起来学习吧！

1.拷贝cmake-2.8.8.tar.gz和mysql-5.5.32.tar.gz至/opt文件夹下
2.切换到opt目录
[root@mysql~]# cd /opt
[root@mysqlopt]# ls
cmake-2.8.8.tar.gzmysql-5.5.32.tar.gz rh

3.解压cmake文件
[root@mysqlopt]# tar xf cmake-2.8.8.tar.gz
[root@mysqlopt]# cd cmake-2.8.8
[root@mysqlcmake-2.8.8]# ls
bootstrapCompileFlags.cmake doxygen.config
ChangeLog.manualconfigureExample
ChangeLog.txtCopyright.txt Modules
CMakeCPack.cmakeCTestConfig.cmake Readme.txt
CMakeCPackOptions.cmake.inCTestCustom.cmake.in Source
CMakeGraphVizOptions.cmakeCTestCustom.ctest.in Templates
CMakeLists.txtDartConfig.cmake Tests
CMakeLogo.gifDartLocal.conf.in Utilities
cmake_uninstall.cmake.inDocs

4.进行cmake的安装
[root@mysqlcmake-2.8.8]# ./configure
CMakehas bootstrapped. Now run gmake.

[root@mysqlcmake-2.8.8]# gmake
[root@mysqlcmake-2.8.8]# gmake install

5.添加mysql用户和组
[root@mysqlcmake-2.8.8]# groupadd mysql
[root@mysqlcmake-2.8.8]# useradd mysql -s /sbin/nologin -M -g mysql

6.yum安装ncurses-devel
[root@mysql/]# yum install ncurses-devel -y

7.解压mysql文件
[root@mysql/]# cd /opt
[root@mysqlopt]# tar xf mysql-5.5.32.tar.gz
[root@mysqlopt]# cd mysql-5.5.32
[root@mysqlmysql-5.5.32]# ls
BUILDCMakeLists.txt COPYINGincludelibmysqld mysysregex sql-commontests win
BUILD-CMAKEcmd-line-utils dbugINSTALL-SOURCE libservices packagingscripts storageunittest zlib
clientconfig.h.cmake DocsINSTALL-WIN-SOURCEmanplugin sqlstrings VERSION
cmakeconfigure.cmake extralibmysqlmysql-test README sql-benchsupport-files vio

8.安装之前编译mysql
cmake .-DCMAKE_INSTALL_PREFIX=/application/mysql-5.5.32 \
-DMYSQL_DATADIR=/application/mysql-5.5.32/data\
-DMYSQL_UNIX_ADDR=/application/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\
-DWITH_FAST_MUTEXES=1\
-DWITH_ZLIB=bundled\
-DENABLED_LOCAL_INFILE=1\
-DWITH_READLINE=1\
-DWITH_EMBEDDED_SERVER=1\
-DWITH_DEBUG=0

9.mysql安装

[root@mysql mysql-5.5.32]# make && makeinstall
[root@mysql mysql-5.5.32]# ln -s/application/mysql-5.5.32/ /application/mysql

如果make到63%左右出现错误：
make[2]: ***[storage/perfschema/unittest/pfs_connect_attr-t] Error 1
make[1]: ***[storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/all] Error 2
则：cmake去掉-DWITH_PARTITION_STORAGE_ENGINE=1参数重新编译

10.选择配置文件
[root@mysqlmysql-5.5.32]# cp support-files/my-small.cnf /etc/my.cnf
cp:overwrite `/etc/my.cnf'? y

11.查看是否有mysql/data目录
[root@mysql mysql-5.5.32]# ll/application/mysql/data/
total4
drwxr-xr-x.2 root root 4096 Aug 15 15:38 test

12.相关授权
[root@mysql mysql-5.5.32]# chown -R mysql.mysql/application/mysql/data/
[root@mysqlmysql-5.5.32]# chmod -R 1777 /tmp/

13.数据库初始化
[root@mysql mysql-5.5.32]# cd/application/mysql/scripts/
[root@mysqlscripts]# ls
mysql_install_db
[root@mysqlscripts]# cd /application/mysql/scripts/
[root@mysqlscripts]# ./mysql_install_db --basedir=/application/mysql/--datadir=/application/mysql/data/ --user=mysql
InstallingMySQL system tables...
OK
Fillinghelp tables...
OK

14.启动配置
[root@mysqlmysql]# cd /opt/mysql-5.5.32
[root@mysqlmysql-5.5.32]# cp support-files/mysql.server /etc/init.d/mysqld
[root@mysqlmysql-5.5.32]# chmod +x /etc/init.d/mysqld
[root@mysqlmysql-5.5.32]# /etc/init.d/mysqld start
StartingMySQL.. SUCCESS!
[root@mysqlmysql-5.5.32]# netstat -lntup|grep 3306
tcp0 00.0.0.0:33060.0.0.0:*LISTEN 28462/mysqld

15.配置环境变量
[root@mysql mysql-5.5.32]# echo 'exportPATH=/application/mysql/bin:$PATH'>>/etc/profile
[root@mysqlmysql-5.5.32]# tail -1 /etc/profile
exportPATH=/application/mysql/bin:$PATH
[root@mysqlmysql-5.5.32]# source /etc/profile
[root@mysqlmysql-5.5.32]# echo $PATH
/application/mysql/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin

16.登陆mysql，删除无用配置
[root@mysql mysql-5.5.32]# mysql
mysql>delete from mysql.user where user='';
mysql>delete from mysql.user where host='mysql';
mysql>delete from mysql.user where host='::1';
mysql>select user,host from mysql.user;
+------+-----------+
|user | host |
+------+-----------+
|root | 127.0.0.1 |
|root | localhost |
+------+-----------+
mysql>drop database test;

17.配置登陆密码
[root@mysql mysql-5.5.32]#/application/mysql//bin/mysqladmin -u root password 'cancer'

18.设置mysql开机启动
[root@mysql mysql-5.5.32]# chkconfig mysqld on
[root@mysqlmysql-5.5.32]# chkconfig --list mysqld
mysqld0:off 1:off 2:on3:on 4:on 5:on 6:off

19.查看系统语言
[root@mysql mysql-5.5.32]# cat /etc/sysconfig/i18n
LANG="en_US.UTF-8"
SYSFONT="latarcyrheb-sun16"