- 论坛徽章:
- 0
|
在把 postfixadmin 中导进数据库的那个DATABASE_MYSQL.TXT 文件贴出一部分来。这里我一点也没修改。
- [root@mail postfixadmin]# cat DATABASE_MYSQL.TXT
- #
- # Postfix Admin
- # by Mischa Peters <mischa at high5 dot net>
- # Copyright (c) 2002 - 2005 High5!
- # License Info: [url]http://www.postfixadmin.com/?file=LICENSE.TXT[/url]
- # mysql -u root [-p] < DATABASE_MYSQL.TXT
- #
- # Postfix / MySQL
- #
- USE mysql;
- # Postfix user & password
- INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
- INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','postfix','postfix','Y');
- # Postfix Admin user & password
- INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'));
- INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'postfix', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
- FLUSH PRIVILEGES;
- GRANT USAGE ON postfix.* TO postfix@localhost;
- GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfix@localhost;
- GRANT USAGE ON postfix.* TO postfixadmin@localhost;
- GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfixadmin@localhost;
- CREATE DATABASE postfix;
- USE postfix;
复制代码 |
|