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

[Gilles Caulier]

2015-11-17 18:52 GMT+01:00 Henrique Santos Fernandes <sf.rique at gmail.com>:

> Great news!
>
> Gilles, if i may ask can you run this comands on your mysql?
>
> > show databases;
>
> it should show:
> digikamcoredb
> digikamfacedb
> digikamthumbsdb
>


yes :

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| digikamcoredb      |
| digikamfacedb      |
| digikamthumbsdb    |
| information_schema |
| mysql              |
| performance_schema |
| test               |
+--------------------+
7 rows in set (0.02 sec)



>
> Bytheway, this names are configurable?
>

Sure, in database setup/migration dialog


>
> > 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20151118/f6a98dcb/attachment.html>