Home > Database > Mysql Tutorial > body text

Remote connection to mysql under linux under win

黄舟
Release: 2017-03-01 13:39:48
Original
1040 people have browsed it




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)! ###############
Related labels:
source:php.cn
Statement of this Website
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
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!