MySql caching_sha2_password
An external Rexx function package to connect to SQL databases
Brought to you by:
rexx
Menu
▾
▴
#34 MySql caching_sha2_password
Hi Mark,
I'm not sure whether this should be a support request or a feature request.
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.
As a workaround I had to alter each user like this:
ALTER 'user'@'host' IDENTIFIED WITH mysql_native_password BY 'password'
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
Jon
Hi Jon,
Support request is ok.
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.
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.
I might need to supply the MySQL 8.0 DLL with the Rexx/SQL installer as an option.