Issue with MySQL Version on Railway
Dear Development Team,
I hope this message finds you well. I would like to report an issue I am facing regarding the MySQL version in the Railway environment.
Currently, I am working on a project that involves setting up a MySQL database hosted on Railway. However, I am encountering difficulties in modifying the MySQL version to align with the project's requirements.
My preferred database management tool, MySQL Workbench, requires a specific MySQL version to function correctly. Although I have the latest version of MySQL Workbench installed, the MySQL version on Railway appears to be incompatible.
Upon attempting to connect, I received the following error message:
"18:04:50 [ERR][ WBContext]: Unsupported server version: MySQL Community Server - GPL 8.1.0"
I have attempted to explore the available options within Railway to update the MySQL version, but I did not find a straightforward way to do so. I have also considered the possibility of using other database management tools, but I would prefer to continue using MySQL Workbench as I am more familiar with it.
I would like to inquire if there is any solution available to update or modify the MySQL version in the Railway environment to a version compatible with MySQL Workbench. Alternatively, I would appreciate guidance on best practices or alternatives to address this issue.
I appreciate your assistance in advance.
Sincerely,
10 Replies
Project ID:
N/Awhat specific version do you want
I need a version of MySQL that is compatible with MySQL Workbench 8.0.34
yeah but what versions are compatible and out of those versions, what version do you want to use yourself
For my application and based on my requirements, I would like to use MySQL Server version 8.0 because it is compatible with MySQL Workbench 8.0.34, as recommended.
https://www.mysql.com/support/supportedplatforms/workbench.html
sounds good
deploy this template into your pre-existing project
https://railway.app/template/mysql
remove the docker image source from its settings
replace it with this docker image
mysql:8.0
and there you go, mysql version 8.0 on railway
note, this template is not the same as the databases from the databases menuThank you for the support so far. Now, I am facing an issue when trying to connect to the MySQL server from MySQL Workbench. The error message I'm receiving is as follows:
"Cannot connect to the database server
Your connection attempt failed for user 'root' to the MySQL server at containers-us-west-143.railway.app:3306
Unable to connect to localhost."
This error message indicates that there was a connection attempt failure to the MySQL server at the address "containers-us-west-143.railway.app" on port "3306" using the username "root."
I've already checked a few things such as user credentials, server MySQL status, and user permissions, but I still haven't been able to resolve the issue.
Project ID e0f544ce-00a8-4174-bece-971c7837ecea
just by the host in your error message i know you aren't using the template i linked
you wanted to run a mysql 8.0 server, and I have provided instructions for that
I followed your guidance, and I received the following message in the Deploy logs:
Cannot boot server version 80034 on data directory built by version 80100. Downgrade is not supported.
Any suggestions?
Project ID: 0571a71a-1895-4d3a-b81b-ca909f85e09e
delete the mysql service
deploy this template into your pre-existing project
https://railway.app/template/mysql
immediately abort the first deployment as fast as possible
remove the docker image source from its settings
replace it with this docker image
mysql:8.0
and there you go, mysql version 8.0 on railway
please read over the new procedure