Table of Contents

MySQL Administration

Restart service

To restart mysql service: 

sudo service mysql restart

Open port

To open MySQL for communication with internet, add following line to file /etc/mysql/my.cnf 

bind-address            = 0.0.0.0

to restrict the communication to localhost only: 

bind-address            = 127.0.0.1