Allow connection from any host.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Thu, 02 Aug 2018 00:23:04 +0300
changeset 2260 17837e17130b
parent 2259 584447bfdc99
child 2261 4bed6a795dfe
Allow connection from any host.
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;
+