Summary Using a different instance of MySQL (in the same place, with the same data files) seems to stop the Mattermost server container from starting. Steps to reproduce I’m using Mattermost 9.1.2 installed on Kubernetes using the mattermost-operator, with (formerly) a MySQL instance installed vi…

Support for MySQL has been deprecated. I strongly recommend you try again with PostGreSQL.

I’ve been giving this a try (following the procedure given here to migrate the existing data - Migration guidelines from MySQL to PostgreSQL — Mattermost documentation ), and while I have the new db up and running, unfortunately pgloader doesn’t work for me as the old database was running on MySQL 8.…

I noticed this post asking the same question, maybe the answer is in there :slight_smile: [image] Migration from MySQL 8 to Postgres Database Troubleshooting Hi @gdelia-pm , glad that you worked it out. I actually lost track of it, but I restarted the migration from the beg…

If that doesn’t help, it was suggested that you compile pgloader yourself from source.

Already did, alas. :person_shrugging: The problem I’m having is that pgloader can’t log in to MySQL 8. (It’s this error - QMYND:MYSQL-UNSUPPORTED-AUTHENTICATION attempting to load data from mysql 8.0.4-rc. · Issue #782 · dimitri/pgloader (github.com) and setting up the old native authentication doe…

Hey @cerebrate - Have you set default-authentication-plugin=mysql_native_password in your mysql.cnf? If you have any existing user, then it might be worth doing a ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'mostest'; and then retry. Following those steps and compiling pgloader…

Yes, both - and confirmed that was working by forcing a test login using mysql_native_password. Unfortunately, even compiled from source, pgloader still wouldn’t connect to the db. :frowning: At this point, I’ve had to give up on the database migration (we can’t afford the downtime), and am hoping …

Sorry to hear that. What OS are you using?

Mattermost and the databases are/were hosted on Kubernetes (k3s) running on Debian bookworm nodes. My management machine is also Debian bookworm.

Server container won't start after switching database

Troubleshooting

john.oliver (John Oliver) December 4, 2023, 3:33pm 4

I noticed this post asking the same question, maybe the answer is in there

Topic		Replies	Views
Migrating Mattermost Database from MySQL to PostgreSQL (using pgloader) Upgrade	2	336	October 30, 2025
Update My SQL a Postgre	8	168	November 26, 2025
Migration from MySQL 8 to Postgres Database Troubleshooting	22	5739	February 8, 2024
[Solved] Can't migrate 10.0.0 from MySQL 8.4 to Postgres due to MySQL auth changes Troubleshooting	3	2206	October 1, 2024
Self-hosted MySQL to PostgreSQL migration	0	717	August 3, 2023

Server container won't start after switching database

Related topics