centos 7.5安装mysql_Centos7.5编译安装mysql5.5

当然环境Centos7.5，mysql版本5.5.59，同样也适用于Centos6.9系统

1、安装依赖

yum install gcc-c++ ncurses-devel

1

yuminstallgcc-c++ncurses-devel

2、为mysql创建用户

useradd -s /bin/false -M mysql

1

useradd-s/bin/false-Mmysql

3、下载mysql5.5源码包

cd /usr/local/src/

wget https://cdn.mysql.com//Downloads/MySQL-5.5/mysql-5.5.59.tar.gz

tar zxf mysql-5.5.59.tar.gz

cd mysql-5.5.59

1

2

3

4

cd/usr/local/src/

wgethttps://cdn.mysql.com//Downloads/MySQL-5.5/mysql-5.5.59.tar.gz

tarzxfmysql-5.5.59.tar.gz

cdmysql-5.5.59

4、安装cmake

mysql从5.5版本开始，不再使用./configure编译，而是使用cmake编译器，具体的cmake编译参数可以参考mysql官网文档

http://dev.mysql.com/doc/refman/5.5/en/source-configuration-options.html

yum install cmake

1

yuminstallcmake

5、编译安装

cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_PARTITION_STORAGE_ENGINE=1 -DWITH_FEDERATED_STORAGE_ENGINE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8mb4 -DDEFAULT_COLLATION=utf8mb4_general_ci -DWITH_READLINE=1 -DWITH_EMBEDDED_SERVER=1 -DENABLED_LOCAL_INFILE=1

make

make install

1

2

3

cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DSYSCONFDIR=/etc-DMYSQL_TCP_PORT=3306-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DWITH_FEDERATED_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8mb4-DDEFAULT_COLLATION=utf8mb4_general_ci-DWITH_READLINE=1-DWITH_EMBEDDED_SERVER=1-DENABLED_LOCAL_INFILE=1

make

makeinstall

参数解释：

-DCMAKE_INSTALL_PREFIX=/usr/local/mysql 设置mysql安装目录

-DSYSCONFDIR=/etc 指定配置文件目录

-DMYSQL_TCP_PORT=3306 指定端口3306，默认就是3306

-DWITH_MYISAM_STORAGE_ENGINE=1 安装myisam存储引擎

-DWITH_INNOBASE_STORAGE_ENGINE=1 安装innodb存储引擎

-DWITH_PARTITION_STORAGE_ENGINE=1 安装数据库分区

-DWITH_FEDERATED_STORAGE_ENGINE=1 安装federated存储引擎

-DEXTRA_CHARSETS=all 安装所有扩展字符集

-DDEFAULT_CHARSET=utf8mb4 使用utf8mb4字符集

-DDEFAULT_COLLATION=utf8mb4_general_ci 校验字符集

-DWITH_READLINE=1 启用readline库支持

-DWITH_EMBEDDED_SERVER=1 编译嵌入式服务器支持

-DENABLED_LOCAL_INFILE=1 允许从本地导入数据

6、修改mysql安装目录属主属组

chown -R mysql:mysql /usr/local/mysql/

1

chown-Rmysql:mysql/usr/local/mysql/

7、初始化数据库

/usr/local/mysql/scripts/mysql_install_db --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql

1

/usr/local/mysql/scripts/mysql_install_db--defaults-file=/etc/my.cnf--basedir=/usr/local/mysql--datadir=/usr/local/mysql/var--user=mysql

8、配置my.cnf

mv /etc/my.cnf /etc/my.cnf.bak && wget -O /etc/my.cnf http://down.whsir.com/downloads/my5.5.cnf

mkdir /var/lib/mysql

chown -R mysql.mysql /var/lib/mysql

1

2

3

mv/etc/my.cnf/etc/my.cnf.bak&&wget-O/etc/my.cnfhttp://down.whsir.com/downloads/my5.5.cnf

mkdir/var/lib/mysql

chown-Rmysql.mysql/var/lib/mysql

9、复制mysql服务启动配置文件

cp support-files/mysql.server /etc/init.d/mysql

chmod +x /etc/init.d/mysql

1

2

cpsupport-files/mysql.server/etc/init.d/mysql

chmod+x/etc/init.d/mysql

10、设置软连接或自行添加环境变量

ln -sv /usr/local/mysql/bin/mysql /usr/local/sbin/mysql

1

ln-sv/usr/local/mysql/bin/mysql/usr/local/sbin/mysql

11、启动mysql服务

/etc/init.d/mysql start

1

/etc/init.d/mysqlstart

默认密码为空

12、修改密码

进入mysql

mysql -uroot -p

mysql> set password = password('whsir');

1

2

mysql-uroot-p

mysql>setpassword=password('whsir');

至此mysql5.5编译安装完成，相关配置参数请自行根据使用情况进行调整

附：设置环境变量方法

vi /etc/profile

export PATH=$PATH:/usr/local/mysql/bin/

source /etc/profile

~微信打赏~

赏

分享到：