CyberPanel Community

Backup Error "Access denied for user 'root'@'localhost'

JW
John_Wick_1488 #1

Hi guys!
I have get a error when try to create back up manualy or with cronjob does not matter!
(1045, “Access denied for user ‘root’@‘localhost’ (using password: YES)”) [5009]
Its hapens with sites with database. Static sites backups works normaly

7 replies
JW
John_Wick_1488 #3

Allready read this instruction. I will try reinstal files with FTP

JW
John_Wick_1488 #4
Did you read https://forums.cyberpanel.net/discussion/171/some-donts-after-installing-cyberpanel

If you change the MySQL password, you need to update some files.

Yes. I set custom MySQL password after installation pass in /etc/cyberpanel was updated at the same time. I use SFTP
under each user separately exmp: Server/192.168.1.100/User2345/Pass:123456/port:21

Cy
CyberPanel #5

If you go to above link, carefully read under Changing MySQL Ports

There is a rootb entry in /usr/local/CyberCP/CyberCP/settings.py that you need to update.

'rootdb': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mysql',
        'USER': 'root',
        'PASSWORD': 'cyberpanel',
        'HOST': 'localhost',
        'PORT': '',
    }

Make sure to replace with correct MySQL root password then systemctl restart lscpd

JW
John_Wick_1488 #6

I was not attentive. After replace rootdb password in /settings.py all backups run successfully. Thank you for this awesome project!

JW
John_Wick_1488 #7
If you go to above link, carefully read under `Changing MySQL Ports`

There is a rootb entry in /usr/local/CyberCP/CyberCP/settings.py that you need to update.

'rootdb': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'mysql',
        'USER': 'root',
        'PASSWORD': 'cyberpanel',
        'HOST': 'localhost',
        'PORT': '',
    }

Make sure to replace with correct MySQL root password then systemctl restart lscpd

What a section default? I need to change password in this section?

‘default’: {
‘ENGINE’: ‘django.db.backends.mysql’,
‘NAME’: ‘cyberpanel’,
‘USER’: ‘cyberpanel’,
‘PASSWORD’: ‘PcP0E1zVw9AfE8’,
‘HOST’: ‘localhost’,
‘PORT’: ‘’,

Cy
CyberPanel #8

This dababase is used by CyberPanel. No need to change.

Sign in to reply