How to Install MySQL Commercial in RHEL 7

How to Install MySQL Commercial in RHEL 7

How to Install MySQL Commercial in RHEL 7 - Installing MySQL Commercial Edition is a pivotal step for businesses seeking a comprehensive and feature-rich database management solution. 

MySQL, a popular open-source database, offers a Commercial Edition that provides advanced features, professional support, and additional tools tailored to meet the demands of enterprise-level applications. Installing the MySQL Commercial Edition equips organizations with enhanced security features, advanced monitoring capabilities, and performance tuning options, ensuring the optimal functioning of their databases in high-stakes environments.

This premium version also includes enterprise-level support services, enabling prompt issue resolution and access to expert guidance. As businesses navigate the complexities of large-scale data management, installing the MySQL Commercial Edition becomes a strategic choice for unlocking a suite of powerful tools and resources designed to streamline operations and maximize the efficiency of their database infrastructure.

Preparation

Upload file mysql commercial with sftp on directory what you want, in this example i'm put file in my directory /home/kitsake. After upload that mysql, for now you must extract that with unzip. 

And don't forget to set up a local repository before installing MySQL, as installing dependencies will automatically search for and install them.

# cd /home/kitsake
# unzip mysql-commercial-5.7.27-1.1.el7.x86_64.zip

upload and extract

Remove mariadb client, in some cases, mariadb client is already installed when installing Linux OS and must be uninstalled first in order to install mysql commercial.

# yum list installed |grep mariadb
# yum remove mariadb-libs.x86_64

uninstall mariadb client

Installing MySQL Commercial

And then, this time to installing mysql but in this case i only installed the rpm needed, that way I will delete the other rpm that is not needed

# rm -rf mysql-commercial-test-5.7.27-1.1.el7.x86_64.rpm
# rm -rf mysql-commercial-embedded-devel-5.7.27-1.1.el7.x86_64.rpm
# rm -rf mysql-commercial-embedded-compat-5.7.27-1.1.el7.x86_64.rpm 
# rm -rf mysql-commercial-embedded-5.7.27-1.1.el7.x86_64.rpm

And install all of rpm on active directory /home/kitsake this place is mysql rpm i save it

# rpm -i mysql-commercial-*.rpm

After installing you must start this service and make this service start when starting linux after first boot

# systemctl start mysqld
# systemctl enable mysqld
# systemctl status mysqld

installing mysql commercial

From this step i successfully install mysql commercial, but I have to configure this mysql so it can be used.

Configure

Check the temporary password for this mysql and use that credential for setup root

# grep "temporary password" /var/log/mysqld.log

And see on that output after root@localhost: [temp password], After u can see that credential, this time to configure

# mysql_secure_installation

Enter password for user root: [temp password]

New password: [your password]

Re-enter new password: [your password]

configure of mysql

Trying

Try to login with user root and password that was configured earlier

# mysql -u root -p
# show databases;
# exit

try to login mysql commercial

Congratulation your mysql commercial server can be used.

Closing statement

The article "How to Install MySQL Commercial in RHEL 7" provides a comprehensive guide for users aiming to deploy MySQL's commercial edition on Red Hat Enterprise Linux 7 (RHEL 7). MySQL is a widely-used relational database management system known for its reliability, scalability, and performance. 

By following the step-by-step instructions outlined in this article, users can successfully install the commercial version of MySQL on their RHEL 7 servers, unlocking access to advanced features and professional support. 

Whether you're a system administrator overseeing enterprise-grade databases or a developer working on mission-critical applications, this guide equips you with the knowledge and tools necessary to leverage MySQL's commercial edition effectively within your RHEL 7 environment.