How to Update MySQL to Version 5.7 on a Directadmin Server

By | November 27, 2018

If you have a Directadmin server, you know that you can’t simply install new server software without custombuild. Of course, you can, but it will take too much time to set everything up.

So let’s talk about MySQL update.

cd /usr/local/directadmin/custombuild;
./build set mysql 5.7;
./build set mysql_inst mysql;
./build set mysql_backup yes;
./build update

When it’s done, you will have to

./build mysql
./build php n

And then reboot your web server:

service httpd restart for Apache
service nginx restart for nginx

Now try to start your mysql server:

service mysqld start

I had the following error:

2018-11-27T14:33:01.808513Z 0 [ERROR] unknown variable 'thread_concurrency=8'

If order to fix it, I had to edit /etc/my.cnf to disable thread_concurrency parameter.

Leave a Reply

Your email address will not be published. Required fields are marked *