遠程MySql無法調用解決方案 / 南方站長

遠程MySql無法調用解決方案

$host = "111.111.111.111"; // your MySQL host i.e. the server on which the database is, usually localhost
$user = "用戶名"; // your MySQL username
$pass = "密碼"; // your MySQL password
$db = "資料庫名"; // the database to which you're trying to connect to

如果無法遠程聯繫，須從資料庫所在伺服器進行以下設定。

mysql --user=root -p
mysql> use mysql
mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON *.* TO dbname@111.111.111.111 identified by '密碼';
mysql> FLUSH PRIVILEGES;


類型：mysql_article 遠程MySql無法調用解決方案 $host = "111.111.111.111"; // your MySQL host i.e. the server on which the database is, usually localhost $user = "用戶名"; // your MySQL username $pass = "密碼"; // your MySQL password $db = "資料庫名"; // the database to which you're trying to connect to 如果無法遠程聯繫，須從資料庫所在伺服器進行以下設定。 mysql --user=root -p mysql> use mysql mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON . TO dbname@111.111.111.111 identified by '密碼'; mysql> FLUSH PRIVILEGES;
104休閒信箱 2.3.0 © 104mm.com 2001 - 2019.	您尚未登錄