search

pmachapman / mysqltuner

MySQL Tuner for Windows
GNU General Public License v3.0
101 stars 16 forks source link

"Unknown column 'password'" error on MySQL 5.7.9 #12

Closed scomnoob closed 8 years ago

scomnoob commented 8 years ago

win 2012r2 mysql 5.7.9

It fails with very strange error

MySql.Data.MySqlClient.MySqlException (0x80004005): Unknown column 'password' in 'where clause' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId) at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId) at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force) at MySql.Data.MySqlClient.MySqlDataReader.NextResult() at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior) at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader() at MySqlTuner.FormMain.SecurityRecommendations() in c:\Users\Peter\Documents\Visual Studio 2013\Projects\MySQLTuner\MySQLTuner\FormMain.cs:line 596 at MySqlTuner.FormMain.BackgroundWorker_DoWork(Object sender, DoWorkEventArgs e) in c:\Users\Peter\Documents\Visual Studio 2013\Projects\MySQLTuner\MySQLTuner\FormMain.cs:line 388

error

scomnoob commented 8 years ago

any news?

pmachapman commented 8 years ago

I haven't yet had a chance to look at the bug - I have quite a lot on at the moment. I will update this issue when I get a chance to look into it.

alefort commented 8 years ago

I'm also experiencing this on mysql 5.7.9

pmachapman commented 8 years ago

I am in the process of upgrading my server to MySQL 5.7, and reading the docs it turns out that the password field is now called authentication_string. Go figure.

I have written a fix, and it is in commit 04057512146b29aca71b75e1fa3836a2d6a86897