UI bug in window: User Manager?

7 posts
nat's profile image nat posted 8 years ago in General Permalink

I see in the lower left corner, in red: "This user has an empty password." Is this a bug? All my accounts have passwords.

1 posts
mpiero's profile image mpiero posted 8 years ago Permalink

Same error for me. I think this usue is for mysql 5.7.x version or above

10151 posts
ansgar's profile image ansgar posted 8 years ago Permalink

Can confirm that. That's most probably a new bug which I introduced when I adapted the new column name "authentication_string" on MySQL 5.7.6+. Going to check that.

Code modification/commit 0ec226c from ansgarbecker, 8 years ago, revision 9.3.0.5087
Do not complain about empty password when SHOW GRANTS output does not include the IDENTIFIED BY clause on MySQL 5.7.6+. See http://www.heidisql.com/forum.php?t=21351
10151 posts
ansgar's profile image ansgar posted 8 years ago Permalink

Should be fixed in r5087

8 posts
Taomyn's profile image Taomyn posted 8 years ago Permalink

Hi,

I'm running HeidiSQL r5107 against MariaDB v10.1.16, and I get all my users showing in the user manager with an exclamation mark and the warning "This user has an empty password".

Has this been broken again?

Cheers, Taomyn

1 posts
vbs's profile image vbs posted 8 years ago Permalink

I also have this problem in HeidiSQL 9.3.0.5119 running with MariaDB ("mysql Ver 15.1 Distrib 10.0.27-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2") on Ubuntu 16.04 x64.

Any help please? Thanks!

3 posts
[expired user #10173]'s profile image [expired user #10173] posted 8 years ago Permalink

i also have same problem.

10151 posts
ansgar's profile image ansgar posted 4 years ago Permalink

I just refined my quirk from 4 years ago, so MariaDB should not show an empty password warning. See issue #1081.

Please login to leave a reply, or register at first.