Saturday, March 16, 2019

phpMyPassion

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


About Author -

Hi, I am Anil.

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

Subscribe to this Blog via Email :