MySQL Forums
Forum List  »  Newbie

MySQL can't connect using private IP address
Posted by: Susan Lin
Date: February 28, 2016 01:30PM

0
down vote
favorite
I have a fresh install of MySQL 5.7 on my Windows machine. When I make a connection using root@localhost, I am able to connect, but when i try to make a connection root@192.168.1.10 (the private IP address of my server) I get the following error:

mysql 5.7 access denied for user 'root'@'192.168.1.10'.

I opened my my.ini file and added the line bind-address=0.0.0.0. I saved the file and restart my MySQL instance, but still not luck the same error appears.

I then tried:

**GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;**
This did not work either. I then tried to change the password for root to make sure I was using the correct password:

UPDATE mysql.user SET authentication_string=PASSWORD('password') WHERE User='root';
But no luck.

How can I connect using my private IP address using the root user?

Options: ReplyQuote


Subject
Written By
Posted
MySQL can't connect using private IP address
February 28, 2016 01:30PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.