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

jaytonbyePRO

6 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

jaytonbyePRO

6 months ago

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


jaytonbyePRO

6 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.


6 months ago

where are you getting that error from?


jaytonbyePRO

6 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.


6 months ago

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


6 months ago

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


jaytonbyePRO

6 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.


6 months ago

replace the image with MySQL 8 and then wipe the volume


jaytonbyePRO

6 months ago

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


6 months ago

that's done from within the volume settings


jaytonbyePRO

6 months ago

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


6 months ago

haha its not secret -


jaytonbyePRO

6 months ago

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


6 months ago

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