CentOS 6.6/Fedora 21 源码编译安装 mysql 5.6.22

最新推荐文章于 2024-09-22 10:41:31 发布

colben

最新推荐文章于 2024-09-22 10:41:31 发布

阅读量681

点赞数

本文链接：https://blog.csdn.net/colben/article/details/42126189

版权

环境：fedora 21 workstation gnome

1、安装依赖和工具

# yum install gcc gcc-c++ make cmake ncurses-devel

2、创建mysql安装目录

# mkdir /opt/mysql/app/etc -p
# mkdir /opt/mysql/db

3、下载源码包(gz包大约30M)，解压，进入源码顶级目录下，cmake编译

# cmake \
-DCMAKE_INSTALL_PREFIX=/opt/mysql/app \
-DMYSQL_DATADIR=/opt/mysql/db \
-DSYSCONFDIR=/opt/mysql/app/etc \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DMYSQL_TCP_PORT=3306 \
-DENABLED_LOCAL_INFILE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DEXTRA_CHARSETS=all \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci
# make
# make install

4、创建mysql用户及组，配置权限

# groupadd mysql
# useradd -g mysql -s /usr/sbin/nologin mysql
# chown mysql.mysql /opt/mysql -R

5、初始化配置

# /opt/mysql/app/scripts/mysql_install_db --basedir=/opt/mysql/app --datadir=/opt/mysql/db --user=mysql

6、启动mysql服务

# service iptables stop

# /opt/mysql/app/support_files/mysql.server start

7、进入mysql

# /opt/mysql/app/bin/mysql -uroot

mysql>drop user ''@localhost;
mysql>use mysql;
mysql>update user set password=PASSWORD('123456') where user='root';
mysql>flush privileges;
mysql>exit;