mysql.rst
changeset 2260 17837e17130b
parent 2228 837f1337c59b
child 2266 373af6f0e7f8
--- 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;
+