#Database host

2 messages · Page 1 of 1 (latest)

mint stag
#

Im trying to create a database but I keep getting this error "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 already gave the user privileges still refusing connection

Screenshot_2025-12-09_235519.png
past hawkBOT
#

🇫🇷 🥖 Bienvenue sur Internet, @mint stag 🥖 🇫🇷

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