How to upgrade mariaDB 10.3 to Mysql 8

zEitEr

Super Moderator
Joined
Apr 11, 2005
Messages
13,870
Location
GMT +7.00
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.
 

Networkfa

Verified User
Joined
Mar 20, 2019
Messages
14
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 ***
 

zEitEr

Super Moderator
Joined
Apr 11, 2005
Messages
13,870
Location
GMT +7.00
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.
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,340
Location
LT, EU
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
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,340
Location
LT, EU
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
 

zEitEr

Super Moderator
Joined
Apr 11, 2005
Messages
13,870
Location
GMT +7.00
@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.
 

Networkfa

Verified User
Joined
Mar 20, 2019
Messages
14
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/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-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/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... 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 ***
 

Networkfa

Verified User
Joined
Mar 20, 2019
Messages
14
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
 

smtalk

Administrator
Staff member
Joined
Aug 22, 2006
Messages
8,340
Location
LT, EU
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!
 

Networkfa

Verified User
Joined
Mar 20, 2019
Messages
14
Another Error :D


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
 
Top