Beta Test: Mysql 8 Support in debian 9 fresh install and Vesta Patch

[skamasle]

Hi

Leer en español / In spanish -> Clic Aquí

I Do some test on new fresh debian 9 install

Is some body also want test, the procedure is very easy,

Create new droplet / VPS / Server with debian 9

THIS IS NOT OFFICIAL - SO VESTA NOT SUPPORT THIS FOR NOW, IS JUST FOR TEST AND DEBUG

Before install vestacp add new mysql 8 repos:

Code: Select all

wget https://dev.mysql.com/get/mysql-apt-config_0.8.10-1_all.deb

Code: Select all

dpkg -i mysql-apt-config_0.8.10-1_all.deb

Now, install vestacp as always

This will install vesta with mysql 8.x

Code: Select all

~# mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 31
Server version: 8.0.13 MySQL Community Server - GPL

Of course with this you cant add working database, you need fall back plugin authentication

Add to my.cnf in [Mysqld] secction this line:

Code: Select all

default_authentication_plugin=mysql_native_password

Then restart mysql and apply this patch to vestacp;

https://github.com/serghey-rodin/vesta/pull/1805/files
https://github.com/serghey-rodin/vesta/pull/1806/files

If you found some bug let me know to investigate it