Exception thrown wh...
 
Notifications
Clear all

Exception thrown when updating MySQL 8 user password

7 Posts
2 Users
0 Reactions
2,277 Views
Posts: 1457
Admin
(@trobinson)
Noble Member
Joined: 9 years ago

Hi Mark,

Would you please try download the latest version of the http://installer.solidcp.com/Files/1.4.4/SQLProvider-Fix.zip file and replace the DLL files?

I have switched the SQL Syntax from SET PASSWORD to ALTER USER which appears to work for MySQL 8. If you can test this and let me know if it works for you.

Kind Regards,

Trevor Robinson

Reply
Posts: 4
 Mark
Topic starter
(@markexpertitsolutions-co-uk)
New Member
Joined: 5 years ago

Trevor - you are a Super Star !!!

New fix installed, application pool restarted and MySQL passwords can now be changed (verified that change was committed after each test).

Thank you very much for your help to fix this, it is very much appreciated!

Mark...

Reply
Page 2 / 2
Share: