Create Postfix MySQL DB

Create Postfix DB in MySQL

First, we need to create 1 Postfix DB.
Postfix DB will be used to stored all Postfix users, domains, alias etc..

Login into your server and su with root access.

$mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 290278
Server version: 5.1.45 FreeBSD port: mysql-server-5.1.45

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>create database postfix;
mysql>GRANT ALL PRIVILEGES ON postfix.* TO 'postfix'@'localhost' IDENTIFIED BY 'yourpostfixpassword' WITH GRANT OPTION;
mysql>flush privileges;
mysql>exit

From mysql command above, we have created postfix db, with postfix user and yourpostfixpassword as db password.