How to upgrade mariaDB 10.3 to Mysql 8

Hello,

I believe the following steps should work:

1. create dumps of all DBs
2. remove MariaDB 10.3
3. install MySQL 8
4. import dumps.

Search https://help.directadmin.com/ and forums for more details on each steps, or get someone to do it for you.
 
Code:
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:26--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-server-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:27 ERROR 404: Not Found.


Too many failed attempts with files-de.directadmin.com. Will try a different server.
We'll temporarily try using files.directadmin.com instead

Downloading             mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:29--  https://files.directadmin.com/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 185.42.221.168, 69.162.69.58, 104.128.54.74
Connecting to files.directadmin.com (files.directadmin.com)|185.42.221.168|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:29 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:29--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:29 ERROR 404: Not Found.


Too many failed attempts with files.directadmin.com. Will try a different server.
We'll temporarily try using 69.162.69.58 instead

Downloading             mysql/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:31--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:31 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:31--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:32 ERROR 404: Not Found.


Too many failed attempts with 69.162.69.58. Will try a different server.
We'll temporarily try using files.directadmin.com instead

Downloading             mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:34--  https://files.directadmin.com/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 104.128.54.74, 185.42.221.168, 69.162.69.58
Connecting to files.directadmin.com (files.directadmin.com)|104.128.54.74|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:34 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:34--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:34 ERROR 404: Not Found.



There seem to be many connection issues.  Check your network and /etc/resolv.conf file
Also try finding a faster server: https://help.directadmin.com/item.php?id=305


Downloading             mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:39--  https://files.directadmin.com/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 185.42.221.168, 69.162.69.58, 104.128.54.74
Connecting to files.directadmin.com (files.directadmin.com)|185.42.221.168|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:39 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:39--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:40 ERROR 404: Not Found.

*** Cannot find /usr/local/directadmin/custombuild/mysql/mysql-community-client-8.0.17-1.el8.x86_64.rpm. Aborting ***
 
Got MariaDB 10.4 on CentOS 8 and faced first some issues with importing DBs and changing SQL user's password. I believe the issues will be solved, just give them time for it.
 
Code:
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:26--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-server-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:27 ERROR 404: Not Found.


Too many failed attempts with files-de.directadmin.com. Will try a different server.
We'll temporarily try using files.directadmin.com instead

Downloading             mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:29--  https://files.directadmin.com/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 185.42.221.168, 69.162.69.58, 104.128.54.74
Connecting to files.directadmin.com (files.directadmin.com)|185.42.221.168|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:29 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:29--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:29 ERROR 404: Not Found.


Too many failed attempts with files.directadmin.com. Will try a different server.
We'll temporarily try using 69.162.69.58 instead

Downloading             mysql/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:31--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:31 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:31--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:32 ERROR 404: Not Found.


Too many failed attempts with 69.162.69.58. Will try a different server.
We'll temporarily try using files.directadmin.com instead

Downloading             mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:34--  https://files.directadmin.com/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 104.128.54.74, 185.42.221.168, 69.162.69.58
Connecting to files.directadmin.com (files.directadmin.com)|104.128.54.74|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:34 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:34--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:34 ERROR 404: Not Found.



There seem to be many connection issues.  Check your network and /etc/resolv.conf file
Also try finding a faster server: https://help.directadmin.com/item.php?id=305


Downloading             mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm...
--2019-09-29 21:31:39--  https://files.directadmin.com/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 185.42.221.168, 69.162.69.58, 104.128.54.74
Connecting to files.directadmin.com (files.directadmin.com)|185.42.221.168|:443... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:39 ERROR 404: Not Found.

Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-29 21:31:39--  http://69.162.69.58/services/custombuild/all/mysql/8.0/8.0.17/64-bit/mysql-community-common-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-29 21:31:40 ERROR 404: Not Found.

*** Cannot find /usr/local/directadmin/custombuild/mysql/mysql-community-client-8.0.17-1.el8.x86_64.rpm. Aborting ***

RPMs have been uploaded, so "./build mysql" should work. Regarding MariaDB 10.3 - no easy way to convert to 8.0 if you have data there. If there is no data, you can simply do:
Code:
service mysqld stop
mv /var/lib/mysql /var/lib/mysql_mariadb_103
cd /usr/local/directadmin/custombuild
./build set mysql_inst mysql
./build set mysql 8.0
./build mysql
 
Got MariaDB 10.4 on CentOS 8 and faced first some issues with importing DBs and changing SQL user's password. I believe the issues will be solved, just give them time for it.

The following should be enough to solve it:
Code:
cd /usr/local/directadmin
./directadmin set mysql_detect_correct_methods 1
service directadmin restart
 
@Martynas,

Yes, it has been solved already. Installation has been performed with DirectAdmin license for CentOS 7. Hence it completed with setup.sh script with some issues.
 
Downloaded file /usr/local/directadmin/custombuild/mysql/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm does not exist or is empty after download
cwd is: /usr/local/directadmin/custombuild
Fileserver might be down, using the backup file server..
--2019-09-30 16:28:00-- http://69.162.69.58/services/custom...community-libs-compat-8.0.17-1.el8.x86_64.rpm
Connecting to 69.162.69.58:80... connected.
HTTP request sent, awaiting response... 404 Not Found
2019-09-30 16:28:00 ERROR 404: Not Found.

Downloading mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm...
--2019-09-30 16:28:00-- https://files.directadmin.com/servi...ysql-community-common-8.0.17-1.el8.x86_64.rpm
Resolving files.directadmin.com (files.directadmin.com)... 185.42.221.168, 69.162.69.58, 104.128.54.74
Connecting to files.directadmin.com (files.directadmin.com)|185.42.221.168|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 606672 (592K)
Saving to: '/usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm'

/usr/local/directadmin/custombuild/mysql/mysql-co 100%[==========================================================================================================>] 592.45K --.-KB/s in 0.1s

2019-09-30 16:28:01 (4.63 MB/s) - '/usr/local/directadmin/custombuild/mysql/mysql-community-common-8.0.17-1.el8.x86_64.rpm' saved [606672/606672]

Found /usr/local/directadmin/custombuild/mysql/mysql-community-client-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-devel-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-server-8.0.17-1.el8.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/mysql-community-libs-8.0.17-1.el8.x86_64.rpm
*** Cannot find /usr/local/directadmin/custombuild/mysql/mysql-community-libs-compat-8.0.17-1.el8.x86_64.rpm. Aborting ***
 
Fixed in CB 2.0 rev. 2209.

Code:
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
*********************************

We seem to have an error when trying to SET PASSWORD FOR 'root'@'localhost'

*********************************
Next Error
php 7.3 php-fpm
 
Okay, I think initial installation of MYSQL8 (when /var/lib/mysql is removed) is finally solved :) Use CB 2.0 rev. 2211. Thank you for the report!
 
Another Error :D
1370915699332945292_2019-10-01_16-14-49.png


Code:
error

Error connecting to MySQL: Plugin caching_sha2_password could not be loaded: /usr//usr/lib64/mysql/plugin/caching_sha2_password.so: cannot open shared object file: No such file or directory
 
Back
Top