Authentication plugin 'caching_sha2_password' cannot be loaded #103
Comments
|
Hmmm could you provide the full log output of the container? |
|
My bad, I hadn't installed |
|
Hello guys, I also have the following problem : I'm using full docker implementation and had followed this documentation : https://hub.docker.com/r/passbolt/passbolt/ The passbolt container starts and fails with the message above. |
|
Hi! Looks like mysql default authentication method has changed in mysql 8. It works fine with |
opensorceror
changed the title
|
Hi @dlen , when I use MySQL 5.7, I get the following error: Looks like the MySQL server fails to start at all when using 5.7. |
|
you have to remove the volumes before changing the mysql versions. |
|
Guys, can we add support of caching_sha2_password authentication in the Dockerfile, instead of using mysql 5.7 image ? Thank ! |
|
I will look into it in the upcoming days! Thanks for your feedback and support guys! |
|
@dlen I can confirm too that when using mysql 5.7 it is working fine ;) Thank guys |
|
Hi! I have been doing some research on adding mysql 8 to passbolt docker stack. First to say that this docker image has already plenty of dependencies and we would like to see the image size to go down, not up (unless is a really needed dependency, which this not seem to be the case). At this point the available solutions would be:
The first option I on the list I would rather to avoid as much as possible. Exploring the third option would leave us with a slightly different docker-compose.yaml. Here a snippet: Starting the stack with this setup throws a new error: Which leads to this issue. And passbolt was throwing multiple errors with this mysql version rendering it unusable (this issue would require more investigation): So, I think it's a good moment to switch to |
|
I am trying to migrate from postgresql to mysql/maria and cannot. This is a critical bug. |
|
Hi @nathantech2005! |
|
I am facing the same problem :( From the terminal everything works fine. I think this is more a problem of mysql or brew? |
|
Hi @fridzema!
However, If you still want to use mysql 8 you should set it up using the native password auth method. As mentioned in a previous comment Hope this helps |
|
@dlen Man! i have to steal the Apache one liner "It works!!!" , your solution works. Thanks. I have been stuck on this for days |
|
hi @fridzema @opensorceror i think this will work docker exec -it containerName mysql -u root -p !! |
|
hi @fridzema @opensorceror ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root'; FLUSH PRIVILEGES; and restart the docker container and mysql |
|
To expand on @dlen's answer, on MacOSX for those trying to use SequelPro running into this issue: 1.) Open terminal / hyper You can now log into sequel pro with root / password on 127.0.0.1 You may have to run mysql_secure_installation prior to this, to set up your mysql password & restrict external connections to local DB. |
|
tks @gbrits works for me! 👍 |
thanks!!!!!!! it works |
|
Thank you for the resolution. Docker Run Example: Also, if you want to stop the mysqlx from starting, can add |
|
@silentpete what would be the docker-compose equivalent of your docker run example? |
|
@liaogz82, should look something like the below. |
|
if you are facing the 'caching_sha2_password ' problem please go through this |
|
changing mysql version to 5.7 worked like a charm! Thank you |
|
@silentpete really thank you, works and helped a lot. |
|
just use image: mariadb:latest - it will solve the issue |
Nice. thanks . works like a charm |
When using
docker-compose, I get the following error message:I tried using both the
docker-compose-dev.ymlanddocker-compose.ymlfile. Both files use the latest MySQL docker image.Logs of
docker-compose upcommand:The text was updated successfully, but these errors were encountered: