Question Install Plesk with default MySQL Database instead of MariaDB

[AK_learner]

Server operating system version

Windows Server OS (2016 and above)

Plesk version and microupdate number

18.0.78 #3

Hi all,

I want to configure MySQL (8 or 8.4) as the default database instead of MariaDB, what is the procedure for this:

• On existing Plesk installation.
• On a Fresh installation, where Plesk has not been installed yet.

OS: Windows

@Sebahat.hadzhi @IgorG any input from your end?

 

[scsa20]

Plesk stopped distributing Oracle MySQL because of MySQL licensing legal aspects stuff. There is a work around but it's only supported on Windows Server 2012 and 2016. You can learn more at:

https://support.plesk.com/hc/en-us/articles/12387712742423-Is-it-possible-to-install-MySQL-5-7-by-default-in-Plesk-Obsidian-for-Windows

The prefer method, if you want to use MySQL, is to install MySQL afterwards and add it as a secondary database to select from.

 

[AK_learner]

Hi @scsa20

Thank you for sharing this. Yes I had gone through it, but that's why my query was there.

However, if I change the default MariaDB to 3307 & set MySQL to 3306, then installation of SpamAssassin breaks, because its still trying to connect to default 3306 port, which I have now given to MySQL instead of MariaDB.

Any idea?

Installation started in background
Determining the packages that need to be installed.
Downloading file pool/release/PLESK-WIN_18.0.78_19098/dist-windows/spamassassin.msi: completed.
Installing packages
Installing SpamAssassin...
MSI: Error! Critical action 'Creating bayes database...' failed:
Command "C:\Program Files (x86)\Plesk\admin\bin\local_mysql_helper.exe" --create-database-and-user -database sa_bayes -database-user sa_bayes -database-user-password * failed with code 1. Output: mysqlmng failed: Failed to connect to database: Plugin caching_sha2_password could not be loaded: The specified module could not be found. Library path is 'caching_sha2_password.dll'
at (MySQLDatabaseProvider::connect line 512)
at Unable to call connect(localhost, mysql, local_mysql_root, 3306, )(MySQLDatabaseProvider::connect line 521)
at Unable to execute console command: '--exist-user'(vconsoleapp::start line 95)
at Unable to execute command: '"C:\Program Files (x86)\Plesk\admin\bin\mysqlmng" --exist-user "--user-login=sa_bayes"'(vconsoleapp::run line 117)
(Error code 1)



at (CmdAction::Commit line 389)
at Execute action Creating bayes database...(executeList line 269)
Failed to install 'C:\ProgramData\Plesk\Installer\cache\pool\release\PLESK-WIN_18.0.78_19098\dist-windows\spamassassin.msi': Fatal error during installation. (Error code 1603)
Sub-action 'InstallMsiPackage' failed with error code: 1603(0x00000643)
Launching component and product checkers...
Downloading file pool/release/PLESK-WIN_18.0.78_19098/reportupdate.exe: 0%
Downloading file pool/release/PLESK-WIN_18.0.78_19098/reportupdate.exe: 100% was finished.
Error: The installation of the package 'spamassassin' failed with code 1603. (install: Installing SpamAssassin...)
Not all packages were installed.
Visit https://support.plesk.com/ to search for a solution.

 

[scsa20]

Yes this is because it is expecting MariaDB to be running on the default port 3306. What you should be doing is leaving MariaDB's settings alone since that's how Plesk is going to be running everything and instead set MySQL to be running on port 3307.