How to update the MySQL in DirectAdmin panel?

[Christian J]

Hello,

I want to update MySQL for better security and performance. Can anyone assist me with how to update MySQL in the DirectAdmin control panel?

[Rex Maughan]

Hello Christian J,


If your server has DirectAdmin installed as the control panel with the CustomBuild plugin, you can easily update your MySQL to the latest version.

However, you can follow the steps below to update MySQL in the DirectAdmin panel,

• Firstly, ensure to create full backups of all databases before doing any changes in the MySQL update.
• Now, you can easily update the MYSQL version in DirectAdmin through CustomBuild.
• Then, navigate to the custombuild folder,

# cd /usr/local/directadmin/custombuild

• Next, you need to edit the options.conf file and set the below entries:

# Possible values - 5.0, 5.1, 5.5, 5.x
mysql=5.1 >> The set value, which MYSQL version to update.
mysql_inst=yes
mysql_backup=yes

• Now, save the above file and build MySQL using the following command,

# ./build mysql

• Lastly, after the mysql update, you must recompile php using the below command,

# ./build php n

Thus, I hope the above method helps you to update MySQL in the DirectAdmin panel. However, If you encounter any issue while updating MySQL, you can update it here.

------------------------
Regards,
Rex Maughan