49
Add support for mysql2 (MySQL v8+ auth system)
in progress
Activity Feed
Sort by
Derrick Mehaffy
in progress
Community PR in progress: https://github.com/strapi/strapi/pull/13775
Johnny Prescott
This one is the real solution: https://github.com/strapi/strapi/pull/13775
It should be merged and this should not be marked as complete until it is imo.
Ariel Lindo
the solution for me was changing the plugin in the mysql database
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'your_password'
and
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password'
Pavel
Ariel Lindo: ERROR 1396 (HY000): Operation ALTER USER failed for 'root'@'%'
Song Xu
SOS
Derrick Mehaffy
open
H
Hossem Cold
Derrick Mehaffy: what does it mean
Derrick Mehaffy
Hossem Cold: Sorry it was marked as complete by accident. I do believe that we still want to do this but haven't quite found the time yet.
Aurélien Georget
complete
Derrick Mehaffy
Working on pre-req to be able to add this (upgrade to Knex v1): https://github.com/strapi/strapi/pull/12918
Derrick Mehaffy
planned
Ivo Raisr
Hi Derrick Mehaffy,
I can confirm your hard work of upgrading to knex v1 has paid off! With just a slight modification in @strapi/database/lib/dialects/, I was able to use mysql2 dialect and connect strapi to MySQL server 8.0.32 over TLS, using client X.509 certificate for authentication.
Derrick Mehaffy
Ivo Raisr: Happy to hear, I know we do have an open PR and our primary concern on this one is to ensure backwards compatibility with MariaDB as well. It's in our backlog to look at that PR.