Migration assist tool won't connect to MySQL

Troubleshooting Command Line Interface
1

We have a Rhel7 VM running Mattermost Version 5.23.0

It is using MySQL version 5.7.28

I have built a new Rhel9 VM with Mattermost Version 10.10.1

It is using PostgreSQL Version 13.20

I am trying to run the migration-assist tool against the MySQL database. Step 1 shows to run this command to verify the database schema

migration-assist mysql "<MYSQL_DSN>"  # example DSN: "user:password@tcp(address:3306)/db_name"

I have verified the information several times, I can log into the database with the user:password that I am using, but whenever I try to run the command it says:

“An Error Occurred: failed to grab a connection to the database: Error 1405 (28000): Access denied for user

I have even tried running directly on the VM where the database is located.

Any suggestions?

2

Hey @kwkrun did you check MySQL user table to see which addresses are allowed for your user? Sometimes they are getting restricted, even for the localhost connections.

3

Thanks for replying. I should have come back in here and commented. The problem was the password that I was using. I changed to one that had no special characters and then it connected. (strange for password rule)

4

Great to hear, thanks for sharing!