imported>Admin в 17:23, 16 февраля 2022

2022-02-16T17:23:06Z

Новая страница

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

[[Systemd_-_Service#MariaDB|Systemd]]

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

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

== Команды ==

'''mysql'''

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

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

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

'''mysqldump'''

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

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

[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 ==

<code>CREATE DATABASE newdb DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;</code> 
<code>CREATE DATABASE newdb DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;</code> 
<code>SHOW DATABASES;</code> 
 
<code>CREATE USER 'admin'@'%' IDENTIFIED BY 'some_pass';</code> 
<code>CREATE USER 'db_user'@'localhost' IDENTIFIED BY 'some_pass';</code> 
 
<code>RENAME USER 'abmk'@'localhost' TO 'abmk_old'@'localhost';</code> 
 
<code>SET PASSWORD FOR 'postfix'@'localhost' = PASSWORD('newpassword');</code> 
<code>FLUSH PRIVILEGES;</code> 
 
<code>GRANT ALL PRIVILEGES ON . TO 'admin'@'%' WITH GRANT OPTION;</code> 
<code>GRANT ALL PRIVILEGES ON postfix.* TO 'admin'@'localhost' WITH GRANT OPTION;</code> 
<code>REVOKE ALL ON * FROM 'ksc'@'%';</code> 
 
<code>SHOW GRANTS FOR 'abmk'@'localhost';</code> 
<code>SELECT User, Host FROM mysql.user;</code>

MariaDB - История изменений

imported>Admin в 17:23, 16 февраля 2022