https://bugs.kde.org/show_bug.cgi?id=451289
--- Comment #4 from Jan Steinman <jan.stein...@gmail.com> --- (In reply to Maik Qualmann from comment #3) > The variant with tick marks doesn't work. > > GRANT ALL PRIVILEGES ON 'digikam.*' TO 'maik'@'127.0.0.1'; > > You have an error in your SQL syntax; check the manual that corresponds to > your MariaDB server version for the right syntax to use near ''digikam.*' TO > 'maik'@'127.0.0.1'' at line 1 > > In fact, it must be so-called backticks. > > Maik ARGH! Yes, of course, you are right. I'll update the bug to say so. Not only that, but each hierarchical part must be separately back-ticked. So `digikam.*` will never work, but `digikam`.* should, at least in MySQL. Likewise, `DigiKam-Core.Albums` won't work, but `DigiKam-Core`.`Albums` should. The reference I noted in Comment 2 is ambiguous about Sqlite. I can't find a proper BNF for their language spec. -- You are receiving this mail because: You are watching all bug changes.
