[Digikam-users] Mysql/MariaDb database expert needs...

[Henrique Santos Fernandes]

>
>
>> > show grants for 'user'@'%';  now this user and the % will depend on
>> what user are you using!
>>
>> I guess it does not matter the content on mysql folders, only what the
>> database shows right? i dont thing we suppose to make chnages directly on
>> the disk for mysql.
>>
>
> MariaDB [(none)]>  show grants for 'digikam'@'localhost';
> +----------------------------------------------------------------------------------------------------------------+
>
> | Grants for digikam at localhost
>                                                                                   |
>
> +----------------------------------------------------------------------------------------------------------------+
>
> | GRANT SUPER ON *.* TO 'digikam'@'localhost' IDENTIFIED BY PASSWORD
> '*B86D61DED45FEAAB193591C66C302416B0E64CA6' |
> | GRANT ALL PRIVILEGES ON `digikamcoredb`.* TO 'digikam'@'localhost'
>                                             |
> | GRANT ALL PRIVILEGES ON `digikamthumbsdb`.* TO 'digikam'@'localhost'
>                                           |
> | GRANT ALL PRIVILEGES ON `digikamfacedb`.* TO 'digikam'@'localhost'
>                                             |
> +----------------------------------------------------------------------------------------------------------------+
>
> 4 rows in set (0.00 sec)
>
> Gilles
>
>
> I am no expert but it seens that user 'digikam'@'localhost' dont need a
password to the databases digikamcoredb, digikamthumbsdb and digikamfacedb
It only need password when using things when need super privileges right?

Just to make sure, run this comand on linux shell:
$ mysql -u digikam
and if it connects:
> show databases
You may try to insert and delete stuff on anydatabase just to verify the
permissiosn if you will!

This test will verify if my assumpting is right.. Sorry to keep asking for
commans.. i should fo it myself..

many people wont like this permissions for that user!

Thanks, great job!

Digikam is great!


> _______________________________________________
> Digikam-users mailing list
> Digikam-users at kde.org
> https://mail.kde.org/mailman/listinfo/digikam-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151118/f2a1a1e3/attachment.html>