[Digikam-devel] [digikam] [Bug 262321] MYSQL : user privileges management

[regi.hops at gmx.net]

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

--- Comment #25 from regi.hops at gmx.net ---
(In reply to Christian from comment #24)
> Remark:
> 
> In Amarok this issue is solved by a short description under the db-settings
> where you can copy and paste the SQL code to your mysql console.
> 
> This would be a great improvement for digikam as well - the basic code is:
> 
> CREATE DATABASE digikamdb;GRANT ALL PRIVILEGES ON digikamdb.* TO
> 'digikamuser'@'localhost' IDENTIFIED BY '**'; FLUSH PRIVILEGES;
> GRANT SUPER ON *.* TO 'digikamuser'@'localhost'; FLUSH PRIVILEGES;
> 
> PS: Please remove the german translation for "port" in digikam the digikam
> db settings - no one will understand "anschluss".

That would be a good idea, or even a link to the DigiKam-Website with the
respective statements would be fine.

And to solve this "bug", please remove the Stored Procedure
"create_index_if_not_exists" and implement it in another way if still needed.

Without that Stored Procedure one could give all privileges to a dedicated User
only for the DigiKam Database, without the need for super privileges. As SUPER
is a Server privilege, the DigiKam-User could access other Databases, which is
not wanted on a shared database server.

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