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

来源：互联网发布：淘宝借贷逾期编辑：程序博客网时间：2024/04/20 09:07

环境：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;

0 0