How To Install root-sql-mysql on CentOS 8

root-sql-mysql is MySQL client plugin for ROOT

Introduction

In this tutorial we learn how to install root-sql-mysql on CentOS 8.

What is root-sql-mysql

This package contains the MySQL plugin for ROOT. This plugin provides a thin client (interface) to MySQL servers. Using this client, one can obtain information from a MySQL database into the ROOT environment.

We can use yum or dnf to install root-sql-mysql on CentOS 8. In this tutorial we discuss both methods but you only need to choose one of method to install root-sql-mysql.

Install root-sql-mysql on CentOS 8 Using dnf

Update yum database with dnf using the following command.

sudo dnf makecache --refresh

The output should look something like this:

CentOS Linux 8 - AppStream                                       43 kB/s | 4.3 kB     00:00    
CentOS Linux 8 - BaseOS                                          65 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - ContinuousRelease                               43 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - Extras                                          23 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - FastTrack                                       40 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - HighAvailability                                36 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - Plus                                            24 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - PowerTools                                      50 kB/s | 4.3 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64           13 kB/s | 9.2 kB     00:00    
Extra Packages for Enterprise Linux 8 - x86_64                   24 kB/s | 8.5 kB     00:00    
Metadata cache created.

After updating yum database, We can install root-sql-mysql using dnf by running the following command:

sudo dnf -y install root-sql-mysql

Install root-sql-mysql on CentOS 8 Using yum

Update yum database with yum using the following command.

sudo yum makecache --refresh

The output should look something like this:

CentOS Linux 8 - AppStream                                       43 kB/s | 4.3 kB     00:00    
CentOS Linux 8 - BaseOS                                          65 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - ContinuousRelease                               43 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - Extras                                          23 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - FastTrack                                       40 kB/s | 3.0 kB     00:00    
CentOS Linux 8 - HighAvailability                                36 kB/s | 3.9 kB     00:00    
CentOS Linux 8 - Plus                                            24 kB/s | 1.5 kB     00:00    
CentOS Linux 8 - PowerTools                                      50 kB/s | 4.3 kB     00:00    
Extra Packages for Enterprise Linux Modular 8 - x86_64           13 kB/s | 9.2 kB     00:00    
Extra Packages for Enterprise Linux 8 - x86_64                   24 kB/s | 8.5 kB     00:00    
Metadata cache created.

After updating yum database, We can install root-sql-mysql using yum by running the following command:

sudo yum -y install root-sql-mysql

How To Uninstall root-sql-mysql on CentOS 8

To uninstall only the root-sql-mysql package we can use the following command:

sudo dnf remove root-sql-mysql

root-sql-mysql Package Contents on CentOS 8

/usr/include/root/TMySQLResult.h
/usr/include/root/TMySQLRow.h
/usr/include/root/TMySQLServer.h
/usr/include/root/TMySQLStatement.h
/usr/lib/.build-id
/usr/lib/.build-id/2d
/usr/lib/.build-id/2d/64906731a6810afd531863cccbfdfb5b463bf6
/usr/lib64/root/libRMySQL.rootmap
/usr/lib64/root/libRMySQL.so
/usr/lib64/root/libRMySQL.so.6.22
/usr/lib64/root/libRMySQL.so.6.22.08
/usr/lib64/root/libRMySQL_rdict.pcm
/usr/share/root/plugins/TSQLServer/P010_TMySQLServer.C

References

Summary

In this tutorial we learn how to install root-sql-mysql on CentOS 8 using yum and dnf.