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

Support and Discussion Web Server
#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

#2

Did you read Some Don'ts After Installing CyberPanel! — CyberPanel - WebHosting Control Panel for OpenLiteSpeed

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

#3

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

#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

#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

#6

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

#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’: ‘’,

#8

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