Saturday, March 16, 2019


Process to Change MySql ip-Address to Listen for all IP's

*************** 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 ="]

-> flush privilage

-> check by netstat -nlp | grep 3306 [ouput should be start listen on]

-> telnet 3306 [now check its connecting or not with the ip]

About Author -

Hi, I am Anil.

Welcome to my eponymous blog! I am passionate about web programming. Here you will find a huge information on web development, web design, PHP, Python, Digital Marketing and Latest technology.

Subscribe to this Blog via Email :