Error Code: 1524. Plugin 'mysql_native_password' is not loaded
jaytonbye
PROOP

2 years ago

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]';

14 Replies

jaytonbye
PROOP

2 years ago

3692d0c7-628e-419d-8724-d5204c84798a


jaytonbye
PROOP

2 years ago

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.


2 years ago

where are you getting that error from?


jaytonbye
PROOP

2 years ago

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.


2 years ago

from my understanding that password plugin we deprecated a while ago, and finally removed in MySQL 9


2 years ago

you can always run MySQL 8 if updating client code is out of the question


jaytonbye
PROOP

2 years ago

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.


2 years ago

replace the image with MySQL 8 and then wipe the volume


jaytonbye
PROOP

2 years ago

I replaced mysql:9 with mysql:8 as the Source Image, but I don't see a way to wipe the volume.


2 years ago

that's done from within the volume settings


jaytonbye
PROOP

2 years ago

Ugh, a secret tab I didn't know about! Thanks, I think i'm heading in the right direction now.


2 years ago

haha its not secret -


jaytonbye
PROOP

2 years ago

Lol, I thought I knew the dashboard, but apparently I've never clicked on that little guy. Thank you.


2 years ago

no problem! let me know if you have any more questions!


Welcome!

Sign in to your Railway account to join the conversation.

Loading...