MY SQL開啟遠端連接

1.進入MySQL終端機頁面

​​​​預設路徑:
​​​​cd C:\Program Files\MySQL\MySQL Server 8.0\bin   

2.登入MySQL

​​​​mysql -u root -p
​​​​輸入密碼

3.選擇 mysql 資料庫

​​​​use mysql;

4.確認Host (預設為locahost)

​​​​select host,user,authentication_string,plugin from user;

5.建立使用者(版本0.8之後root不可直接動用GRANT修改，需要先創建帳號)

​​​​CREATE USER 'user name'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';

6.授權root使用者的所有許可權並設定遠端訪問

​​​​GRANT ALL ON *.* TO 'root'@'%';
​​​​FLUSH PRIVILEGES;

7.再次確認Host (host為%時就是成功)

​​​​select host,user,authentication_string,plugin from user;

8.虛擬機連接本機資料庫

​​​​確認本機VMware Network Adapter VMnet1 的ipv4
​​​​
​​​​cmd ipconfig

​​​​虛擬機終端機輸入 (xxx.xxx.xxx.xxx為VMnet1 的ipv4 ip)
​​​​
​​​​mysql -h xxx.xxx.xxx.xxx -P 3306 -u root -p;
​​​​輸入密碼

---

參考資料

https://www.gushiciku.cn/pl/gJa0/zh-tw

https://www.itread01.com/articles/1486995588.html

https://www.796t.com/article.php?id=159979

https://stackoverflow.com/questions/50177216/how-to-grant-all-privileges-to-root-user-in-mysql-8-0