linux下源码安装mysql5.5.52版本(包括gcc和cmake安装)

1.编辑器安装 （1）安装GCC编译器

Last login: Mon Sep 19 22:00:15 2016 from 10.105.2.214 [root@localhost ~]# rpm -qa|grepgcc libgcc-4.4.7-4.el6.x86_64

[root@localhost ~]# rpm -ivh ppl-0.10.2-11.el6.x86_64.rpm

warning: ppl-0.10.2-11.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:ppl

########################################### [100%]

[root@localhost ~]# rpm -ivh cloog-ppl-0.15.7-1.2.el6.x86_64.rpm

warning: cloog-ppl-0.15.7-1.2.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:cloog-ppl

########################################### [100%]

[root@localhost ~]# rpm -ivh mpfr-2.4.1-6.el6.x86_64.rpm

warning: mpfr-2.4.1-6.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:mpfr

########################################### [100%]

[root@localhost ~]# rpm -ivh cpp-4.4.7-4.el6.x86_64.rpm

warning: cpp-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:cpp

########################################### [100%]

[root@localhost ~]# rpm -ivh gcc-4.4.7-4.el6.x86_64.rpm

warning: gcc-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:gcc

########################################### [100%] （2）安装c++编译器

[root@localhost ~]# rpm -ivhlibstdc++-devel-4.4.7-4.el6.x86_64.rpm

warning: libstdc++-devel-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:libstdc++-devel

########################################### [100%]

[root@localhost ~]# rpm -ivhgcc-c++-4.4.7-4.el6.x86_64.rpm

warning: gcc-c++-4.4.7-4.el6.x86_64.rpm: Header V3 RSA/SHA1 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:gcc-c++

########################################### [100%] （3）安装cmake编译器 ①下载

下载cmake-3.6.2.tar.gz ②解压

上传是linux服务器并解压，本手册上传目录为/root cd /root

tar –xvf cmake-3.6.2.tar.gz ③安装cmake编译器

cd cmake-3.6.2目录 ./bootstrap gmake 2.mysql的安装

（1）mysql的下载解压

Mysql的下载地址为http://www.mysql.com/downloads/，根据实际去下载相应的版本，下载时选择source code（源码）

利用ftp将源码包上传至/usr/local目录，然后解压 tar –xvf mysql-5.5.52.tar.gz，同时执行mv mysql-5.5.52 mysql

（2）制作编译文件

cmake \\

-DCMAKE_INSTALL_PREFIX=/home/mysql \\ --根据实际安装地址编写 -DMYSQL_UNIX_ADDR=/tmp/mysql.sock \\ -DDEFAULT_CHARSET=utf8 \\

-DDEFAULT_COLLATION=utf8_general_ci \\ -DWITH_MYISAM_STORAGE_ENGINE=1 \\

-DWITH_INNOBASE_STORAGE_ENGINE=1 \\ -DWITH_ARCHIVE_STORAGE_ENGINE=1 \\ -DWITH_BLACKHOLE_STORAGE_ENGINE=1 \\ -DWITH_MEMORY_STORAGE_ENGINE=1 \\ -DWITH_READLINE=1 \\ -DENABLED_LOCAL_INFILE=1 \\

-DMYSQL_DATADIR=/home/mysql/data \\ --根据实际数据存储地址编写 -DMYSQL_USER=mysql \\ -DSYSCONFDIR=/etc\\ -DMYSQL_TCP_PORT=3306 \\ -DENABLE_DOWNLOADS=1 报错及处理：

remove CMakeCache.txt and rerun cmake.OnDebian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel. Call Stack (most recent call first):

cmake/readline.cmake:107 (FIND_CURSES)

cmake/readline.cmake:197 (MYSQL_USE_BUNDLED_EDITLINE) CMakeLists.txt:483 (MYSQL_CHECK_EDITLINE) -- Configuring incomplete, errors occurred!

See also \"/usr/local/mysql/CMakeFiles/CMakeOutput.log\". See also \"/usr/local/mysql/CMakeFiles/CMakeError.log\". 解决方法

[root@localhost ~]# rpm -ivh ncurses-devel-5.7-3.20090208.el6.x86_64.rpm warning:

ncurses-devel-5.7-3.20090208.el6.x86_64.rpm:

Header

V3

RSA/SHA256 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:ncurses-devel

########################################### [100%]

[root@localhost ~]# rpm -ivh bison-2.4.1-5.el6.x86_64.rpm

warning: bison-2.4.1-5.el6.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID c105b9de: NOKEY

Preparing...

########################################### [100%]

1:bison

########################################### [100%]

（3）make （4）make install （5）查看文件

（6）拷贝配置文件并编辑

文件拷贝后可编辑添加basedir（安装地址）和datadir（数据存储地址），根据cmake制定编译文件的路径填写，本手册没有编辑该文件。

[root@localhostmysql]# cp ./support-files/my-huge.cnf /etc/my.cnf [root@localhostmysql]# cat/etc/my.cnf

（7）初始化

使用mysql_secure_installation进行mysql数据库的初始化，如果报错找不到命令，可以使用下述命令

cd /usr/local/bin

ln -fs /home/mysql/bin/mysql_secure_installationmysql_secure_installation 然后运行./mysql_secure_installtion进行密码的修改等设置（注意5.5版本的mysql默认的处室密码为空）

（8）mysql的启动

如果报mysql命令无效使用下述命令做预处理 cd /usr/local/bin

ln -fs /home/mysql/bin/mysqlmysql 启动mysql Service mysql start

（9）mysql登录