{"id":1142,"date":"2025-03-02T19:55:56","date_gmt":"2025-03-02T19:55:56","guid":{"rendered":"https:\/\/humtechno.com\/master\/?p=1142"},"modified":"2025-04-13T20:19:47","modified_gmt":"2025-04-13T20:19:47","slug":"mysql-installation-on-linux","status":"publish","type":"post","link":"https:\/\/humtechno.com\/master\/2025\/03\/02\/mysql-installation-on-linux\/","title":{"rendered":"MYSQL Installation on Linux"},"content":{"rendered":"\n\n\n\n

Download Steps from<\/a><\/p>\n\n

<\/p>\n\n

Operating System:         Redhat Linux<\/strong><\/p>\n\n

IP:                                      192.168.179.137<\/strong><\/p>\n\n

Create Local Yum Repository<\/strong><\/p>\n\n

Install RPM of MYSQL Database<\/strong><\/p>\n\n

cd \/data\/software\/mysql<\/p>\n\n

yum install mysql-commercial-common-8.4.4-1.* -y<\/p>\n\n

yum install  mysql-commercial-icu-data-files-* -y<\/p>\n\n

yum install  mysql-commercial-client-plugins-8.4.4-1.1.el8.x86_64.rpm -y<\/p>\n\n

yum install  mysql-commercial-libs-8.4.4-1.1.el8.x86_64.rpm -y<\/p>\n\n

yum install  mysql-commercial-client-8.4.4-1.1.el8.x86_64.rpm -y<\/p>\n\n

yum install  mysql-commercial-server-8.4.4-1.1.el8.x86_64.rpm -y<\/p>\n\n

<\/p>\n\n

Create Directory for Database Files<\/strong><\/p>\n\n

mkdir \/data\/database<\/p>\n\n

Change in MySQL Parameter File<\/strong><\/p>\n\n

vi \/etc\/my.cnf<\/p>\n\n

#datadir=\/var\/lib\/mysql<\/p>\n\n

socket=\/var\/lib\/mysql\/mysql.sock<\/p>\n\n

log-error=\/var\/log\/mysqld.log<\/p>\n\n

pid-file=\/var\/run\/mysqld\/mysqld.pid<\/p>\n\n

datadir=\/data\/database<\/p>\n\n

server-id = 1<\/p>\n\n

log_bin = mysql-bin.log<\/p>\n\n

Disable SELINUX<\/strong><\/p>\n\n

setenforce 0<\/p>\n\n

vi \/etc\/selinux\/config<\/p>\n\n

SELINUX=disabled<\/p>\n\n

Restart MYSQL Database Services<\/strong><\/p>\n\n

service mysqld restart<\/p>\n\n

Collect One Time Temporary Password of Root User from mysql LOG (<\/strong>\/var\/log\/mysqld.log)<\/p>\n\n

Temporary Password =wc:sRdvnu3dU<\/p>\n\n

Login MYSQL Database with Temporary Password and Changes this Password<\/strong><\/p>\n\n

mysql -u root -pzusr#5TfLydQ<\/p>\n\n

ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘Oracle321#’;<\/p>\n\n

flush privileges;<\/p>\n\n

Connect to MYSQL Database, Create Database and User for Testing \/ Verify<\/strong><\/p>\n\n

mysql -u root -pOracle321#<\/p>\n\n

show databases;<\/p>\n\n

create database test;<\/p>\n\n

create user ‘replica1’@’%’ identified by ‘Oracle321#’;<\/p>\n\n

grant replication slave on *.* to ‘replica1’@’%’;<\/p>\n\n

FLUSH PRIVILEGES;<\/p>\n\n

SHOW BINARY LOG STATUS;<\/p>\n\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_siteseo_robots_primary_cat":"6","pagelayer_contact_templates":[],"_pagelayer_content":"","neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[15],"tags":[16],"class_list":["post-1142","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-mysql-enterprize-installation"],"_links":{"self":[{"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/posts\/1142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/comments?post=1142"}],"version-history":[{"count":3,"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/posts\/1142\/revisions"}],"predecessor-version":[{"id":1164,"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/posts\/1142\/revisions\/1164"}],"wp:attachment":[{"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/media?parent=1142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/categories?post=1142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/humtechno.com\/master\/wp-json\/wp\/v2\/tags?post=1142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}