User management

[expired user #9002]'s profile image [expired user #9002] posted 9 years ago in General Permalink
Hello,
I have problem using Using Management.
My PC configuration: Win7 64bit + MySql 5.7.7 64bit + HeidiSql 9.2.0.4961 64bit

When I click on user management icon in HeidiSql I get error message: SQL Error (1054): Unknown column 'password' in 'field list'.
In output is shown that query:
SELECT `user`, `host`, `password` FROM `mysql`.`user`;
was sent to the server.
I have checked table `mysql`.`user` - column 'password' isn't really there. I checked older version of MySql (5.5.23) and the column 'password' was there.
So I suppose that MySql has changed structure of user table in last version. Is there some settings in HeidiSql which allows me show user management window for new table structure? Or any ideas how could I resolve this issue?
Thank you.
Jirka
1 attachment(s):
  • msgError
ansgar's profile image ansgar posted 9 years ago Permalink
If that password column was removed in MySQL, you cannot resolve that on your side. I have to implement a version conditional plus some logic due to a missing field in that case.

Indeed, in MySQL 5.7.6, the password column was removed, and contents are being transferred to the new column called "authentication_string" using the mysql_upgrade program.

So, HeidiSQL should use that new authentication_string column on MySQL 5.7.6. Another TODO for me...
[expired user #9002]'s profile image [expired user #9002] posted 9 years ago Permalink
Thank you for your fast response.
Also thank you for great job! Your software is very useful!

Jirka
Code modification/commit from ansgarbecker, 9 years ago, revision 4973
User manager: Select "authentication_string" instead of "password" column on MySQL 5.7.6+. See http://www.heidisql.com/forum.php?t=18650
ansgar's profile image ansgar posted 9 years ago Permalink
Fixed in r4973. Please update your HeidiSQL.

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