#[decided] sql error

14 messages · Page 1 of 1 (latest)

hallow sedge
#

I cannot create a database, although there are hosts in databases hosts, both hosts are on the local machine where the panel is installed.
The restriction for the server on the use of databases has been removed.
The user has all privileges.
This user is not a prerodactyluser

image.png image.png
neat terrace
#

can you read? assinged node: None

#

you have to link it to the node

hallow sedge
fresh sundialBOT
#

You'll need to grab the error logs from the Panel. The following command uploads the last 150 lines of this day's log to our pastebin and provides a link you can share.
tail -n 150 /var/www/pterodactyl/storage/logs/laravel-$(date +%F).log | nc pteropaste.com 99

hallow sedge
fresh sundialBOT
#

I have found the following for: https://pteropaste.com/8ir6zdi0zfbz/
🇫🇷 🥖 Bienvenue sur Internet, @hallow sedge 🥖 🇫🇷

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

hallow sedge
lost stream
#

The user is missing grant permissions (no 6 from the bots list)

hallow sedge
#

GRANT ALL PRIVILEGES ON test_database . * TO 'test_user'@'localhost';
I used this command to give the user rights, what did I do wrong right?

lost stream
hallow sedge
hallow sedge
lost stream
#

You can name the user whatever you want