Current location - Quotes Website - Collection of slogans - Mysql service and port 3306 of virtual machine linux system have been opened. Why can't it be remote locally?
Mysql service and port 3306 of virtual machine linux system have been opened. Why can't it be remote locally?
1, first execute MySQL-h172.115.123.22-udeve-pdeve [-p3306] in linux, indicating that the network problem is that MySQL can't be started or the deve user doesn't have remote access rights. 2. stop iptables firewall Linux shell >:/etc/init.d/iptables stop3. Check whether mysql processes and ports start Linux shell & gtps-efgrep MySQL Linux shell > Netstat -ntl 4, user Linux shell >: MySQL-uroot-pmysql > Select users and hosts from mysql.user; Mysql & gt creates user deve @ "%"identified by "deve"; Mysql & gt grants full permissions on *. * Develop @ "%"; 5. Use telnet to confirm the access to windows cmd>. Remote login172.115.123.22 3306