Database error | Pterodactyl® | Page 1

vivid atlas Feb 10, 2023, 2:33 PM

#

its there any was to change the user from the database

I'm talking about this:
CREATE USER 'pterodactyluser'@'127.0.0.1' IDENTIFIED BY 'somepassword';

I used an wrong ip and now i can't create database(sub database) for my servers

wind delta Feb 10, 2023, 2:38 PM

#

vivid atlas its there any was to change the user from the database I'm talking about this: ...

can always cancel

vivid atlas Feb 10, 2023, 2:42 PM

#

got this one

#

No database host was found that meets the requirements for this server.

lament widgetBOT Feb 10, 2023, 2:42 PM

#

@vivid atlas 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

vivid atlas Feb 10, 2023, 2:42 PM

#

oh

#

bruh

#

i'm stupid

vivid atlas Feb 10, 2023, 3:04 PM

#

fixed that

#

but now i have another one

#

An unexpected error was encountered while processing this request, please try again.

lament widgetBOT Feb 10, 2023, 3:04 PM

#

@vivid atlas; 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

vivid atlas Feb 10, 2023, 3:05 PM

#

https://pteropaste.com/wqb291

lament widgetBOT Feb 10, 2023, 3:05 PM

#

I have found the following for: https://pteropaste.com/wqb291
🇫🇷 🥖 Bienvenue sur Internet, @vivid atlas 🥖 🇫🇷

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.1 or localhost and you're trying to connect from outside the server?
Does the user have GRANT permissions 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

#Database error