#1044 Access denied for user pterodactyl

7 messages · Page 1 of 1 (latest)

pliant creek
#

When I try creating a databse in a server I get this error

Syntax error or access violation: 1044 Access denied for user 'pterodactyl'@'%' to database 's2_csgodb' at /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php:545)

Syntax error or access violation: 1044 Access denied for user 'pterodactyl'@'%' to database 's2_csgodb' (Connection: dynamic, SQL: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, REFERENCES, INDEX, LOCK TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, EVENT, TRIGGER ON s2_csgodb.* TO u2_5l5AnkmdKQ@%) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'pterodactyl'@'%' to database 's2_csgodb' (Connection: dynamic, SQL: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, ALTER, REFERENCES, INDEX, LOCK TABLES, CREATE ROUTINE, ALTER ROUTINE, EXECUTE, CREATE TEMPORARY TABLES, CREATE VIEW, SHOW VIEW, EVENT, TRIGGER ON s2_csgodb.* TO u2_5l5AnkmdKQ@%) at /var/www/pterodactyl/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760)

But I gave all permissions need to this user according to docs

GRANT ALL PRIVILEGES ON panel.* TO 'pterodactyl'@'%' WITH GRANT OPTION;

GRANT ALL PRIVILEGES ON *.* TO 'pterodactyl'@'%' WITH GRANT OPTION;

proud stormBOT
#

🇫🇷 🥖 Bienvenue sur Internet, @pliant creek 🥖 🇫🇷

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

fading bane
#

See the guide the bot linked.

pliant creek
#

what do you mean by panel user?

#

oh you mean I need to create a 2nd user in the database ?!

#

yes it worked like charm 🙂 thank you so much