*************** process to change MySql ipaddress to listen for all ip ********
-> update user set Host="%" where User="phpmyadmin";
-> sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf [change "bind-address = 0.0.0.0"]
-> flush privilage
-> check by netstat -nlp | grep 3306 [ouput should be start listen on 0.0.0.0]
-> telnet 192.168.1.19 3306 [now check its connecting or not with the ip]
-> update user set Host="%" where User="phpmyadmin";
-> sudo vi /etc/mysql/mysql.conf.d/mysqld.cnf [change "bind-address = 0.0.0.0"]
-> flush privilage
-> check by netstat -nlp | grep 3306 [ouput should be start listen on 0.0.0.0]
-> telnet 192.168.1.19 3306 [now check its connecting or not with the ip]
.png)
.png)
Note: Only a member of this blog may post a comment.