Bug 400902

Summary: NAS Mysql cannot connect with instructions given by Dmitry Popov
Product: [Applications] digikam Reporter: Rainer Vömel <rainer.voemel>
Component: Database-MysqlAssignee: Digikam Developers <digikam-bugs-null>
Status: RESOLVED FIXED    
Severity: minor CC: dmpop, metzpinguin
Priority: NOR    
Version First Reported In: 5.9.0   
Target Milestone: ---   
Platform: Microsoft Windows   
OS: Microsoft Windows   
Latest Commit: https://commits.kde.org/digikam/cf9dbedb4c176b08ec60067b93c99a45bf360676 Version Fixed In: 6.0.0
Sentry Crash Report:

Description Rainer Vömel 2018-11-10 09:12:09 UTC 
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.
Comment 1 Maik Qualmann 2018-11-10 14:14:45 UTC 
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
Comment 2 Maik Qualmann 2018-11-10 14:18:30 UTC 
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
Comment 3 Dmitri Popov 2018-11-14 08:04:31 UTC 
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?
Comment 4 Dmitri Popov 2022-01-18 12:05:12 UTC 
(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
Comment 5 Maik Qualmann 2022-01-18 19:15:28 UTC 
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