Portfolio
My Blog
Scroll down to discover
Search
Categories

Fix Cyberpanel: Access denied for user ‘cyberpanel’@’localhost’ (using password: YES)

January 30, 2024Category : Bug & Security

Extract your current database password from:

/etc/cyberpanel/mysqlPassword

Use the password to login using below command:

mysql –host=127.0.0.1 –port=3306 -u root -p

Check if user cyberpanel exists:

SELECT user, host FROM mysql.user;

If cyberpanel user don’t exist, create it:

CREATE USER ‘cyberpanel’@‘localhost’ IDENTIFIED BY ‘YourCyberpanelDatabaseUserpassword’;

GRANT ALL privileges ON `cyberpanel`.* TO ‘cyberpanel’@localhost IDENTIFIED BY ‘YourCyberpanelDatabaseUserpassword’;

This “cyberpanelUserPassword” you can find in :

/usr/local/CyberCP/CyberCP/settings.py (nano /usr/local/CyberCP/CyberCP/settings.py)

FLUSH PRIVILEGES;

 

 

01.
© Oliver / All rights reserved.
To top