Unable to Regenerate MySQL DB password

samueljh1

PROOP

3 months ago

I have tried multiple times to regenerate the MySQL DB password via Database -> Config -> Regenerate Password. Once triggered, the database redeploys and the environment variables update in the Railway console, however when connecting to the DB, the new password does not work and the original one still works.

We need this fixed ASAP.

Thanks in advance.

Solved$20 Bounty

27 Replies

0x5b62656e5d

MODERATOR

3 months ago

Try this:

SSH into your MySQL service (Right click the service and Copy SSH Command) (You'll need Railway CLI installed for this to work)
In the terminal, paste the SSH command and run mysql -u root -p
Enter the current working password
Run the following commands:

ALTER USER 'root'@'localhost' IDENTIFIED BY '';
FLUSH PRIVILEGES;

Where `` is replaced with the new password (From the variable MYSQL_ROOT_PASSWORD

0x5b62656e5d

MODERATOR

3 months ago

This should reset the MySQL's password to use the newly generated password in the variables tab.

samueljh1

PROOP

3 months ago

Thanks - let me give this a try

samueljh1

PROOP

3 months ago

@pepper very odd.. so when running mysql -u root -p, it only acepts the new password, but when connecting externally, this password doesn't work and I can only use the original password

0x5b62656e5d

MODERATOR

3 months ago

External connection requires old password
Root access via SSH uses new password
Current Railway variable is new password
Railway's database UI doesn't connect

0x5b62656e5d

MODERATOR

3 months ago

Is this correct?

samueljh1

PROOP

3 months ago

All correct apart from bottom - railway's database UI connects fine

0x5b62656e5d

MODERATOR

3 months ago

External connection requires old password
Root access via SSH uses new password
Current Railway variable is new password
Railway's database UI does connect -# Oops accidentally deleted old msg

samueljh1

PROOP

3 months ago

Correct

samueljh1

PROOP

3 months ago

I ran the alter user command just now, didn't expect anything to change, and I was correct

samueljh1

PROOP

3 months ago

So it seems the proxy has its own auth system maybe, once its happy with the password received externally it just tunnels the connection thru Railway?

samueljh1

PROOP

3 months ago

That seems like the only logical explanation to the password mismatch

samueljh1

PROOP

3 months ago

@Brody any thoughts?

brody

EMPLOYEE

3 months ago

No need to ping, pepper is handling this.