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
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?
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
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
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
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 -
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!