Page MenuHomePhabricator

Difficulty accessing mysql through server
Closed, ResolvedPublic

Description

Hi Dallas,

I was trying to get on to the server to pull some data that only refreshes once a day in Superset. Erin showed me a workaround to get into mysql that worked yesterday, but isn't working today.

Here are the steps I'm taking:
ssh frdev1001
Enter password via Yubikey
cat .my.cnf [gives user name and password]
mysql -u Murthy -p -h frdb1003 [will prompt for password; use password given from line above]

Here is the error message I receive: ERROR 1045 (28000): Access denied for user 'Murthy'@'[I assume my IP Address is here]' (using password: YES)

Do you know what's going on here, or if I should be accessing this a different way? Thanks for your help.

Event Timeline

RMurthy created this task.Dec 4 2020, 1:26 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptDec 4 2020, 1:26 AM

@RMurthy Your username for MySQL should be rmurthy. So you could use this for the last mysql command: mysql -u rmurthy -p -h frdb1003

However, since you have the .my.cnf file in place, it should read that config file automatically and the last two steps could be condensed to just: mysql -h frdb1003

This seems to have resolved itself -- thanks Dallas! We can close out.

RMurthy closed this task as Resolved.Dec 4 2020, 10:52 PM