https://bugs.kde.org/show_bug.cgi?id=517251
Bug ID: 517251
Summary: MariaSQL Migration
Classification: Applications
Product: digikam
Version First 9.0.0
Reported In:
Platform: Microsoft Windows
OS: Microsoft Windows
Status: REPORTED
Severity: wishlist
Priority: NOR
Component: Database-Migration
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Hi!
I've been experimenting a bit.
I wanted to set up a MariaDB database on my Synology NAS again (without
Docker).
DigiKam's migration process includes an SQL example under "Prerequisites"
showing how to create the user and database in phpMyAdmin. The hostname of the
SQL server is simply copied from the previous tab.
CREATE USER 'digikam'@'synology' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'digikam'@'synology' IDENTIFIED BY 'password';
CREATE DATABASE `digikam`;
GRANT ALL PRIVILEGES ON `digikam`.* TO 'digikam'@'synology';
FLUSH PRIVILEGES;
Unfortunately, this doesn't work in my case, as it only allows local access to
the database from the Synology NAS. To allow external connections, a % symbol
needs to be used.
Here's the SQL command that appears when I create it manually.
CREATE USER 'digikam'@'%' IDENTIFIED BY 'password';GRANT ALL PRIVILEGES ON *.*
TO 'digikam'@'%' REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0
MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;CREATE
DATABASE IF NOT EXISTS `digikam`;GRANT ALL PRIVILEGES ON `digikam`.* TO
'digikam'@'%';
Should this be noted in the description in the migration window?
Andy
--
You are receiving this mail because:
You are watching all bug changes.
