To update or upgrade MariaDB on CyberPanel, we must run the following steps. At Bobcares, with our CyberPanel Support, we can handle your issues.

How to Update/Upgrade MariaDB on CyberPanel?

By updating MariaDB on CyberPanel, we can ensure the server runs optimally, securely, and remains compatible with apps like WordPress. Upgrading provides better performance, stability, security, and new features. It also helps address site health issues and aligns with industry standards.

Steps to Update MariaDB on CyberPanel

1. Initially, connect to the server via SSH and retrieve the MySQL password:

cat .db_password

We must note the password displayed.

2. Then, create a backup of all databases:

mysqldump -u root -p --all-databases > databasedump.sql

3. Enter the password when asked.

4. Now, stop the MariaDB service:

systemctl stop mariadb

5. Uninstall MariaDB:

yum remove mariadb mariadb-server

6. Open the MariaDB repository file for editing:

vim /etc/yum.repos.d/MariaDB.repo

7. Update the file with the desired version (e.g., 10.5):

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.5/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

8. Update the yum cache:

yum makecache fast

9. Install the new MariaDB version:

yum install MariaDB-server MariaDB-client

10. Enable and start MariaDB:

systemctl enable mariadb
systemctl start mariadb

11. Secure the MariaDB setup:

mysql_secure_installation

12. Then, we must follow the prompts to set a root password and secure the setup.

13. Check the MariaDB version:

mysql --version

14. Import the database backup:

mysql -u root -p root < databasedump.sql

15. Lastly, restart MariaDB:

systemctl restart mariadb

We must update any relevant configuration files or scripts to ensure compatibility with the new version.

[Need to know more? Get in touch with us if you have any further inquiries.]

Conclusion

By following these steps from our Tech team, we will have successfully updated MariaDB on CyberPanel.