MySQL Root User IPv6 Access Denied Issue

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

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,

$10 Bounty

1 Replies

dardameiz
PRO

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


Loading...