编译安装MySQL

矫情吗；* 2022-10-02 11:50 125阅读 0赞

查看 linux 版本\[位数\]：

cat /proc/version

查看centOs版本：

cat /etc/redhat-release

下载地址：  
[https://www.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.57.tar.gz/from/http://cdn.mysql.com/][https_www.mysql.com_get_Downloads_MySQL-5.5_mysql-5.5.57.tar.gz_from_http_cdn.mysql.com]

【下载mysql】  
wget [https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.41.tar.gz][https_dev.mysql.com_get_Downloads_MySQL-5.6_mysql-5.6.41.tar.gz]

【解压mysql】  
tar -zxvf mysql-5.6.41.tar.gz

【安装mysql依赖】  
mkdir /usr/local/lnmp/mysql  
mkdir /usr/local/lnmp/mysql/data  
yum -y install gcc gcc-c++ gcc-g77 autoconf automake fiex\* ncurses-devel libmcrypt\* libtool-ltdl-devel\* make cmake bison\* zlib\*

【不安装依赖报错：Could NOT find Curses||Curses library not found. Please install appropriate package】  
– Could NOT find Curses (missing: CURSES\_LIBRARY CURSES\_INCLUDE\_PATH)  
CMake Error at cmake/readline.cmake:85 (MESSAGE):  
Curses library not found. Please install appropriate package,

remove CMakeCache.txt and rerun cmake.On Debian/Ubuntu, package name is libncurses5-dev, on Redhat and derivates it is ncurses-devel.

Call Stack (most recent call first):  
cmake/readline.cmake:128 (FIND\_CURSES)  
cmake/readline.cmake:218 (MYSQL\_USE\_BUNDLED\_EDITLINE)  
CMakeLists.txt:448 (MYSQL\_CHECK\_EDITLINE)

– Configuring incomplete, errors occurred!  
See also “/usr/local/src/mysql-5.6.41/CMakeFiles/CMakeOutput.log”.  
See also “/usr/local/src/mysql-5.6.41/CMakeFiles/CMakeError.log”.

解决方案：  
1、删除源码包下 CMakeCache.txt 文件  
2、安装 ncurses 依赖： yum -y install ncurses-devel  
3、重新编译

【重新编译】  
rm -rf CMakeCache.txt

【编译安装mysql】  
cmake . -DCMAKE\_INSTALL\_PREFIX=/usr/local/mysql -DMYSQL\_DATADIR=/usr/local/mysql/data -DDEFAULT\_CHARSET=utf8 -DDEFAULT\_COLLATION=utf8\_general\_ci -DEXTRA\_CHARSETS=all -DENABLED\_LOCAL\_INFILE=1 -DENABLE\_DOWNLOADS=1  
make && make install

【创建用户】  
创建mysql用户及用户组  
groupadd mysql  
useradd -r -g mysql mysql  
mysql目录改为mysql读写权限：chown -R mysql.mysql /usr/local/mysql

【初始化数据】  
cd /usr/local/mysql  
./scripts/mysql\_install\_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

【添加环境变量】  
vi /etc/profile  
export PATH=/usr/local/mysql/bin:/usr/local/mysql/lib:$PATH  
source /etc/profile

【开启mysql】  
\#将mysql服务,添加到系统服务里面，并设置开启自启动  
cd /usr/local/mysql/support-files  
\#注册服务  
cp mysql.server /etc/rc.d/init.d/mysql  
cp my-default.cnf /etc/my.cnf  
\#让chkconfig管理 mysql服务  
chkconfig --add mysql  
\#开机启动  
chkconfig mysql on  
\#启动 mysql  
service mysql start  
\#修改密码  
/usr/local/mysql/bin/mysqladmin -u root password ‘123456’  
\#登录 mysql  
1、执行 mysql -u root -p  
2、输入密码 123456

参考网址：  
[http://www.linuxidc.com/Linux/2014-10/108044.htm][http_www.linuxidc.com_Linux_2014-10_108044.htm]  
[http://blog.rekfan.com/articles/186.html][http_blog.rekfan.com_articles_186.html]

[https_www.mysql.com_get_Downloads_MySQL-5.5_mysql-5.5.57.tar.gz_from_http_cdn.mysql.com]: https://www.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.57.tar.gz/from/http://cdn.mysql.com/
[https_dev.mysql.com_get_Downloads_MySQL-5.6_mysql-5.6.41.tar.gz]: https://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.41.tar.gz
[http_www.linuxidc.com_Linux_2014-10_108044.htm]: http://www.linuxidc.com/Linux/2014-10/108044.htm
[http_blog.rekfan.com_articles_186.html]: http://blog.rekfan.com/articles/186.html