Bug 454882 - Requirements for MySQL Server omit USER
Summary: Requirements for MySQL Server omit USER
Status: RESOLVED FIXED
Alias: None
Product: digikam
Classification: Applications
Component: Database-Mysql (show other bugs)
Version: 7.6.0
Platform: Arch Linux Linux
: NOR normal
Target Milestone: ---
Assignee: Digikam Developers
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-06-05 14:57 UTC by Milan Knížek
Modified: 2022-06-05 16:29 UTC (History)
1 user (show)

See Also:
Latest Commit:
Version Fixed In: 7.7.0
Sentry Crash Report:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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