MySQL

MySQL Dump/Restore bazy
mysql> CREATE DATABASE sales;
mysql> quit;
$ mysql -u root -p sales  /path/to/sales-backup-file.sql
mysql --user=root --password=321 --databases egroupware  /srv/.backup/mysql/2012-08-04_15-43-egroupware.dumpPołączenie z hosta
 mysql -u root -p
mysql> CREATE USER 'monty'@'localhost' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'monty'@'%' IDENTIFIED BY 'some_pass';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
    ->     WITH GRANT OPTION;
mysql> CREATE USER 'admin'@'localhost';
mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
mysql> CREATE USER 'dummy'@'localhost';CREATE USER 'egroupware'@'localhost' IDENTIFIED BY '123';
CREATE USER 'tester'@'localhost' IDENTIFIED BY 'testBS';
GRANT ALL PRIVILEGES ON egroupware.* TO 'egroupware'@'localhost' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON test.* TO 'tester'@'localhost' WITH GRANT OPTION;
MariaDB [(none)]> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| drupal-user        |
| information_schema |
| mysql              |
| performance_schema |
+--------------------+
4 rows in set (0.01 sec)
MariaDB [(none)]> SHOW DATABASES LIKE 'm%';
+---------------+
| Database (m%) |
+---------------+
| mysql         |
+---------------+
1 row in set (0.00 sec)