[Digikam-devel] [Bug 280678] MYSQL : cannot migrate from sqlite database
Francesco Riosa
francesco+kde at pnpitalia.it
Sat Mar 24 11:51:53 GMT 2012
https://bugs.kde.org/show_bug.cgi?id=280678
Francesco Riosa <francesco+kde at pnpitalia.it> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |francesco+kde at pnpitalia.it
--- Comment #13 from Francesco Riosa <francesco+kde at pnpitalia.it> ---
(In reply to comment #11)
> I think this is bad idea to grant such privileges. For example amarok works
> fine without such things... All it needs — username, password and
> permissions to manage single database.
for the record; amarok run mysql with skip-grant-tables [1] option, so
everybody is root.
If we need to modify the schema, table or indexes we need alter privileges, but
we can still make things better separating update of the database from normal
operations so you need to provide a user with "alter" provileges only for a
limited period of time, when doing the changes.
[1]
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-grant-tables
--
You are receiving this mail because:
You are the assignee for the bug.
More information about the Digikam-devel
mailing list