how to allow remote coection to mysql

1. create a coection and user in workbeanch(I mean give the coection other user than root for ex:LaptopOut)

2. open mysql command line

3.then type this command : grant all privileges on *.* to 'LaptopOut'@'192.168.20.50' identified by 'myPass';

note: the myPass can be diffrent from the main password of the coection!

result of the command should be as below :

Query OK, 0 row affected, 1 waing (0.00 sec)

4.then type this command : flush privileges;

result should be as below :

Query OK, 0 rows affected, (0.00 sec)

5.to check if we have access to port 3306 from other system to this :

in second system install telnet and then use this command in the command promt

telnet 192.168.0.20 3306

result is something like below :

5.7.11-logû¿|qtBFRO!☻§♦x]Xp►♥▲-?mysql_native_password!

6.finally you should be able to access to this mysql account via your secound system.

C# و SQL Server نکته های جالب و مهم در ...