Search
Categories
Fix Cyberpanel: Access denied for user ‘cyberpanel’@’localhost’ (using password: YES)
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.
