176 Configuring in Debian

   177 =====================

   178 

   179 After fresh installation login to DB::

   180 

   181   $ sudo mysql -u root

   182 

   183 Create database and grant permissions to access from ``localhost``::

   184 

   185   CREATE DATABASE testdb;

   186   CREATE USER 'user'@'localhost' IDENTIFIED BY 'password';

   187   GRANT ALL PRIVILEGES ON testdb.* TO 'user'@'localhost';

   188   FLUSH PRIVILEGES;

   189   quit

   190 

   191 Replace localhost with arbitrary host name or IP address, or use ``%`` to allow any host::

   192 

   193   CREATE USER 'user'@'192.168.0.1' IDENTIFIED BY 'password';

   194   GRANT ALL PRIVILEGES ON testdb.* TO 'user'@'192.168.0.1';

   195 

   196   CREATE USER 'user'@'%' IDENTIFIED BY 'password';

   197   GRANT ALL PRIVILEGES ON testdb.* TO 'user'@'%';

   198 

   199 Login with client to new database::

   200 

   201   mysql -u user -p

   202 

   203 Switch to schema::

   204 

   205   USE testdb;

   206