Differences

This shows you the differences between two versions of the page.

--- mysql_administration [2017/08/18 08:53] – created kalaschnikow
+++ mysql_administration [2018/04/23 15:57] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
+====== 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>