1示血、找源
# 下載mysql源安裝包shell> wget http://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm# 安裝mysql源shell> yum localinstall mysql57-community-release-el7-8.noarch.rpm
檢查mysql源是否安裝成功
shell> yum repolist enabled | grep "mysql.*-community.*"
2储耐、安裝MySQL
shell> yum install mysql-community-server
3柏肪、啟動(dòng)MySQL服務(wù)
shell> systemctl start mysqld
查看MySQL的啟動(dòng)狀態(tài)
shell> systemctl status mysqld
4惭每、開機(jī)啟動(dòng)
shell> systemctl enable mysqldshell> systemctl daemon-reload
5嚷往、修改root本地登錄密碼
mysql安裝完成之后刁绒，在/var/log/mysqld.log文件中給root生成了一個(gè)默認(rèn)密碼客年。通過下面的方式找到root默認(rèn)密碼，然后登錄mysql進(jìn)行修改：
shell> grep 'temporary password' /var/log/mysqld.log
shell> mysql -uroot -pmysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';
或者
mysql> set password for 'root'@'localhost'=password('MyNewPass4!');
6娩脾、添加遠(yuǎn)程登錄用戶
默認(rèn)只允許root帳戶在本地登錄赵誓，如果要在其它機(jī)器上連接mysql，必須修改root允許遠(yuǎn)程連接柿赊，或者添加一個(gè)允許遠(yuǎn)程連接的帳戶俩功，為了安全起見，我添加一個(gè)新的帳戶：
mysql> GRANT ALL PRIVILEGES ON *.* TO 'yangxin'@'%' IDENTIFIED BY 'Yangxin0917!' WITH GRANT OPTION;
7碰声、配置默認(rèn)編碼為utf8
修改/etc/my.cnf配置文件诡蜓，在[mysqld]下添加編碼配置，如下所示：
[mysqld]character_set_server=utf8
? ? ? ? ? ? ? ? init_connect='SET NAMES utf8'? ? ? ? ? ? ?
8胰挑、其他主機(jī)不能訪問蔓罚，解決如下
java連接linux中mysql出現(xiàn)：Access denied for user 'root'@'192.168.91.1' (using password: YES)? ? ? ? ? ? ? ?
mysql中執(zhí)行：grant all privileges on *.* to root@'%' identified by 'root';
