數據庫安裝步驟:
sudo apt-get update
sudo apt install mysql-server mysql-client
sudo systemctl start mysql
sudo systemctl status mysql
(1)在命令行登錄 MySQL 數據庫,并使用 mysql 數據庫
(必須使用這個庫,因為 root 在這里面)
sudo mysql -u root -p
use mysql
(2)修改連接權限,執行:
update user set host='%' where user ='root';
(3)更改加密方式:
update user set plugin='mysql_native_password' where user ='root';
修改密碼數據庫密碼
use mysql
(4)
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
(5)授權遠程連接:
grant all on *.* to 'root'@'%';
(6)執行刷新權限:
flush privileges;
修改配置文件
sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf
將bind-address = 127.0.0.1改為0.0.0.0
sudo service mysql restart