About creating database

From: Stephen Liu (no email)
Date: Thu Jun 14 2007 - 07:21:38 EDT

  • 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


  • Next message: Mark Watts: "Re: About creating database"





    Hosted Email Solutions

    Invaluement Anti-Spam DNSBLs



    Powered By FreeBSD   Powered By FreeBSD