0

I am using below command on server with ip y.y.y.y to connect to DB hosted on x.x.x.x

mysql -u user -p -h x.x.x.x

I am getting below error, I don't why its picking [email protected] even though I have specified -h option

ERROR 1045 (28000): Access denied for user 'user'@'y.y.y.y' (using password: YES)

Improve this question
2

1 Answer 1

Reset to default
1

Make sure the following things are true:

  • Are your credentials really correct? (Host, User, Password, Database, Port)
  • Does the server allows remote acces (bind adress = x.x.x.xin my.cnf)
  • Can the host be uniquly identified? (See: this SQ questions
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.