1. 下載Mysql安裝包，解壓到指定的目錄
新建用戶 ：useradd -r -g mysql mysql
在線解壓的目錄下新建 目錄 data、etc、logs以及文件my.cnf,內(nèi)容如下
[mysqld]
# skip-grant-tables //忘記密碼的操作
datadir=/usr/local/tools/mysql/mysql-master-3307/data?//自己的目錄
basedir=/usr/local/tools/mysql/mysql-master-3307?//自己的目錄
socket=/usr/local/tools/mysql/mysql-master-3307/etc/mysql.sock? //自己的目錄
log-bin=//usr/local/tools/mysql/mysql-master-3307/logs/mysql-bin?//自己的目錄
port=3307
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Recommended in standard MySQL setup
# sql_mode=
# character set
character-set-server=utf8mb4
collation-server=utf8mb4_unicode_ci
# slow query
slow_query_log=on
slow_query_log_file=/usr/local/tools/mysql/mysql-master-3307/logs/slow-query.log??//自己的目錄
[client]
port=3307
socket=/usr/local/tools/mysql/mysql-master-3307/etc/mysql.sock? //最好有
[mysqld_safe]
log-error=/usr/local/tools/mysql/mysql-master-3307/logs/error.log? //自己的目錄，新建error.log 文件
pid-file=/usr/local/tools/mysql/mysql-master-3307/etc/mysqld.pid??//自己的目錄
2.初始化安裝
./mysqld --defaults-file=/usr/local/tools/mysql/mysql-master-3307/my.cnf --initialize --user=mysql --basedir=/usr/local/tools/mysql/mysql-master-3307 --datadir=/usr/local/tools/mysql/mysql-master-3307/data
！?。∵@個(gè)時(shí)候密碼會(huì)打印，記住密碼,這個(gè)過程有些小長(zhǎng)，不可自己關(guān)閉。
3.啟動(dòng)mysql實(shí)例
./mysqld_safe --defaults-file=/usr/local/tools/mysql/mysql-master-3307/my.cnf &? ?//自己的my.cnf 的位置
4.登錄mysql
可能會(huì)出現(xiàn)：error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
處理：sudo ln -s /usr/lib64/libtinfo.so.6.1 /usr/lib64/libtinfo.so.5
登錄命令：
./mysql -uroot -p -S /usr/local/tools/mysql/mysql-master-3307/etc/mysql.sock? //多個(gè)必須使用這個(gè)，自己的mysql.sock的位置
輸入初始化時(shí)候的密碼
5.進(jìn)行新建用戶操作
切換數(shù)據(jù)庫：use mysql;
會(huì)提示修改密碼，修改密碼：ALTER USER 'root'@'localhost' IDENTIFIED BY '自己的密碼';
查詢用戶：select user,host from user;
創(chuàng)建遠(yuǎn)程連接用戶：create user root@'%' identified by '自己的密碼';
遠(yuǎn)程連接用戶授權(quán)：grant all privileges on *.* to root@'%' with grant option;
刷新權(quán)限：flush privileges;
修改遠(yuǎn)程連接用戶的加密規(guī)則：ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '自己的密碼';
建議再次刷新權(quán)限：flush privileges;
6.開機(jī)啟動(dòng)
編輯：vim? /etc/rc.d/rc.local
添加內(nèi)容如下：
# mysql 開機(jī)自啟動(dòng)
/usr/local/tools/mysql/mysql-master-3307/bin/mysqld_safe --defaults-file=/usr/local/tools/mysql/mysql-master-3307/my.cnf & //自己的文件位置
/usr/local/tools/mysql/mysql-slave-3308/bin/mysqld_safe --defaults-file=/usr/local/tools/mysql/mysql-slave-3308/my.cnf &
//自己的文件位置
添加文件的執(zhí)行命令：chmod +x /etc/rc.d/rc.local
