Bug 454882

Summary: Requirements for MySQL Server omit USER
Product: [Applications] digikam Reporter: Milan Knížek <knizek>
Component: Database-MysqlAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: normal CC: metzpinguin
Priority: NOR    
Version First Reported In: 7.6.0   
Target Milestone: ---   
Platform: Arch Linux   
OS: Linux   
Latest Commit: Version Fixed In: 7.7.0
Sentry Crash Report:

Description Milan Knížek 2022-06-05 14:57:35 UTC
SUMMARY

When configuring database for external MySQL Server, the second tab called "Requirements" lists these commands:

CREATE USER ''@'' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO ''@'' IDENTIFIED BY 'password';
CREATE DATABASE digikam;
GRANT ALL PRIVILEGES ON digikam.* TO ''@'';
FLUSH PRIVILEGES;

OBSERVED RESULT
Creating a USER w/o username fails.

PROPOSED SOLUTION

Modify the SQL commands to:

CREATE USER 'digikam'@'' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'digikam'@'' IDENTIFIED BY 'password';
CREATE DATABASE digikam;
GRANT ALL PRIVILEGES ON digikam.* TO 'digikam'@'';
FLUSH PRIVILEGES;
Comment 1 Maik Qualmann 2022-06-05 16:25:39 UTC
The problem has been reported before and is fixed for digiKam-7.7.0. We added tick marks.

Maik
Comment 2 Maik Qualmann 2022-06-05 16:29:01 UTC
This was the commit:

https://invent.kde.org/graphics/digikam/-/commit/474608ef5f74b84bd0f9afbd5c3389f73d95f831

Maik