Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

UI bug in window: User Manager?

nat's profile image nat posted 4 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.

mpiero's profile image mpiero posted 4 years ago Permalink

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

ansgar's profile image ansgar posted 4 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.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Code modification/commit 0ec226c from ansgarbecker, 4 years ago, revision 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
ansgar's profile image ansgar posted 4 years ago Permalink

Should be fixed in r5087

Taomyn's profile image Taomyn posted 4 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

vbs's profile image vbs posted 4 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!

ShirleyFWilliams's profile image ShirleyFWilliams posted 4 years ago Permalink

i also have same problem.

ansgar's profile image ansgar posted 1 month 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.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.