====== MySQL Administration ======

===== Restart service =====

To restart mysql service:
<code>
sudo service mysql restart
</code>

===== Open port =====

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

<code>
bind-address            = 0.0.0.0
</code>

to restrict the communication to localhost only:

<code>
bind-address            = 127.0.0.1
</code>