[Digikam-devel] [digikam] [Bug 327062] When a host is set for a user in mysql digikam fail to update

[e.longuemare at laposte.net]

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

--- Comment #2 from e.longuemare at laposte.net ---
Workaround :

Close digikam.

Go to mysql, delete all table and routine create_index_if_not_exists from
digikam thumb db.

Set the user new host permission in mysql.

Relaunch digikam, tables are recreated and routine too. No more error message
from digikam.

PS : I have try to alter routine and change definer, it's apply, but digikam
can't use routine. The above trick resolve this.

PS2 : I use digikam in network environnement, one NAS for files, one PC for
database server (mysql). I have set a mysql user by digikam workstation for
digikam both databases (thumb and data) perhaps my _Digikam_root_tags and other
problem were related to this.

So it's solved.

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