預(yù)安裝：
yum install libaio
yum -y install perl perl-devel

mysql 安裝：

下載：[https://dev.mysql.com/downloads/mysql/5.6.html#downloads]

tar -xvzf mysql-5.6.38-linux-glibc2.12-i686.tar.gz
如果是64位的系統(tǒng)，選擇x86_64版本(mysql-5.6.41-linux-glibc2.12-x86_64.tar.gz)

mv mysql-5.6.38-linux-glibc2.12-i686/  /apps/mysql

mkdir mysql/data //在mysql下面創(chuàng)建data數(shù)據(jù)庫文件目錄

groupadd mysql //添加mysql用戶組

useradd mysql -g mysql //在mysql組下添加用戶mysql 或者 useradd -r -g mysql mysql

cd mysql //切換到mysql目錄

chown -R mysql . //給當(dāng)前目錄設(shè)置所屬用戶

chgrp -R mysql . //給當(dāng)前用戶設(shè)置用戶組

cd mysql/scripts //切換到mysql 的scripts目錄下

./mysql_install_db --user=mysql --basedir=/apps/mysql/ --datadir=/apps/mysql/data //初始化
cd support-files 
cp my-default.cnf /etc/my.cnf //復(fù)制mysql配置文件

cp -a ./support-files/mysql.server /etc/init.d/mysqld  //mysql的服務(wù)腳本放到系統(tǒng)服務(wù)中

#修改啟動腳本

vi /etc/init.d/mysqld

#修改項：

basedir = /apps/mysql  
datadir = /apps/mysql/data

修改/etc/my.cnf

修改以下幾項：

basedir = /apps/mysql  
datadir = /apps/mysql/data

port=7306

character-set-server = utf8

設(shè)置mysql命令：

ln -s /apps/mysql/bin/mysql /usr/bin/mysql

或者

export PATH=$PATH:/apps/mysql/bin

source /etc/profile

service mysqld start  //啟動mysql

chkconfig --add mysqld //設(shè)置開機自啟動

set password=password('123456'); // 設(shè)置密碼

mysql -u root -p //登錄

grant all privileges  on *.* to root@'%' identified by "123456";

//設(shè)置遠程權(quán)限

flush privileges;

select host,user,password from user; //查詢設(shè)置結(jié)果