Configuring MySQL on your Strapi project

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
1 Like

In mysql server 8
SELECT user, plugin FROM mysql.user WHERE user IN (‘root’);
changed to
SELECT plugin FROM mysql.user WHERE user IN (‘root’);

Really helpful. Thanks!

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