https://sourceforge.net/p/rexxsql/support-requests/34/2023-12-18T09:02:33.803000ZRecent changes to 34: MySql caching_sha2_password2023-12-18T09:02:33.803000Z2023-12-18T09:02:33.803000ZMark Hesslinghttps://sourceforge.net/u/rexx/https://sourceforge.net4c44924281d4d4f310dee21eaf09441a0e2df7be

<div class="markdown_content"><p>Hi Jon,<br/> Support request is ok.<br/> I built Rexx/SQL with the MySQL 8.0 API on Linux and it connected with a caching_sha2_password login without any change. Also connected to a remote database with a mysql_native_password login and it also worked.<br/> I'm assuming that you are using Windows; I'm hoping I just need to build Rexx/SQL for MySQL using the 8.0 API and it will connect to both login types.<br/> I might need to supply the MySQL 8.0 DLL with the Rexx/SQL installer as an option.</p></div>

2023-11-28T11:28:27.430000Z2023-11-28T11:28:27.430000ZJon Wolfershttps://sourceforge.net/u/sahananda/https://sourceforge.net6de25fe7f4ff72fe197a5a68a31ba344c1bfaa50

<div class="markdown_content"><p>Hi Mark,</p> <p>I'm not sure whether this should be a support request or a feature request.</p> <p>I recently installed MySql 8. Whereas previous versions of MySql had defaulted to mysql_native_password for the login mechanism, 8.0 defaults to caching_sha2_password which I could not work out how to connect using rexx/sql.</p> <p>As a workaround I had to alter each user like this:<br/> ALTER '<em>user</em>'@'<em>host</em>' IDENTIFIED WITH mysql_native_password BY '<em>password</em>'</p> <p>This works fine for me - where all the connections to the database are made using rexx/sql, but it might be nice to support caching_sha2_password or perhaps document the steps needed to modify your user such that rexx/sql can still connect to MySql 8</p> <p>Jon</p></div>