How To Update MARIADB On CentOS 7
When having mysql server sometime it is smart to update the version all together, this are the steps on Linux CentOS 7 from ssh console:
systemctl stop mariadb
yum remove mariadb-server mariadb mariadb-libs
To check The latest version on mariadb available from repository, browse to http://yum.mariadb.org and look for the latest version available, then change the version you want in the line : baseurl = http://yum.mariadb.org/10.4/centos7-amd64 . on this tutorial it is 10.4
nano /etc/yum.repos.d/MariaDB10.repo
Copy & paste this lines to the new repo file (MariaDB10.repo):
#http://mariadb.org/mariadb/repositories/
#MariaDB 10.1 CentOS repository list - created 2016-01-18 09:58 UTC
[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.4/centos7-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1
Save and continue
yum clean all
yum -y install MariaDB-server MariaDB-client
systemctl start mariadb
systemctl enable mariadb
mysql_upgrade
or (if mysql password protected)
mysql_upgrade -u root -p
To check the current mysql version
mysql -V
simple and informative
THX