1. create a connection and user in workbeanch(I mean give the connection 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 connection!
result of the command should be as below :
Query OK, 0 row affected, 1 warning (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 نکته های جالب و مهم در ...
ما را در سایت C# و SQL Server نکته های جالب و مهم در دنبال می کنید
برچسب : نویسنده : alinaiemabadio بازدید : 136 تاريخ : جمعه 24 آذر 1396 ساعت: 3:10