MySQL Setup

MySQL is a database application that is very fast and very reliable. You can read more about it by visiting http://www.mysql.com/.


Temporarily start MySQL to secure it:

# service mysql-server onestart


Secure MySQL root user account and delete nameless user(s):

Set the root password and other features. Accepting all the defaults is likely best.

# mysql_secure_installation


Copy MySQL configuration file from example:

# cp /usr/local/etc/mysql/my.cnf.sample /usr/local/etc/mysql/my.cnf


Add MySQL to system startup, and restart it:

# sysrc mysql_enable=YES
# service mysql-server restart


Create and populate Maia-Mailguard database:

# mysql -u root -p mysql
(Enter MySQL root password)
> CREATE DATABASE maia;
> GRANT ALL PRIVILEGES ON maia.* TO vscan@localhost IDENTIFIED BY 'vscan_user_password';
> FLUSH PRIVILEGES;
> QUIT;
# mysql -u vscan -p maia < /usr/local/share/doc/maia/maia-mysql.sql
(Enter "vscan" user's password)

Page 3 or back to Page 1