Lars Hedquist wrote:

mysql -u root -p < sql/mysql/create_tables.mysql"

... I did EXACTLY this, but I guess it means that you need to do:

% mysql -u root -p
mysql> CREATE DATABASE DBMAIL;
Query OK, 1 row affected (0.11 sec)

.. But then what do I do to CREATE TABLE?


create_tables.mysql does create the required database dbmail. If it doesn't it should have barfed.

Also you will have to grant access to the dbmail user specified in dbmail.conf on the tables in the dbmail database.

%> grant all on dbmail.* to [EMAIL PROTECTED] identified by 'somepassword';

or something along those lines.

--
  ________________________________________________________________
  Paul Stevens                                  mailto:[EMAIL PROTECTED]
  NET FACILITIES GROUP                     PGP: finger [EMAIL PROTECTED]
  The Netherlands________________________________http://www.nfg.nl

Reply via email to