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