Home >Database >Mysql Tutorial >Remote connection to mysql under linux under win

Remote connection to mysql under linux under win

黄舟
黄舟Original
2017-03-01 13:39:481100browse




Remote connection to mysql under linux under win

Remote connection to mysql under linux under win

Remote connection to mysql under linux under win

Remote connection to mysql under linux under win

Remote connection to mysql under linux under win

Remote connection to mysql under linux under win














#​## The method is summarized as follows:

I first opened the command prompt and output the following command

###So I wondered, why can't I do what others said? I thought about it for a while, how could there be a mysql command in the win command prompt, and I suddenly cried because of my stupidity. So switch the command to the bin in the mysql installation directory #########Try to connect here #########Why does it still not work? I thought it was because under Linux, the user did not have remote login permissions, so I checked the user permissions #########host was set to %. It stands to reason that any host can connect, so I suddenly remembered Linux firewall, immediately turn off the firewall. #########Connect in the win command prompt again#########Supplement: linux firewall###1. First check the firewall status: ###service iptables status ### It takes effect permanently and will not be restored after restarting ###chkconfig iptables on ###Close: ###chkconfig iptables off ###It takes effect immediately and will be restored after restarting ###Open: ###service iptables start ###Close : ###service iptables stop ###3. Restart after setting: ###reboot###### The above is the content of remote connection to mysql under win under Linux. For more related content, please pay attention to the PHP Chinese website (www. php.cn)! ###############
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:How to use MySQL helpNext article:How to use MySQL help