How to install and configure MySQL 9.2 Community in RHEL 9 from Generic package (zip install)

In this video we are going to see how to install and configure MySQL 9.2 Community edition (innovation release) in
Red Hat Enterprise Linux 9.5 from Generic package (from tar.xz file).

1. download the mysql 9.2 as tar.xz or .tar file.
2. Unzip to /opt directory and rename it.
3. create two directories mysql-data for data and mysql-logs for logs.
4. Add the bin directory to Linux PATH variable in .bash_profile (for local user) or under /etc/profile.d (for global access).
5. check the mysql version. Start initializing the mysql database. Copy the temporary password generated in log file.

mysqld --initialize --datadir=/opt/mysql-9.2-data --port=3306 --log-error=/opt/mysql-9.2-logs/mysql.log

grep 'temporary password' /opt/mysql-9.2-logs/mysql.log

6. start the database.

mysqld --datadir=/opt/mysql-9.2-data --port=3306 --log-error=/opt/mysql-9.2-logs/mysql.log

7. Login to mysql using temporary password and change the password. Login once again with modified password.
8. Work with sql queries as uaual.
9. To shutdown use mysqladmin tool by providing the mysql's root password.

mysqladmin -uroot -p shutdown

10. if you want to uninstall mysql. just delete all the mysql folder;s and remove the bin directory from linux path variable. thats it.


#mysql9 #installmysql9 #setupmysql9 #mysqllinux #uninstallmysql #EL9