前提準備：
MySQL下載https://dev.mysql.com/downloads/mysql/
當前安裝版本5.7
1.檢查是否安裝mysql：rpm -aq | grep mysql?
如果有輸出則先停止服務(wù)：?service mysqld start
批量刪除包?rpm -e XXX --nodeps
2.檢查mariadb：rpm -qa|grep mariadb
如果有輸出則刪除相關(guān)包rpm -e XXX --nodeps
3.刪除目錄：find / -name mysql
如果有根據(jù)目錄進行刪除：?rm -rf XXX
4.刪除 my.conf：rm -rf?my.conf
5.創(chuàng)建mysql目錄：mkdir? /usr/local/mysql
6.復(fù)制安裝包到該目錄下：cp ~/download/mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar /usr/local/mysql/
7.解壓縮安裝包：
cd /usr/local/mysql/
tar -xf mysql-5.7.12-1.el6.x86_64.rpm-bundle.tar
安裝libaio
yum?install?libaio
8.按順序執(zhí)行如下安裝：
rpm -ivh mysql-community-common-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-client-5.7.12-1.el6.x86_64.rpm
rpm -ivh imysql-community-server-5.7.12-1.el6.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.12-1.el6.x86_64.rpm
9.啟動mysql：systemctl start mysqld.service?
10.查看啟動狀態(tài)：systemctl status mysqld.service
11.啟動之后密碼就創(chuàng)建好了偎箫，通過：sudo grep 'temporary password' /var/log/mysqld.log?查看密碼
12.登錄mysql：mysql -uroot -p
13.修改密碼：
set password for 'username?'@'host?'='password?';?
(username --用戶名/?host?-- 主機地址/?password?--密碼)
14.創(chuàng)建用戶：
create user 'username'@'host' identified by 'password';
(username --用戶名/ host -- 主機地址/ password --密碼)
15.授權(quán)用戶：
grant privileges on databasename.tablename TO 'username'@'host';
(databasename --數(shù)據(jù)庫名稱/?tablename --表名稱/?*代表全部/ username -- 用戶名)
16.設(shè)置某用戶允許外網(wǎng)訪問：
(要允許用戶帳戶從主機的任何子域連接到數(shù)據(jù)庫服務(wù)器，使用百分比通配符%)
use mysql皆串；
select user,host from user;
update user set host='%' where user='root';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
flush privileges;
