官方文檔有寫如何安裝Mysql

$ apt update
$ apt install mysql-server mysql-client -y

$ service mysql start

mysql -uroot -p123456進入MySQL命令行

問題出在連接數(shù)據(jù)庫這一步，命令行能進去，但是數(shù)據(jù)庫插件和代碼都連不上

Access denied for?

大概率是權(quán)限和密碼的問題，進入

mysql> use mysql

mysql> select user,host, authentication_string from user;

注意%雖然是匹配全部但是不匹配localhost，所以說要解決在Cloud Studio中本地連接報錯需要給要用的賬號給localhost的權(quán)限，以root為例，如果報錯就drop一下

mysql> CREATE USER 'root'@'localhost'   IDENTIFIED BY '12345678';
ERROR 1396 (HY000): Operation CREATE USER failed for 'root'@'localhost'
mysql> drop user root@'localhost';
Query OK, 0 rows affected (0.02 sec)mysql> CREATE USER 'root'@'localhost'   IDENTIFIED BY '12345678';
Query OK, 0 rows affected (0.01 sec)mysql> grant all privileges on *.* to 'root'@'localhost';

在創(chuàng)建時如果報錯ERROR 1819 (HY000)，說明密碼強度不滿足要求，開發(fā)我們可以直接將密碼強度設(shè)置成0

mysql> CREATE USER 'root'@'localhost'   IDENTIFIED BY '12345678';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> set global validate_password.policy=0;
Query OK, 0 rows affected (0.00 sec)

最后連接上了通過數(shù)據(jù)庫插件連上了