'I am not being able to connect to my MariaDB remotely

So I have a MariaDB running on my Raspberry and I have created some Android apps that read/write data to that database.

Yesterday the apps were not able to connect to the database, so I tried to:

  • restart the nginx and mariadb services from the Raspberry terminal
  • connect remotely using phpMyAdmin with the Raspberry IP + port (it was already configured as I used that plenty of times to inspect the data)

None of these options worked.

The connection fails after a timeout and this is the message I get:

phpMyAdmin tried to connect to the MySQL server, and the server refused this connection. You will need to review the host, username, and password in https://config.inc.php and make sure they match the information provided by the MySQL server administrator.

I think that message is wrong because I did not change anything in the configuration file, the users are the same as always, but it just does not work.

Entering the database from the Raspberry terminal works. Checked the users, the one I'm using exists and the password is the one I'm using too.

I'm running out of ideas and in need of a helping hand.

If anyone want to see any specific log, just ask me.

Thanks.



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source