Windows login MySQL database with host name error resolution

Share a small case in a job: Windows hosts use SQLyog to log in to the MySQL database (built on a Linux system), resulting in an error, as they often use host names on Windows to access resources, Telnet, and so on. Thought Linux should also be possible, so began to study. By finding information and helping the parties to finally solve and figure out why. I hope you will not repeat the same.

failure: Login to MySQL using hostname on Windows Server The following error occurred, hostname "TEST-AA-SHOP1" Ping does not pass, but corresponding IP can be ping -pass.

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M02/77/ED/wKioL1ZxNULwgjUEAAH37IAE-nc104.jpg "title=" 2ddd.tmp.jpg "alt=" Wkiol1zxnulwgjueaah37iae-nc104.jpg "/>

650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>

Failure Analysis:Windows can access each other with hostnames because NetBIOS is automatically installed by default on the Windows operating system after the TCP/IP protocol is installed. Using computer name communication on the network is the use of the NetBIOS protocol. NetBIOS principle: In a TCP/IP network, computers have names for people to use, but computers typically use IP addresses and hardware addresses to communicate. In NetBEUI, IP addresses are not used, only names and hardware addresses are used. Linux does not support this protocol. In Linux, netbi0s and Neteui do not exist, and Samba assumes the responsibility of SMB/CIFS protocol and NetBIOS implementations. If you want to implement Linun and Windows resource access, you can install Sanmba, but there is currently no plan to access the Linux hostname directly across systems with Windows.

Solution:

1.       If the individual wants to temporarily resolve the windows

2. build Dns According to the machine system classification of LAN, write batch processing bat script, execute bat file modified Host writing revision Hosts file document, mail sent to the person who needs to modify hosts

Thank you he for the help of God!

Windows login MySQL database with host name error resolution