MySQL setup on IceWarp

Dear users, please find below the essential guide for MySQL setup.

MySQL DBs

Please download the MySQL community server here: http://dev.mysql.com/downloads/mysql/
You will want the 32bit installer it contains both the 32 and 64bit versions.

You will also need to download the C connectors here: https://downloads.mysql.com/archives/c-c/

You will need both the 32bit and 64bit zips. There is a version of libymsql.dll in each archive.

You can download the libraries at the bottom of this article.

The 32bit dll will need to be placed in the /windows/syswow64 folder.

The 64bit dll will need to be placed in the /Windows/System32 folder.

From the Admin console please go to File>API console and filter on mysqldefaultcharset and set the value to utf8mb4.

The following queries can be used to create the databases in the MySQL console.

create database icewarp_accounts DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
create database icewarp_antispam DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
create database icewarp_groupware DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
create database icewarp_dircache DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
create database icewarp_activesync DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
create database icewarp_webcache DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

If you run into an issue during the test connection to MySQL DB, stating 'caching_sha2_password' cannot be loaded, use the following link here to fix it.