In today's article, I'm going to show you the process to reset MySQL/MariaDB root passwords.…
In this tutorial, I’ll show you how to upgrade MariaDB 5.5 to MariaDB 10.3 on CentOS 7.5 (1804).
This tutorial assumes that you are running a stock/default installation of CentOS 7.5, and have already installed MariaDB 5.5.
1. Make sure you’re running MariaDB 5.5
Run the following command:
mysql -v
Should output the following:
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 2 Server version: 5.5.60-MariaDB MariaDB Server
Perfect, let’s keep going!
2. Add the MariaDB 10.3 Repository
Run the following command to add the MariaDB 10.3 repository to yum:
nano /etc/yum.repos.d/maria10-3.repo
Paste the following into the editor
# MariaDB 10.3 CentOS repository list - created 2018-11-19 23:14 UTC # http://downloads.mariadb.org/mariadb/repositories/ [mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.3/centos7-amd64 gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB gpgcheck=1
Save and close the editor, then move to the next step
3. Upgrade to MariaDB 10.3 and verify success
Run the following command to upgrade to MariaDB 10.3:
yum -y upgrade maria*
Output should look something like this:
============================================================================================================================================= Package Arch Version Repository Size ============================================================================================================================================= Installing: MariaDB-client x86_64 10.3.10-1.el7.centos mariadb 53 M replacing mariadb.x86_64 1:5.5.60-1.el7_5 MariaDB-compat x86_64 10.3.10-1.el7.centos mariadb 2.8 M replacing mariadb-libs.x86_64 1:5.5.60-1.el7_5 MariaDB-server x86_64 10.3.10-1.el7.centos mariadb 123 M replacing mariadb-server.x86_64 1:5.5.60-1.el7_5 Installing for dependencies: MariaDB-common x86_64 10.3.10-1.el7.centos mariadb 157 k Transaction Summary =============================================================================================================================================
Once yum does it’s thing, restart the MariaDB daemon:
systemctl restart mariadb
Then verify that the service has started and the installation is complete:
mysql -v
You should see output similar to the following:
Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 8 Server version: 10.3.10-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
Sweet, you’re now running MariaDB 10.3!
After following this steps. Don’t forget to run the command: mysql_upgrade
If not you would get this error:
Error Code: 1146
Table ‘mysql.column_stats’ doesn’t exist
exelent worked on my server and production
Was having the following error after running -> mysql_upgrade
##############
MISTAKE
##############
Version check failed. Got the following error when calling the ‘mysql’ command line client
ERROR 1045 (28000): Access denied for user ‘root’ @ ‘localhost’ (using password: NO)
FATAL ERROR: Upgrade failed
#############
SOLUTION:
mysql_upgrade –password
Thanks a lot. it woks for me.
It works!
Exactly what I needed. Easy, quick, and no issues.
thanx , work for me !
Thanks! Short and working tutorial!