Home WebServer PanelDirectAdmin How to upgrade MySQL on DirectAdmin with CustomBuild 2.0

How to upgrade MySQL on DirectAdmin with CustomBuild 2.0

by Thạch Phạm
Published: Last Updated on
A+A-
Reset

1. Overview

In today’s article, AZDIGI will most simply and easily detail how to upgrade MySQL on DirectAdmin with CustomBuild 2.0.

When installing DirectAdmin, you only get DirectAdmin to automatically install the MySQL database management system version 5.7, an old version released on October 21, 2015.

The current latest version is 8.0. If you want to use a newer version like 8.0, you must upgrade it manually.

2. Upgrading MySQL on DirectAdmin with CustomBuild 2.0

To upgrade MySQL on DirectAdmin with CustomBuild 2.0, follow these 3 steps.

Step 1: SSH into your DirectAdmin system

First, you need SSH into your VPS/Server as root. You can refer to the following guide:

After successfully SSHing, we continue with step 2 to check the current MySQL version.

Step 2: Check the current version of MySQL in use

To check the current MySQL version, use the command:

AZDIGI Tutorial
mysqld -V

Here are my results, with the currently installed version of 5.7.30.

Screen Shot 2020 07 21 at 11.45.32 PM

Now that you have checked the current version of MySQL in use, we continue with step 3 to upgrade to the latest version.

Step 3: Upgrade MySQL on DirectAdmin with CustomBuild 2.0

First, we need to check if the version of CustomBuild we are using is 2.0 or not. To check the version of CustomBuild you are using, please check out the following short tutorial:

In case your CustomBuild version is lower than 2.0 then you need to upgrade CustomBuild 1.x to 2.0 , you can check out the following tutorial:

After you have upgraded to CustomBuild 2.0, run the following commands to upgrade MySQL on DirectAdmin:

AZDIGI Tutorial
cd /usr/local/directadmin/custombuild
./build update
./build set mysql 8.0
./build set mysql_inst mysql
./build set mysql_backup yes
./build mysql

Explanation of the above commands:

  • Command 1: Move to custombuild folder.
  • Command 2: Update custombuild script.
  • Command 3: Adjust the current MySQL instance configuration to 8.0.
  • Command 4: Use the database management system MySQL (there are 2 options: 1 is MySQL, 2 is MariaDB).
  • Command 5: Adjust the configuration to enable database backup before running the installation command.
  • Command 6: Start reinstalling MySQL under the new configuration.

More information: when I write this article, there was only MySQL 8.0, so when you change it to 8.1, it will not be valid. In the future, it may be after MySQL releases this version. Below is a picture of when I adjusted the version to 8.1. Below is a picture of when I tried to adjust the version to 8.1.

How to upgrade Mysql on DirectAdmin
Version 8.1 is not valid with the install option of MySQL

The installation time will depend on the strength of your VPS/Server and the connection at that time because, in this process, it is necessary to download some quite heavy installation files. The installation process on my VPS 4 CPU Cores is 5 minutes.

Another small note that affects your installation time is that during the installation process, the system will automatically dump all existing databases into a directory to avoid data loss or errors. Therefore, if your VPS/Server has a lot of databases, the installation time will be longer.

To check where the directory containing the database is dumped, use the following 2 commands:

AZDIGI Tutorial
cd /usr/local/directadmin/custombuild
cat options.conf | grep mysql_backup_dir

Here my directory will be /usr/local/directadmin/custombuild/mysql_backups.

How to upgrade Mysql on DirectAdmin

After the installation is complete, the screen will show as below:

How to upgrade Mysql on DirectAdmin

We try to recheck with the mysqld -V to see if we have upgraded to the new version.

How to upgrade Mysql on DirectAdmin

Thus, my VPS has been installed with the new MySQL version 8.0.20.

3. Summary

Through this article, you have learned how to quickly upgrade MySQL on DirectAdmin and the directory containing the databases that were dumped during the installation of the new MySQL version. Hope this article will be of help to you.

Wishing you success.

If you need assistance, you can contact support in the ways below:

Đánh giá

Tham gia nhóm hỗ trợ Server - Hosting

Tham gia nhóm Hỗ trợ Server - Hosting & WordPress để cùng nhau hỏi đáp và hỗ trợ các vấn đề về WordPress, tối ưu máy chủ/server.

Tham gia ngay

Bài viết cùng chuyên mục

AZDIGI – Không chỉ là đơn vị hàng đầu trong lĩnh vực Web Hosting và Máy chủ, chúng tôi mong muốn mang lại những kiến thức bổ ích nhất và luôn cập nhật thường xuyên cho cộng đồng người đam mê thiết kế website, công nghệ,…

Vui lòng không sao chép nội dung nếu chưa xin phép. Designed and Developed by PenciDesign