centos7安装mysql5.5

最新推荐文章于 2021-02-18 09:38:44 发布

Menardღ

最新推荐文章于 2021-02-18 09:38:44 发布

阅读量441

点赞数 3

分类专栏： Linux 数据库文章标签： centos7 安装mysql5.5

本文链接：https://blog.csdn.net/qq_41980563/article/details/99679244

版权

Linux 同时被 3 个专栏收录

38 篇文章 1 订阅

订阅专栏

数据库

12 篇文章 0 订阅

订阅专栏

mysql

7 篇文章 0 订阅

订阅专栏

官网下载mysql5.5，下载地址https://dev.mysql.com/downloads/mysql/5.5.html#downloads ，选择源码下载包下载。
安装编译器和所需库
yum -y install make gcc gcc-c++ cmake ncurses ncurses-devel bison openssl openssl-devel bison-devel libaio-devel
解压缩并进入解压后的目录
ar zxvf mysql-5.5.13.tar.gz
cd mysql-5.5.13
创建mysql文件夹
mkdir -p /wdata/server/mysql
mkdir -p /wdata/db
编译安装

cmake . -DCMAKE_INSTALL_PREFIX=/wdata/server/mysql -DMYSQL_DATADIR=/wdata/db  -DSYSCONFDIR=/etc

出现报错
在这里插入图片描述
Could NOT find Curses (missing: CURSES_LIBRARY CURSES_INCLUDE_PATH)
CMake Error at cmake/readline.cmake:83 (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):

删除文件，再安装
rm CMakeCache.txt
yum -y install ncurses-devel
报错
– Library mysqlclient depends on OSLIBS -lpthread;m;dl
– CMAKE_BUILD_TYPE: RelWithDebInfo
– COMPILE_DEFINITIONS: HAVE_CONFIG_H
– CMAKE_C_FLAGS: -Wall -Wextra -Wformat-security -Wvla -Wwrite-strings -Wdeclaration-after-statement
– CMAKE_CXX_FLAGS: -fno-implicit-templates -fno-exceptions -fno-rtti -Wall -Wextra -Wformat-security -Wvla -Woverloaded-virtual -Wno-unused-parameter
安装bison-devel、libaio-devel后再重新编译，然后执行make & make install
拷贝或编辑配置文件到/etc/my.cnf
安装数据库
chown -R mysql. /wdata/server/mysql
chown -R mysql. /wdata/db
scripts/mysql_install_db --user=mysql --basedir=/wdata/server/mysql/ --datadir=/wdata/db/
chown -R mysql. /wdata/server/mysql
chown -R mysql. /wdata/db
启动数据库
bin/mysqld_safe --user=mysql &
修改root密码
bin/mysqladmin -u root password ‘new-password’
设置开机自启
cp support-files/mysql.server /etc/init.d/mysqld
chmod +x /etc/init.d/mysqld
chkconfig --add mysqld
chkconfig mysqld on
service mysqld start