ubuntu linux 从源码安装编译mysql 5.6.x

自己编译安装步骤如下
本人机器环境:Ubuntu 14.04 LTS 64位
默认省略ubuntu的sudo,大家可先sudo -s后执行命令或者自行命令前添加sudo
1.安装前的准备 配置编译环境
apt-get install -y cmake build-essential libreadline6-dev libncurses5-dev
2.下载最新版本mysql
wget http://cdn.mysql.com/Downloads/MySQL-5.6/mysql-5.6.10.tar.gz
3.配置mysql帐号
groupadd mysql
useradd -r -g mysql mysql
4.开始编译安装
tar xvfz mysql-5.6.10.tar.gz
cd mysql-5.6*
开始编译
cmake \
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-5.6.10 \
-DWITH_INNOBASE_STORAGE_ENGINE=1\
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DMYSQL_UNIX_ADDR=/tmp/mysql.sock \
-DSYSCONFDIR=/etc \
.
make
make install
ln -s /usr/local/mysql-5.6.10 /usr/local/mysql
5.编译安装完毕,开始初始化设置msyql数据库
cd /usr/local/mysql

添加mysql配置文件到系统
cp ./support-files/my-default.cnf /etc/my.cnf
echo "character-set-server = utf8" >> /etc/my.cnf
echo "collation-server = utf8_general_ci" >> /etc/my.cnf
echo "character-set-client-handshake = false" >> /etc/my.cnf

数据库目录权限修改
chown -R root .
chgrp -R mysql .
chown -R mysql data

初始化mysql用户数据库
./scripts/mysql_install_db --user=mysql

启动运行mysql
bin/mysqld_safe --user=mysql &
设置root用户的mysql客户端登录密码: bin/mysqladmin -u root password 'new-password'

开启自动启动mysql
cp support-files/mysql.server /etc/init.d/mysql.server
ln -s /etc/init.d/mysql.server /etc/rc2.d/S90mysql

设置mysql的bin目录中执行文件环境到系统中
echo "export PATH=/usr/local/mysql/bin:$PATH" >> /etc/profile

参考原文 https://coderwall.com/p/e23_ca

[后记]
当然如今有了mysql的替代品,推荐来MariaDB,从此抛弃oracle的mysql...

ubuntu 14.04 LTS 的msyql默认就是最新版本你也可以直接apt-get直接来安装
apt-cache search msyql-server
mysql-server-5.5 - MySQL database server binaries and system database setup
mysql-server-5.6 - MySQL database server binaries and system database setup
两个mysql版本~~ 一般安装选择最新的5.6版