ERROR
No database host was found that meets the requirements for this server.
#ERROR No database host was found that meets the requirements for this server.
graceful arch
vapid shoalBOT
@graceful arch You can add database host at admin Panel > Databases > Create New. You have to create a database host user first by following our guide at https://pterodactyl.io/tutorials/mysql_setup.html#creating-a-database-host-for-nodes
graceful arch
MariaDB [(none)]> GRANT ALL PRIVILEGES ON panel.* TO 'admin'@'127.0.0.1' WITH GRANT OPTION;
Query OK, 0 rows affected (0.001 sec)
I did what you asked for but it gives me errors
robust iron
Did you add a new database under Databases in your Panel in the Admin Section or just under your server under Databases like in your screenshot?
You'll need to create one here before you can create databases on your server
graceful arch
There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [1045] Access denied for user 'pterodactyluser'@'' (using password: YES) (SQL: SELECT 1 FROM dual)"
vapid shoalBOT
🇫🇷 🥖 Bienvenue sur Internet, @graceful arch 🥖 🇫🇷
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.
- Is your MySQL instance running?
systemctl status mysql(hopefully not down the road) - Is the user you're trying to connect with authorized to access the given database from this IP address?
- Did you correctly give that user permission to even access that database?
- Do you have a Firewall that is blocking connections?
- Is your MySQL instance bound to
127.0.0.1orlocalhostand you're trying to connect from outside the server? - Does the user have
GRANTpermissions if you're trying to use them to create a new database for a server? - 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
robust iron
Did you put 127.0.0.1 where it asked for host?
user would just be pterodactyluser
host would be 127.0.0.1
graceful arch
There was an error while trying to connect to the host or while executing a query: "SQLSTATE[HY000] [1045] Access denied for user 'pterodactyluser'@'localhost' (using password: YES) (SQL: SELECT 1 FROM dual)"
vapid shoalBOT
🇫🇷 🥖 Bienvenue sur Internet, @graceful arch 🥖 🇫🇷
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.
- Is your MySQL instance running?
systemctl status mysql(hopefully not down the road) - Is the user you're trying to connect with authorized to access the given database from this IP address?
- Did you correctly give that user permission to even access that database?
- Do you have a Firewall that is blocking connections?
- Is your MySQL instance bound to
127.0.0.1orlocalhostand you're trying to connect from outside the server? - Does the user have
GRANTpermissions if you're trying to use them to create a new database for a server? - 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
graceful arch
