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

jaytonbye
PRO

10 months ago

I'm provisioning a new database, but I'm unable to run the following command: ALTER USER 'user'@'%' IDENTIFIED WITH mysqlnativepassword BY '[password]';

0 Replies

jaytonbye
PRO

10 months ago

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


jaytonbye
PRO

10 months 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.


10 months ago

where are you getting that error from?


jaytonbye
PRO

10 months 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.


10 months ago

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


10 months ago

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


jaytonbye
PRO

10 months 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.


10 months ago

replace the image with MySQL 8 and then wipe the volume


jaytonbye
PRO

10 months ago

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


10 months ago

that's done from within the volume settings


jaytonbye
PRO

10 months ago

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


10 months ago

haha its not secret -


jaytonbye
PRO

10 months ago

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


10 months ago

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