Error when trying to connect to MySQL (Error in your code!!!)

[PluginBOXone]

DO NOT REMOVE THIS

Please make sure your issue complies with these guidelines:

• • [ ] Be using PMMP: No i am NOT using PMMP but my friend and he has got the same problem!
• • [ ] Make sure the issue hasn't already been reported: Nope!
• • [ ] Make sure you are on the latest version of PMMP & PiggyAuth: Yes i am on the latest version

General

I am using MySQL as Database! And PiggyAuth cant connet because of this: Warning: mysqli::__construct(): (HY000/1130): Host '(MyIpbutIdontSayItxD)' is not allowed to connect to this MySQL server in /-----/-------/plugins/PiggyAuth-master/src/PiggyAuth/Databases/MySQL.php on line 19

Warning: mysqli::query(): Couldn't fetch mysqli in /-----/------/plugins/PiggyAuth-master/src/PiggyAuth/Databases/MySQL.php on line 23

Server Software:

Tesseract, PMMP

Version of PiggyAuth:

PiggyAuth version 3.0.0.07

Data Provider:

• [*] MySQL

Steps to Reproduce the Issue

I get this error in the console when I am starting the Server! But the server isn't crashing 1.

Extra Information

Nope

[PluginBOXone]

And this error is coming too!

CRITICAL> Error: "Call to a member function fetch_assoc() on null" (EXCEPTION) in "/plugins/PiggyAuth-master/src/PiggyAuth/Databases/MySQL" at line 24

[SleepSpace9]

The message is saying the reason, doesn't it?

...Host '(MyIpbutIdontSayItxD)' is not allowed to connect to this MySQL server...

Check your database permissions, I guess your MySQL server is not hosted on the same machine.

[PluginBOXone]

Yeah.. mySQL is not hosted on the vServer where i host the MCPE Server... so what shuold I do?

[SleepSpace9]

Grant privileges to your MySQL user with access from your MCPE server. I don't know if you can fully manage your MySQL server by yourself. If yes a mysql command to allow everything for your database user from every remote host (not recommended for production) would be...

GRANT ALL PRIVILEGES ON \<YourDatabaseName>. TO '\<YourDatabaseUser>'@'%' IDENTIFIED BY '\<YourDatabasePassword>*';

[PluginBOXone]

The problem is... every other Plugin CAN connect to the MySQL Database and only PiggyAuth not :( And i filled in the same things ...

[PluginBOXone]

Oh man.... I'm a dump ***.... wrote in the false IP xD

[PluginBOXone]

Now PiggyAuth can connect but this is happening (When i am joining the Server I have to register.... when i am rejoining i have to register again .. and again.... Console Output:

CRITICAL> Error: "Call to a member function fetch_assoc() on boolean" (EXCEPTION) in "/plugins/PiggyAuth-master/src/PiggyAuth/Databases/MySQL" at line 24

[DaPigGuy]

This bug was caused by the fact that the table was empty.