remote connection to a mysql db fail

Asked Apr 03 '14 at 12:09

Active Dec 13 '16 at 19:43

Viewed 236 times

I wan't to establish a remote connection from PC#2 to a database in PC#1.

PC1:

setup mysql server and workbench.
Set password to the root user, UPDATE mysql.user SET Password = Password('123') WHERE user = 'root';
GRANT ALL PRIVILEGES ON . TO 'root'@'%' IDENTIFIED BY '123';
Create database CREATE DATABASE my_test;
CREATE TABLE info (id int(11), name nvarchar(50));
from ipconfig in cmd get my_ip
Edit my.ini add # bind-address= "my_ip"
from firewall inbound role open 3306.

PC2:

setup mysql server and workbench.
Connect to that my_test: workbench: hostname = my_ip, password = 123, Username = root cmd: mysql -u root -h my_ip -p 123 connection string: Server=my_ip;Port=3306;Database=my_test;UID=root;PWD=123;

and it gives me a jit error :

MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.

also from cmd in PC#2 :

mysql -u root -h MyIp -p

Error 2003 Can't connect to Mysql server on "myIp"

i can't understand why i can't do it i did ask the same question over and over:

i also followed this videos step by step and still get the same errors:

edited May 23 '17 at 12:32

Community

asked Apr 03 '14 at 12:09

Maged E William

1

You need to pass the IP of PC1 not PC2 to the connection. The database is on PC1, right? – Steve Apr 03 '14 at 12:15
okay right i was passing the wrong ip then – Maged E William Apr 03 '14 at 12:17
1

Firewall on port 3306? – Steve Apr 03 '14 at 12:23
on what pc, and is it inbound or outbound rule? – Maged E William Apr 03 '14 at 12:29
on pc1 inbound.... it should accept calls on that port coming from your local network – Steve Apr 03 '14 at 12:35
did it now, but still the same result – Maged E William Apr 03 '14 at 12:39
it takes longer but eventually the same error – Maged E William Apr 03 '14 at 13:28
1

Point 8. It is a typo? Default port is 3306 not 4066 – Steve Apr 03 '14 at 13:54

0 Answers0