PostFix и MySQL
// Подключиться к базе привилегированным пользователем
# mysql --user=sysdba --password=mypass
CREATE USER postfix@localhost IDENTIFIED BY 'mypassword';
CREATE DATABASE postfix;
GRANT ALL PRIVILEGES ON postfix.* TO postfix;
quit;
Вот такой скрипт:
# cd /tmp/
# wget -O postfix_mysql_init_script.sql https://github.com/sysadm-ru/Mail.CONF/raw/master/opt/mysql_dump.sql
# mysql --user=postfix --password=mypassword postfix < /tmp/postfix_mysql_init_script.sql
# mysql --user=postfix --password=mypassword postfix
mysql> SHOW FULL TABLES;
+-----------------------+------------+
| Tables_in_postfix | Table_type |
+-----------------------+------------+
| admin | BASE TABLE |
| alias | BASE TABLE |
| alias_domain | BASE TABLE |
| domain | BASE TABLE |
| fetchmail | BASE TABLE |
| mailbox | BASE TABLE |
| quota | BASE TABLE |
| quota2 | BASE TABLE |
| vacation | BASE TABLE |
| vacation_notification | BASE TABLE |
+-----------------------+------------+
10 rows in set (0.00 sec)