#Unable to create product and also do not work displayed users.

1 messages · Page 1 of 1 (latest)

small night
last moth
#

SQLSTATE[HY000] [2002] Connection refused (SQL: select column_name as column_name from information_schema.columns where table_schema = controlpanel and table_name = useful_links) in /var/www/controlpanel/vendor/laravel/framework/src/Illuminate/Database/Connection.php:760

brazen cedarBOT
# last moth SQLSTATE[HY000] [2002] Connection refused (SQL: select column_name as `column_na...

Your database is refusing the dashboard'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
  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://CtrlPanel.gg/docs/Installation/getting-started#database-setup

——————————-
credits to pterodactyl team for making this good message

Getting started | Ctrlpanel.gg

It is recommended that you have some sort of Linux and MariaDB experience before installing this.

small night