UNIX for Dummies Questions & Answers

Hello,

My manager wanted me to install iRedMail but that was too difficult since I could not find the appropriate documentation. Since I wanted to use Roundcube I went to their website and found the following:

Howto_Install ? RoundCube Webmail

I get stuck at the point where it says:

Database Configuration ¶

Next thing we need to do is decide what database backend we'll use. The most common is MySQL but others are PostgreSQL and SQLite. So once you decide, create a database with any name you want and grant privileges to a separate database user. It's recommended not to use an existing user or root.

With MySQL you can set up the database by issuing the following commands:

Code:

CREATE DATABASE roundcubemail;
GRANT ALL PRIVILEGES ON roundcubemail.* TO username@localhost IDENTIFIED BY 'password';

(of course you have to replace the database, username and password accordingly)

See the INSTALL file for information about setting up PostgreSQL or SQLite

If you are using MySQL, be sure to flush the users privileges when you add a new user or you will get a database connection error:

FLUSH PRIVILEGES;

1) what values for username, password, and database should I use?
2) How do I add a new user in mysql and how would I assign it a password?

Thanks!

I recommend strongly that you might want to install phpmyadmin on your box since it makes your life for some tasks much easier when working with MySQL.

Adding to Zaxxon's reply, you may want to check your Admin Panel and see if there is already a front end for MySQL database management.