In MailSuite Pro, root password for MySQL is predefined and is set to mailbundle. Database server is configured to explicitly disallow external connections, so even if third party knows the password they cannot use it.

However, it's still a good idea to change root MySQL password from a default value. And since it's stored in multiple locations and configuration files, it's important to go through all of them.

Below, I will use 3Th43jypQWy5 as a sample password. Naturally, you should use your actual password there.

MySQL root password change

mysql -uroot -pmailbundle
ALTER USER 'root'@'localhost' IDENTIFIED WITH caching_sha2_password BY '3Th43jypQWy5';
FLUSH PRIVILEGES;

Press Ctrl-D to leave the console. From that moment forward, you already have a new root MySQL password, now make sure it's updated in the product configuration.

If you wish to confirm the password has actually been changed, try to log into MySQL console with:

mysql -uroot -p3Th43jypQWy5

Admin interface

Log into /adminpanel/ of your MailSuite Pro installation. Under "Database settings" tab, supply a new password. Be sure to press Save button to apply changes.

Alternately, you can edit "DBPassword" value in /opt/afterlogic/html/data/settings/config.json file.

Dovecot configuration

1. /etc/dovecot/dovecot-sql.conf file:

connect = host=/var/run/mysqld/mysqld.sock    dbname=afterlogic user=root password=mailbundle

Modify as follows:

connect = host=/var/run/mysqld/mysqld.sock    dbname=afterlogic user=root password=3Th43jypQWy5

2. /etc/dovecot/dovecot-user-quota-dict.conf file:

connect = host=/var/run/mysqld/mysqld.sock dbname=afterlogic user=root password=mailbundle

Modify as follows:

connect = host=/var/run/mysqld/mysqld.sock dbname=afterlogic user=root password=3Th43jypQWy5

Exim configuration

/etc/exim4/exim4.conf file:

hide mysql_servers = localhost::(/var/run/mysqld/mysqld.sock)/afterlogic/root/mailbundle

Modify as follows:

hide mysql_servers = localhost::(/var/run/mysqld/mysqld.sock)/afterlogic/root/3Th43jypQWy5

Applying changes

service dovecot restart
service exim4 restart