Hi,
Is anyone facing mysql user creation / db creation error post last mysql update.
Below is the scp log, while creating the user
[9/14/2021 7:27:29 AM] ERROR: 'MySQL Server 5.6' CreateUser
MySql.Data.MySqlClient.MySqlException (0x80004005): Password hash should be a 41-digit hexadecimal number
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, 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.ExecuteNonQuery()
at SolidCP.Providers.Database.MySqlServer.ExecuteNonQuery(String commandText, String connectionString)
at SolidCP.Providers.Database.MySqlServer.ChangeUserPassword(String username, String password)
at SolidCP.Providers.Database.MySqlServer.CreateUser(SqlUser user, String password)
at SolidCP.Server.DatabaseServer.CreateUser(SqlUser user, String password)
Pls advice
Thanks
Anyone is facing such issue ?
Hello,
Can you tell me which version of MySQL server you have installed? I know MySQL 8 has changes to its provider as the command was changed.
Regards,
Trevor
Hello,
Do you have "Use OLD_PASSWORD Algorithm" set in the provider settings?
Regards,
Trevor
@hemens Can you try disable and see if that fixes the issue? I think maybe newer versions of Mysql do not support this anymore.
@trobinson bingo, when i disable, able to create new db and user as well.
but i had tried earlier and was not able to create user but now it worked, will keep checking.
thanks
