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

regi.hops at gmx.net regi.hops at gmx.net
Wed Jul 23 16:44:41 BST 2014


--- 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:
> '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.

More information about the Digikam-devel mailing list