1、在用戶目錄
? ? cd ~
2、下載MySQL安裝包
????wget https://repo.mysql.com//mysql80-community-release-el7-1.noarch.rpm
3芦疏、安裝rpm包
? ??rpm -ivh mysql80-community-release-el7-1.noarch.rpm
4、修改MySQL的repo源论巍,保證MySQL正常啟用(最新版的不需要修改)
? ??cd /etc/yum.repos.d/
? ? vim mysql-community.repo
? ? 改成下圖這樣
5渠旁、安裝MySQL server
? ??yum -y install mysql-server
6、修改 MySQL 的訪問權限
? ??chown -R root:root /var/lib/mysql
7镰禾、啟動MySQL
? ??systemctl start mysqld
8皿曲、查看MySQL給的默認密碼
?????cat /var/log/mysqld.log | grep password
9、登錄進去修改密碼
? ? 若想修改成簡單的密碼
????執(zhí)行:set global validate_password.policy=0;
????執(zhí)行:set global validate_password.length=1;
????執(zhí)行:ALTER USER 'root'@'localhost' IDENTIFIED BY '123456' PASSWORD EXPIRE NEVER;??
? ? ?設置新密碼及其加密規(guī)則:
????????ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
????此時吴侦,密碼設置完成屋休,密碼為123456
?10、開啟遠程連接
????????執(zhí)行:mysql -uroot –p123456進入MySQL
????????執(zhí)行:show databases;
????????執(zhí)行:use mysql;
????????執(zhí)行:select Host,User from user \G;
????????執(zhí)行:update user set Host = '%' where Host = 'localhost' and User = 'root';
????????執(zhí)行:select Host,User from user \G;? 查看是否更改
?????????執(zhí)行:flush privileges; 或者重啟mysql服務器
????????此時备韧,Navicat就可以遠程訪問數據庫了