#SQLSTATE[HY000]

3 messages · Page 1 of 1 (latest)

lime orchid
#

There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [2002] Connection refused (Connection: dynamic, SQL: SELECT 1 FROM dual)"

I have already done all tips from bot

remote heronBOT
#

🇫🇷 🥖 Bienvenue sur Internet, @lime orchid 🥖 🇫🇷

Your database is refusing the Panel's attempts to connect to it. This can be for a number of different reasons so I'll let a human double check, but here are some ideas.

  1. Is your MySQL instance running? systemctl status mysql(hopefully not down the road)
  2. Is the user you're trying to connect with authorized to access the given database from this IP address?
  3. Did you correctly give that user permission to even access that database?
  4. Do you have a Firewall that is blocking connections?
  5. Is your MySQL instance bound to 127.0.0.1 or localhost and you're trying to connect from outside the server?
  6. Does the user have GRANT permissions if you're trying to use them to create a new database for a server?
  7. Have special characters in your password? Make sure DB_PASSWORD in your .env file is enclosed in double quotes

Here is some additional documentation to help you out: https://pterodactyl.io/tutorials/mysql_setup.html

lime orchid
#

There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [1130] Host '5.252.195.234' is not allowed to connect to this MariaDB server (Connection: dynamic, SQL: SELECT 1 FROM dual)"