MySQL 8.0 Binary Installation: A Step-by-Step Guide

MySQL 8.0 Installation: A Comprehensive Guide

Aim :

Install MySQL 8.0 using the binary distribution on a Linux system.

MySQL 8.0 Installation Steps

Step 1: Prepare System and User

• Create a MySQL group:

  groupadd mysql

• Create a MySQL user with restricted shell access:

  useradd -r -g mysql -s /bin/false mysql

Step 2: Download and Extract MySQL

• Navigate to the installation directory(Not compulsory):

  cd /usr/local

• Extract the MySQL tarball:

  tar xvf /path/to/mysql-VERSION-OS.tar.xz

• Create a symbolic link:

  ln -s full-path-to-mysql-VERSION-OS mysql

• Navigate to the MySQL directory:

  cd mysql

• Create a directory for MySQL files:

  mkdir mysql-files

• Set ownership and permissions:

  chown mysql:mysql mysql-files

  chmod 750 mysql-files

• Optional: Set ownership of mysql folder

  sudo chown -R mysql /usr/local/mysql/
  

• Initialize MySQL with the specified user:

  bin/mysqld --initialize --user=mysql

• Optional: Initialize MySQL SSL:

  bin/mysql_ssl_rsa_setup

• Start MySQL:

  bin/mysqld_safe --user=mysql &

• Optional: Copy MySQL server configuration to init.d:

  cp support-files/mysql.server /etc/init.d/mysql.server

Step 3: Install libaio Library

• Search for libaio information:

  apt-cache search libaio

• Install libaio:

  apt-get install libaio1

Step 4: Verify MySQL Version and Save Temporary Password

• Check MySQL version:

  bin/mysql --version

• Retrieve and save the temporary password from the MySQL error log.

  grep 'temporary password' data/error.log

Verification:

Verify MySQL installation by connecting to the MySQL server using the saved temporary password.

bin/mysql -u root -p

Steps to Remove MariaDB Dependencies in RHEL

Stop MariaDB Service:

sudo systemctl stop mariadb
sudo systemctl disable mariadb

Remove MariaDB Packages:

sudo yum remove mariadb mariadb-server

Remove MariaDB Configuration Files (Optional):

If you want to remove all configuration files and data, use the following commands:

sudo rm -rf /var/lib/mysql
sudo rm -rf /etc/my.cnf
sudo rm -rf /etc/my.cnf.d
sudo rm -rf /etc/mysql

Clean Up Unused Dependencies:

sudo yum autoremove

For the MySQL installer, you can also download it from the official website: MySQL Installer

Written by: A.M.Rinas

Contact: mohomadrinas00@gmail.com