How to install and configure MySQL 8.0 Community in Alma Linux 9 from Generic package (zip install)
0In this video we are going to see how to install and configure MySQL 8.0.41 Community edition in
Alma Linux 9.5 from Generic package (from tar.xz file).
1. download the mysql 8 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-8-data --port=3306 --log-error=/opt/mysql-8-logs/mysql.log
grep 'temporary password' /opt/mysql-8-logs/mysql.log
6. start the database.
mysqld --datadir=/opt/mysql-8-data --port=3306 --log-error=/opt/mysql-8-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.
#mysql8 #installmysql8 #setupmysql8 #mysqllinux #uninstallmysql #EL9