public:edition:cloudbacko_pro:faq:cannot_view_all_mysql_databases_in_backup_source

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: 2019/09/23 17:11 by ronnie.chan