Forum

Mysql user create e...
 
Notifications
Clear all

[Solved] Mysql user create error


Beamer
Posts: 70
Topic starter
(@hemens)
Trusted Member
Joined: 4 years ago

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 729 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

Topic Tags
7 Replies
Beamer
Posts: 70
Topic starter
(@hemens)
Trusted Member
Joined: 4 years ago

Anyone is facing such issue ?

Reply
Trevor Robinson
Posts: 1403
Admin
(@trobinson)
Member
Joined: 6 years ago

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

Reply
1 Reply
Beamer
(@hemens)
Joined: 4 years ago

Trusted Member
Posts: 70

@trobinson 

Hello, mysql 5.6.51

Reply
Trevor Robinson
Posts: 1403
Admin
(@trobinson)
Member
Joined: 6 years ago

Hello,

Do you have "Use OLD_PASSWORD Algorithm" set in the provider settings?

Regards,

Trevor

Reply
1 Reply
Beamer
(@hemens)
Joined: 4 years ago

Trusted Member
Posts: 70

@trobinson 

yes old algo password setting is ticket - enabled 

Reply
Trevor Robinson
Posts: 1403
Admin
(@trobinson)
Member
Joined: 6 years ago

@hemens Can you try disable and see if that fixes the issue? I think maybe newer versions of Mysql do not support this anymore.

Reply
1 Reply
Beamer
(@hemens)
Joined: 4 years ago

Trusted Member
Posts: 70

@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

Reply
Share:
Downloads