MBF Knowledge Base

How to create a database in Squirrelmail

First you need to create a database and a database user with access to SELECT, INSERT, UPDATE,

and DELETE in that database. For MySQL you would normally do something like:

    mysql> CREATE DATABASE squirrelmail;
    mysql> GRANT select,insert,update,delete ON squirrelmail.*
           TO squirreluser@localhost IDENTIFIED BY 'sqpassword';

Note that MySQL changed its password handling in 4.1, so you might need to force the password to be

in the older form. See the MySQL 4.1 manual for more information.

     mysql> SET PASSWORD FOR 'squirreluser' =
    OLD_PASSWORD('sqpassword');