Resolved Maria db update

[Office]

Hi there, I'm trying to update Maria db from 5.5.64 to 10.4
I follow this guide: https://support.plesk.com/hc/en-us/articles/213403429-How-to-upgrade-MySQL-5-5-to-5-6-5-7-or-MariaDB-5-5-to-10-0-10-1-10-2-on-Linux-
and from my terminal I have :
------
--------
Installed:

MariaDB-client.x86_64 0:10.4.10-1.el7.centos

MariaDB-compat.x86_64 0:10.4.10-1.el7.centos

MariaDB-server.x86_64 0:10.4.10-1.el7.centos


Dependency Installed:

MariaDB-common.x86_64 0:10.4.10-1.el7.centos

boost-program-options.x86_64 0:1.53.0-27.el7

galera-4.x86_64 0:26.4.3-1.rhel7.el7.centos


Replaced:

mariadb.x86_64 1:5.5.64-1.el7 mariadb-libs.x86_64 1:5.5.64-1.el7

mariadb-server.x86_64 1:5.5.64-1.el7


Complete!


But when I check the installed version on my server I found always the old version.
What I need to do?
Thanks for the help.

 

[Ales]

How did you check the version? If through the GUI, the list probably just needs to be refreshed.

Please note that Plesk does not officially support MariaDB 10.4. There were threads here on the forum with few issues.

 

[Office]

Hi, finally I updated Maria db to 10.4.10, but I received this message when try to create a new db
Error: The test connection to the database server has failed:
SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('root'@'localhost') does not exist

Any idea?

 

[Bitpalast]

As @Ales said: MariaDB 10.4 is not supported.

 

[Geriko]

Here you are!!

#plesk db
#CREATE root'@'localhost' IDENTIFIED BY 'mypass';