php - 如何允许连接到 MariaDB？

Question

我是 Mac 用户，因此只能访问 Mac 终端。

我正在开发一个数据库驱动的网站，我正在尝试连接到数据库，但不断收到此错误，我不知道如何修复。

我的 php 代码是:

    $connection = mysqli_connect("MY IP ADDRESS HERE","root","","coursework")   

但是打开浏览器时我收到以下消息:

Warning: mysqli_connect(): (HY000/1130): Host '192.168.64.2' is not allowed to connect to this MariaDB server in /opt/lampp/htdocs/functions/db.php on line 2

有人知道我如何允许连接到该数据库吗？预先感谢您

Answer 1

可能是一种安全预防措施。您可以尝试添加新的管理员帐户:

mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
->     WITH GRANT OPTION;