1. 安装准备软件 cmake
yum install cmake -y
2. 添加mysql 用户组与用户
groupadd mysql
useradd -r -g mysql mysql
mkdir -p /usr/local/mysql
mkdir -p /data/mysqldb
3. 下mysql
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.34.tar.gz
4.解压缩,并进入文件夹
tar -zxvf mysql-5.6.34.tar.gz
cd mysql-5.6.34
5.cmake ,这段有点长
cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_ARCHIVE_SOTRAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DMYSQL_DATADIR=/data1/mysqldb -DMYSQL_TCP_PORT=3306 -DENABLE_DOWNLOADS=1
6. 四线程编译
make -j4
7. 安装
make install
8.指定文 件夹权限
cd /usr/local/mysql
chown -R mysql:mysql ./
cd /data/mysqldb
chown -R mysql:mysql ./
9 切换到 /usr/local/mysql
cd /usr/local/mysql
10 初始化数据库
scripts/mysql_install_db --user=mysql --datadir=/data/mysqldb
11. 复制配置文件到 /etc
cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf
12.编辑my.cnf, port
gedit /etc/my.cnf
13. 编辑mysqld服务,编辑变量,
cp support-files/mysql.server /etc/init.d/mysqld
gedit /etc/profile
在最底下加上PATH = /usr/local/mysql
14.启动mysqld服务
systemctl start mysqld
15.检查设置
chkconfig --level 35 mysqld on
netstat -tulnp | grep 3306
16. 修改Mysql root 密码
mysql -uroot
mysql > use mysql;
mysql > GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
mysql > UPDATE user Set Password = password('123456789') WHERE User='root';
mysql > select Host, User,Password from user where User='root';
mysql > flush privileges;
mysql > exit;
17.重启mysqld 并测试
systemctl restart mysqld
mysql -uroot -p
总结:首先选择不同版本的的MYSQL,有不同的效果,6.以后的MySQL启动关机都要1分30秒加载,好烦的,所以 才会选择旧版本。