MySQL數(shù)據(jù)存儲(chǔ)默認(rèn)是不允許遠(yuǎn)程訪問(wèn)的,但可以通過(guò)配置來(lái)開(kāi)啟遠(yuǎn)程訪問(wèn)功能。以下是開(kāi)啟MySQL遠(yuǎn)程訪問(wèn)的步驟:
修改用戶權(quán)限:
mysql -u root -p
登錄MySQL服務(wù)器。CREATE USER 'your_username'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON *.* TO 'your_username'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
其中,將 your_username
和 your_password
替換為實(shí)際的用戶名和密碼。修改MySQL配置文件:
my.cnf
,通常位于 /etc/mysql/
目錄下。[mysqld]
部分,添加或修改以下行:bind-address = 0.0.0.0
這將允許MySQL監(jiān)聽(tīng)所有網(wǎng)絡(luò)接口。重啟MySQL服務(wù):
sudo systemctl restart mysql
通過(guò)以上步驟,您可以實(shí)現(xiàn)MySQL數(shù)據(jù)存儲(chǔ)的遠(yuǎn)程訪問(wèn)。但請(qǐng)確保在開(kāi)啟遠(yuǎn)程訪問(wèn)時(shí),考慮到數(shù)據(jù)的安全性,采取適當(dāng)?shù)陌踩胧?/p>