You can only connect to MySQL Server from localhost after MySQL installation by default, but in production, all MySQL clients remotely connect to server, for simulating real production environment in your home network, some configurations need to be made to be able to let you connect MySQL from client machine other than localhost.
Revise or create MySQL configuration file (RHEL or Centos 7)
Modify or create /etc/my.cnf file
1
vim /etc/my.cnf
add a configuration item bind-address and let it value to be your MySQL server host ip address (eg. 192.168.1.114)
