感謝AWS提供一年的免費云主機，嘗試了各種免費服務(wù)

推薦Docker方式安裝

https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html

1. 啟動MySQL實例
   docker run --name=mysql1 -v mysql:/var/lib/mysql -p 3306:3306 --restart on-failure -d mysql/mysql-server:8.0

2. 獲得管理員的密碼
   docker logs mysql1 2>&1 | grep GENERATED

3. 修改管理員的密碼
   docker exec -it mysql1 mysql -uroot -p
   mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

4. 備份數(shù)據(jù)庫
   mysqldump -uadmin -p projectdb > a.db

5. 恢復(fù)數(shù)據(jù)庫
   mysqladmin -uroot -p create projectdb
   mysql -uroot -p projectdb < /backup/mysqldump/db_name.db

6. 查看表
   show tables;

7. 創(chuàng)建并授權(quán)用戶
   create user 'admin'@'116.234.36.104' identified with mysql_native_password by 'ffdd123';
   create user 'admin'@'116.234.36.104' identified by 'ffdd123';
   grant all privileges on projectdb.* to 'admin'@'116.234.36.104';