Sidebar

Announcement

CloudBacko Pro

CloudBacko Lite

CloudBacko Home

CloudBacko App

License

Features

Hotfix

Discussion

Can't Find What You Need?

FAQ

public:edition:cloudbacko_pro:faq:cannot_view_all_mysql_databases_in_backup_source

Table of Contents

ISSUE: Cannot view all MySQL databases in the "Backup Source" screen


Cause


This could be related to insufficient permissions with the MySQL user account specified in the backup settings.

Resolution


Login to MySQL server using 'root' account and grant the following permissions to the user account using the following commands:

1. GRANT ALL PRIVILEGES ON *.* TO "%username%"@"localhost" IDENTIFIED BY "%password%";
2. GRANT ALL PRIVILEGES ON *.* TO "%username%"@"localhost.localdomain" IDENTIFIED BY "%password%";
3. FLUSH PRIVILEGES;

For example, to grant the correct permissions to the 'backup' account and password is set to 'abc'.

GRANT ALL PRIVILEGES ON *.* TO "backup"@"localhost" IDENTIFIED BY "abc";
GRANT ALL PRIVILEGES ON *.* TO "backup"@"localhost.localdomain" IDENTIFIED BY "abc";
FLUSH PRIVILEGES;

Open the backup source view to confirm all databases are shown.

public/edition/cloudbacko_pro/faq/cannot_view_all_mysql_databases_in_backup_source.txt · Last modified: 2021/04/16 17:25 by ronnie.chan