[Digikam-devel] [digikam] [Bug 355831] MySQL Schema Improvements

[via KDE Bugzilla]

https://bugs.kde.org/show_bug.cgi?id=355831

--- Comment #12 from caulier.gilles at gmail.com ---
About 5/5 : why CreateFaceTriggers is commented now ?

About database init, before we use :

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

now, you use :

GRANT USAGE ON *.* TO 'digiuser'@'localhost' IDENTIFIED BY 'abc123';
GRANT ALL PRIVILEGES ON `digikam`.* TO 'digiuser'@'localhost';
CREATE DATABASE digikam;

=> You create database at end. Why ?
=> you grant usage to dedicated user. Why ?
=> you grant privilege to this dedicated user too. Why ?
=> you do not flush privilege. Why ?

Is you rules are to create a database only usable by a dedicated user, and not
root ? This will permit to share the same database with more than one users  at
the same time ?

Gilles Caulier

-- 
You are receiving this mail because:
You are the assignee for the bug.