How to Install MySQL Commercial in RHEL 7 to Save Your Application Data

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

# 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

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 [email protected]: [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.