[Digikam-devel] [Bug 280678] MYSQL : cannot migrate from sqlite database

[Francesco Riosa]

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.