邮差中的Php连接文件错误

Question

This is the connection.php file being used to connect to a phpMyAdmin database

<?php
    require_once 'config.php';

    class DB_Connection {

        private $connect;
        function __construct() {
            $this->connect = mysqli_connect(hostname, user, password, db_name)
            or die("Could not connect to db");

        }

        public function getConnection()
        {
            return $this->connect;
        }
    }
    ?>

But i seem to get this error when i try to post with Postman

<br />
<b>Warning</b>:  mysqli_connect(): (HY000/1130): Host '192.168.98.178' is not allowed to connect to this MariaDB server in
<b>/Applications/XAMPP/xamppfiles/htdocs/connection.php</b> on line
<b>8</b>
<br />
Could not connect to db

Answer 1

Knowing your setup is key here. You're using XAMPP's MySQL server, right? I think you are based on your previous question. What are you passing in for hostname, user, password, and db_name?

XAMPP's Mysql server has a root user and an empty password by default. So having user = 'root' and password = '' should work to get you in. Not good for production, but it'll help you get set up in the meantime.

Past that, learning about MySQL and how to manage it is a good idea. http://www.mysqltutorial.org/