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

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

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

{{public:faq_mysql_01.png}}

===== 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:
<code>
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;
</code>

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

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

{{public:faq_mysql_02.png}}


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

{{public:faq_mysql_03.png}}

User Tools

Site Tools

Page Tools