MariaDB On a AWS AMI

turingmachine

• December 19, 2023 22:22

Hi All,

I have installed AlmaLinux AMI on AWS EC2 instance. Despite several attempts, I always ended up with only MYSQL 8 database server. The MariaDB update/change is not available on WHM menu also.

Any ideas how to proceed?

• 

  quietFinn

  • December 19, 2023 23:56

  https://docs.cpanel.net/installation-guide/customize-your-installation/#the-mysql-version-key

   

  1
• 

  turingmachine

  • December 20, 2023 20:10

  Dear quietFinn,

  Thanx for the help.

  It worked for me.

  1
• 

  turingmachine

  • December 20, 2023 00:37

  Hi,

  The problem with AMI is that it starts installation after first ssh login that gives no option to change mysql version key as described in https://docs.cpanel.net/knowledge-base/web-services/launch-an-aws-ami-instance/

  Regards..

  0
• 

  quietFinn

  • December 20, 2023 01:08

  If it's a fresh install without databases you can try this:

  1. You start with yum remove mysql in Terminal, finish removing it 
  2. You move the current /var/lib/mysql to /var/lib/mysql.old or delete, but moving is always better 
  3. Edit the /var/cpanel/cpanel.config from mysql-version=8.0 to mysql-version=10.3 
  4. from the command line run: whmapi1 --output=jsonpretty start_background_mysql_upgrade version='10.3'

   

  0

Please sign in to leave a comment.