Re: MySQL 5.7 + Windows 10 remote access
Posted by: Luis Serpa
Date: May 07, 2016 10:04AM

Hi

Let me describe what i am working and the test i have done.

I have one pc that is windows 10 pro 64bits. On this pc I need to install and put to work mysql, apache, php and php mysqladmin.

The firewall is disable and the antivirus too.

The name of the pc is VSRVFORIX and the lan ip is 192.168.67.15.

I install mysql 5.7 with the “normal” options and did finish without any error.

Accessing the database.

I am trying to access data, just for testing, using the MySQL workbench or telnet command.


Test 1: host=localhost
Using mysql workbench and root user: ok
telnet command: ok

Test2: host=127.0.0.1
Using mysql workbench and root user: ok
telnet command: ok

Test3: host=VSRVFORIX or 192.168.67.15
Using mysql workbench and root user: Failed to Connect to MySQL at 192.168.67.15:3306 with user root. Host VSRVFORIX is not allowed to connect to this MySQL server
telnet command: Host 'VSRVFORIX' is not allowed to connect to this MySQL server

Test4: host=VSRVFORIX or 192.168.67.15 but using another pc on the local network
telnet command: connection refuse.

Ok. First I don’t know why but this is the first time I am getting any message back in test 2 and 3, the other times just a black screen or timeout like the port wasn’t open.

For what I can see is that the server is not config to allow network connection other than localhost name or ip.

So how can I set the server to “allow” network connection with the root user?

Thx for the help

Best Serpa

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.7 + Windows 10 remote access
9804
May 07, 2016 10:04AM


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.