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-fileschmod 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 -pSteps to Remove MariaDB Dependencies in RHEL
Stop MariaDB Service:
sudo systemctl stop mariadb
sudo systemctl disable mariadbRemove MariaDB Packages:
sudo yum remove mariadb mariadb-serverRemove 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/mysqlClean Up Unused Dependencies:
sudo yum autoremoveFor the MySQL installer, you can also download it from the official website: MySQL Installer