https://bugs.kde.org/show_bug.cgi?id=454882
Bug ID: 454882
Summary: Requirements for MySQL Server omit USER
Product: digikam
Version: 7.6.0
Platform: Archlinux Packages
OS: Linux
Status: REPORTED
Severity: normal
Priority: NOR
Component: Database-Mysql
Assignee: digikam-bugs-n...@kde.org
Reporter: kni...@volny.cz
Target Milestone: ---
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;
--
You are receiving this mail because:
You are watching all bug changes.
