In this tutorial we will cover the MySQL installation processes. But wait, Is that all? A big no. I will also guide you to configure the installed MySQL to work with our headless CMS, Strapi.
This is a companion discussion topic for the original entry at https://strapi.io/blog/configuring-strapi-mysql-database
In mysql server 8
SELECT user, plugin FROM mysql.user WHERE user IN (‘root’);
SELECT plugin FROM mysql.user WHERE user IN (‘root’);
Is it possible to use PlanetScale?
I know this is an older thread, but I’m hoping for help. I’ve followed all of the steps, but when I run “yarn develop” I keep getting the following error:
“Access denied for user ‘root’@‘localhost’ (using password: YES)”
I’ve tried recreating the database, recreating the strapi app, but nothing appears to be working. And when I checked, I have the proper mysql_native_password plugin.
Any insight would be greatly appreciated