How to install MySQL 5.7 on CentOS 7 Server

To install MySQL 5.7 on CentOS 7 server, install the repository rpm -ivh http://repo.mysql.com/mysql57-community-release-el7.rpm import MySQL GPG key with rpm –import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 Install MySQL with the command yum install mysql-community-server.x86_64 Enable MySQL to start on boot systemctl enable mysqld Start MySQL with systemctl start mysqld Find the initial MySQL password with the command grep ‘password’ … Read more

How to Migrate CentOS to Oracle Linux

Oracle Linux is Free 100% binary-compatible with Red Hat Enterprise Linux, same as CentOS. Unlike RHEL, Oracle Linux is free even for commercial use. Oracle only charges if you need support. Oracle provides a script to convert CentOS to Oracle Linux https://github.com/oracle/centos2ol This script support CentOS 6, CentOS 7 and CentOS 8. Before you can … Read more

bash: mysql_safe: command not found

MySQL

On CentOS 7 server running MySQL 5.7, when trying to reset MySQL root password, I get an error [root@SAU-8E161-OR ~]# mysqld_safe –skip-grant-tables -bash: mysqld_safe: command not found [root@SAU-8E161-OR ~]# This is because MySQL 5.7 installation using yum removed the mysqld_safe binary file. To reset, you need to start MySQL using systemctl with skip-grant-tables options. So … Read more

yum fix duplicate package error

When installing a package, i get following error Protected multilib versions: 1:systemd-libs-219-78.el7.cloudlinux.i686 != 1:systemd-libs-219-78.el7_9.2.cloudlinux.x86_64 To fix, remove the conflicting package with rpm -e –nodeps –justdb systemd-libs See yum, Fix yum duplicate packages

Red Hat Killing CentOS Linux, Fight for CentOS clone

RedHat, parent company of CentOS Linux announce it will stop supporting CentOS 8, the latest version of CentOS. CentOS is build from the source code RHEL, making a free version of stable and well-tested enterprise ready RHEL Linux. CentOS 7 will keep getting security updates until it reaches End Of Life June 30th, 2024. For … Read more

CentOS 6 Invalid release/repo/arch combination

When i run yum update on a CentOS 6 server, i get error “Invalid release/repo/arch combination/”. This error is due to CentOS reaching its End Of Life and no longer supported. What you need to do is upgrade your server to the latest supported CentOS versions like CentOS 7 or CentOS 8. Converting to Oracle … Read more

Install Monit on CentOS

Monit allow you to monitor process. It can restart failed process or alert when server is overloaded. On CentOS server, you need to enable EPEL repo to install monit. yum install epel-release -y Install monit with yum install monit -y Enable monit to auto start on boot systemctl enable monit Start monit service systemctl start … Read more

Prometheus init script for CentOS 6

Create init file. touch /etc/rc.d/init.d/prometheus chmod 755 /etc/rc.d/init.d/prometheus vi /etc/rc.d/init.d/prometheus Add following #!/bin/bash # # /etc/rc.d/init.d/prometheus # # Prometheus monitoring server # # chkconfig: 2345 20 80 Read # description: Prometheus monitoring server # processname: prometheus # Source function library. . /etc/rc.d/init.d/functions PROGNAME=prometheus PROG=/usr/hostonnet/prometheus/$PROGNAME USER=prometheus LOGFILE=/var/log/prometheus.log DATADIR=/usr/hostonnet/prometheus/data LOCKFILE=/var/run/$PROGNAME.pid CONFIG_FILE=/usr/hostonnet/prometheus/prometheus.yml ALERT_MGR_URL=localhost:9093 start() { echo -n “Starting … Read more