# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1533158584 -10800
# Node ID 17837e17130b3c295969bb4693ae5ddbc1216522
# Parent  584447bfdc9918ad88015725976b4feccb9c28dd
Allow connection from any host.

diff -r 584447bfdc99 -r 17837e17130b mysql.rst
--- a/mysql.rst	Mon Jul 23 02:04:34 2018 +0300
+++ b/mysql.rst	Thu Aug 02 00:23:04 2018 +0300
@@ -173,3 +173,34 @@
 
   [mysql]> show profile for query 1;
 
+Configuring in Debian
+=====================
+
+After fresh installation login to DB::
+
+  $ sudo mysql -u root
+
+Create database and grant permissions to access from ``localhost``::
+
+  CREATE DATABASE testdb;
+  CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';
+  GRANT ALL PRIVILEGES ON testdb.* TO 'user'@'localhost';
+  FLUSH PRIVILEGES;
+  quit
+
+Replace localhost with arbitrary host name or IP address, or use ``%`` to allow any host::
+
+  CREATE USER 'user'@'192.168.0.1' IDENTIFIED BY 'password';
+  GRANT ALL PRIVILEGES ON testdb.* TO 'user'@'192.168.0.1';
+
+  CREATE USER 'user'@'%' IDENTIFIED BY 'password';
+  GRANT ALL PRIVILEGES ON testdb.* TO 'user'@'%';
+
+Login with client to new database::
+
+  mysql -u user -p
+
+Switch to schema::
+
+  USE testdb;
+