a month ago
Hello Railway team,
The Railway MySQL Database UI fails to connect with:
Access denied for user 'root'@'127.0.0.1' (using password: YES)
However, the database connection is fully functional:
- Laravel connects successfully via mysql.railway.internal:3306
- SQL queries work from the application container
- Direct MySQL client connection works from the application container
- Only the Railway MySQL Database UI fails through the SSH tunnel
I verified:
- DB::select('SHOW TABLES') returns my tables
- mysql -h mysql.railway.internal -P 3306 -u root -p connects successfully
The issue appears to be related to the Database UI SSH tunnel using 127.0.0.1 instead of the internal MySQL connection.
Project: respectful-creation
Environment: production
MySQL Service: bd5d68ac-425b-456e-9a08-36e8b06306af
MySQL image: mysql:9.4
Region: sfo
Please investigate the SSH tunnel / Database UI connection.
Thank you.
1 Replies
a month ago
This thread has been opened as a bounty so the community can help solve it.
Status changed to Open Railway • about 1 month ago
a month ago
Try this:
- Remember the current Custom Start Command
- Change the Custom Start Command to
docker-entrypoint.sh mysqld --skip-grant-tables --skip-networkingand redeploy - Go to the console tab of your MySQL service
- In the terminal, run
mysql -u root - Run the following commands:
ALTER USER 'root'@'localhost' IDENTIFIED BY '<PASSWD>';
ALTER USER 'root'@'%' IDENTIFIED BY '<PASSWD>';
FLUSH PRIVILEGES;Where <PASSWD> is replaced with the new password (From the variable MYSQL_ROOT_PASSWORD)
- Revert the custom start command and redeploy MySQL
- Make sure to restart other services that depend on your MySQL database