SUMMARY NAS Mysql cannot connect with instructions given by Dmitry Popov: Set up user with host % STEPS TO REPRODUCE 1. Set up user with phpAdmin e.g. testuser and host = % 2. Windows 10, MySQL Workbench or DigiKam try to connect will fail 3. Add testuser2 with host being the name of the Windows computer 4. Connect will succeed. SOFTWARE/OS VERSIONS Windows: 10 Build 17134.345 NAS: Synology 215j with MariaDB 5 and 10 tested ADDITIONAL INFORMATION Please ask Dmitri to update documentation. I am very happy to be able to run this configuration.
Git commit cf9dbedb4c176b08ec60067b93c99a45bf360676 by Maik Qualmann. Committed on 10/11/2018 at 14:13. Pushed by mqualmann into branch 'master'. update server instruction to not use % wildcard FIXED-IN: 6.0.0 M +2 -1 NEWS M +18 -12 core/libs/database/utils/widgets/dbsettingswidget.cpp https://commits.kde.org/digikam/cf9dbedb4c176b08ec60067b93c99a45bf360676
Since the % wildcard does not always include localhost, we always use now the hostname for the server instruction. I added Dmitry to this bug. Maik
Thank you for adding me to the bug. So does this mean that instead of %, the user needs to specify the hostname of the client? For example, if I use my Linux laptop with hostname "thinkpad-x220", then % should be replaced with "thinkpad-x220". If this is indeed the case, how can the user connect to MySQL from other machines?
(In reply to Maik Qualmann from comment #2) > Since the % wildcard does not always include localhost, we always use now > the hostname for the server instruction. I added Dmitry to this bug. > > Maik Hi Maik, I'd grateful if you could help me with this one. If % doesn't work, what is then the correct way to specify host(s)? Thank you! Best, Dmitri
Hi Dmitri, here is explained what the cause is if the wildcard '%' for the hostname doesn't work: https://stackoverflow.com/questions/28034682/wildcard-host-not-working-in-mariadb-mysql Maik