Allow connection from any host.
--- 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;
+