2 months ago
Hello Railway Support Team,
I'm experiencing an issue with my MySQL service on Railway. The root user cannot connect from IPv6 addresses, which is causing connection pool failures in my Deno application.
Problem Details:
Service: MySQL service (MySQL-SBor)
Error: Access denied for user 'root'@'[IPv6 address]' (using password: YES)
First connection succeeds, but subsequent connections from the connection pool fail
The MySQL service shows "IPv4 & IPv6" support in Private Networking settings
My application uses the Deno MySQL library which uses connection pooling
Hostname: mysql-sbor.railway.internal
What I've Tried:
Recreated the MySQL service
Verified all environment variables are correctly set (MYSQLHOST, MYSQLPORT, MYSQLDATABASE, MYSQLUSER, MYSQLPASSWORD)
Confirmed the first connection works, but pool connections fail
Found a similar issue in the Railway forum (https://station.railway.com/questions/access-denied-for-user-root-100-64-0-5b111b89) where users experienced access denied errors
Request:
Could you please grant the root user access from all hosts (including IPv6 addresses) on my MySQL service? This is preventing my application from running migrations and executing queries properly. The forum discussion mentioned recreating the volume as a solution, but this would destroy existing data, which I'd like to avoid.
Service Details:
Project: [Your project name]
MySQL Service: MySQL-SBor
App Service: deno
Thank you for your assistance!
Best regards,
1 Replies
2 months ago
Connect via TCP proxy using a database GUI and run:
CREATE USER IF NOT EXISTS 'root'@'%' IDENTIFIED BY 'your_password';
GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;
The % wildcard covers both IPv4 and IPv6