MariaDB

Развертывание

Systemd

scripts/mysql_install_db --user=mariadb --basedir=/opt/mariadb/5.5.68 --datadir=/opt/mariadb/5.5.68/data

mysql_secure_installation --user=mariadb --basedir=/opt/mariadb/5.5.68 //жестко требует /tmp/mysql.sock

Команды

mysql

mysql --socket=/tmp/mariadb-5-5-68.sock -u root -p

mysql --user=Login --password=Password --database=db_name < db_name.sql

mysql --user=Login --password=Password
>use db_name
>source db_name.sql

mysqldump

mysqldump -u root -p --socket=/opt/socket/mariadb-5-5-68.sock postfix > postfix.sql

Конфигурация

[client-server]
socket=/opt/socket/mariadb/5.sock
bind-address=172.16.0.56
port=3306

[mysqld]
basedir=/opt/mariadb/5.5.68
datadir=/opt/mariadb/data/5
innodb_buffer_pool_size=256M
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2
innodb_file_per_table=1

SQL

CREATE DATABASE newdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
CREATE DATABASE newdb DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;
SHOW DATABASES;

CREATE USER 'admin'@'%' IDENTIFIED BY 'some_pass';
CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'some_pass';

RENAME USER 'abmk'@'localhost' TO 'abmk_old'@'localhost';

SET PASSWORD FOR 'postfix'@'localhost' = PASSWORD('newpassword');
FLUSH PRIVILEGES;

GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON postfix.* TO 'admin'@'localhost' WITH GRANT OPTION;
REVOKE ALL ON * FROM 'ksc'@'%';

SHOW GRANTS FOR 'abmk'@'localhost';
SELECT User, Host FROM mysql.user;