编译安装MySQL

最新推荐文章于 2022-06-15 19:19:53 发布

xianhenyuan

最新推荐文章于 2022-06-15 19:19:53 发布

阅读量114

点赞数

分类专栏： MySQL 文章标签：编译安装MySQL

MySQL 专栏收录该内容

12 篇文章 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/

【下载mysql】
wget 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://blog.rekfan.com/articles/186.html