Skip to content
mysql connection issue
tamil2910
OP

4 months ago

Railway MySQL service cannot authenticate.

Railway Database UI:

Access denied for user 'root'@'127.0.0.1'

External mysql client:

ERROR 1045 (28000): Access denied for user 'root'@'100.64.0.12'

Password is copied directly from Railway Connect page.

The problem started after upgrading MySQL 9.4 -> 9.7.

Solved$10 Bounty

Pinned Solution

Try this:

  1. Remember the current Custom Start Command
  2. Change the Custom Start Command to docker-entrypoint.sh mysqld --skip-grant-tables --skip-networking and redeploy
  3. Go to the console tab of your MySQL service
  4. In the terminal, run mysql -u root
  5. 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)

  1. Revert the custom start command and redeploy MySQL
  2. Make sure to restart other services that depend on your MySQL database

1 Reply

Railway
BOT

4 months ago

This thread has been opened as a bounty so the community can help solve it.

Status changed to Open Railway • 4 months ago


Try this:

  1. Remember the current Custom Start Command
  2. Change the Custom Start Command to docker-entrypoint.sh mysqld --skip-grant-tables --skip-networking and redeploy
  3. Go to the console tab of your MySQL service
  4. In the terminal, run mysql -u root
  5. 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)

  1. Revert the custom start command and redeploy MySQL
  2. Make sure to restart other services that depend on your MySQL database

Status changed to Solved 0x5b62656e5d • 26 days ago


Welcome!

Sign in to your Railway account to join the conversation.

Loading...