Error Code: 1524. Plugin 'mysql_native_password' is not loaded
I'm provisioning a new database, but I'm unable to run the following command: ALTER USER 'user'@'%' IDENTIFIED WITH mysql_native_password BY '[password]';
13 Replies
Project ID:
3692d0c7-628e-419d-8724-d5204c84798a3692d0c7-628e-419d-8724-d5204c84798a
Any suggestions? The other week I needed to add this to my MYSQL startup command: --mysql-native-password=ON , but this database was provisioned for MYSQL 9, and that command is not working. I'd rather run MYSQL 8, but either way, I need to be able to update the privileges.
where are you getting that error from?
MYSQL Workbench. We were trying to avoid changing the server code, but I'm going to try installing mysql2 to see if that fixes it.
from my understanding that password plugin we deprecated a while ago, and finally removed in MySQL 9
you can always run MySQL 8 if updating client code is out of the question
It didn't work, our server code for this project isn't compatible with mysql2. How would I go about setting up MYSQL 8? When I select add MYSQL database, it immediately spins up a new DB with MYSQL 9, I couldn't figure out how to configure it differently.
Solution
replace the image with MySQL 8 and then wipe the volume
I replaced mysql:9 with mysql:8 as the Source Image, but I don't see a way to wipe the volume.
that's done from within the volume settings
Ugh, a secret tab I didn't know about! Thanks, I think i'm heading in the right direction now.
haha its not secret - https://docs.railway.app/overview/the-basics#volume-settings
Lol, I thought I knew the dashboard, but apparently I've never clicked on that little guy. Thank you.
no problem! let me know if you have any more questions!