Next message: Mark Watts: "Re: About creating database"
Hi folks,
OpenBSD 4.0 x86_64
Postfix-2.4.3
Mysql
($ mysql --version
mysql Ver 14.12 Distrib 5.0.24a, for unknown-openbsd4.0 (x86_64) using
readline 4.3)
According to;
http://www.postfixvirtual.net/postfixconf.html#postfix
I issued following SQL commands to create a database named "mail" and a
user "vmailuser" with password "password123"
$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7 to server version: 5.0.24a-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> CREATE DATABASE mail;
Query OK, 1 row affected (0.03 sec)
mysql> GRANT all privileges on mail.* TO vmailuser at localhost IDENTIFIED
BY 'pass
word123' ;
Query OK, 0 rows affected (0.03 sec)
mysql> GRANT all privileges on mail.* TO vmailuser at 127 dot 0 dot 0 dot 1 IDENTIFIED
BY 'pass
word123' ;
Query OK, 0 rows affected (0.00 sec)
mysql> use mail;
Database changed
mysql> show tables;
Empty set (0.03 sec)
mysql> \q
Bye
* end *
No complaint indicated.
Coming to "Create SQL FILE", on which directory shall I create the file
"postfix_virtual.sql" so that it can be evoked on running;
# mysql -u root -p < postfix_virtual.sql
What shall be its owner and permission ???
I'll copy the script there on the file. UID and GIU are 2007.
Please advise. TIA
What other attention I have to pay ???
B.R.
Stephen Liu
Send instant messages to your online friends http://uk.messenger.yahoo.com
