Install MySQL 8 on Different Operating Systems

  • INSTALL MYSQL 8 ON CENTOS/REHAT

  ### INSTALLATION STEPS STEP 1. DOWNLOAD MYSQL 8 REPOSITORY PACKAGE wget https://repo.mysql.com/mysql80-community-release-el7-3.noarch.rpm STEP 2. INSTALL MYSQL REPO LOCALLY sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm STEP 3. Import Public Key for MySQL 8 sudo rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022 STEP 4. INSTALL MYSQL SERVER sudo yum install mysql-community-server STEP 5. ENABLE MYSQL SERVICE TO AUTO-START ON REBOOT sudo systemctl enable mysqld.service STEP 6. START MYSQL SERVICE sudo systemctl start mysqld.service STEP 7. CHECK STATUS OF MYSQL SERVICE systemctl status mysqld ### VERIFICATION pidof mysqld netstat -ntlp | grep 3306 sudo lsof -u mysql

  • INSTALL MYSQL 8 COMMUNITY EDITION ON AMAZON LINUX 2023

### VERIFY OS VERSION cat /etc/*release* ### DOWNLOAD & INSTALL MYSQL REPOSITORY sudo wget https://dev.mysql.com/get/mysql80-community-release-el9-1.noarch.rpm sudo dnf install mysql80-community-release-el9-1.noarch.rpm dnf repolist enabled | grep "mysql.*-community.*" ### INSTALL MYSQL SERVER sudo dnf -y install mysql-community-server ### ENABLE MYSQL SERVICE TO AUTO-START ON REBOOT systemctl status mysqld sudo systemctl enable mysqld ### START MYSQL SERVICE sudo systemctl start mysqld.service ### CHECK STATUS OF MYSQL SERVICE systemctl status mysqld.service ### VERIFICATION pidof mysqld sudo lsof -u mysql ### SECURE INSTALLATION sudo mysql_secure_installation 

  • INSTALL MYSQL 8 COMMUNITY EDITION ON UBUNTU

STEP 1. VERIFY OS VERSION lsb_release -a STEP 2. RUN UPDATES & UPGRADES sudo apt update && sudo apt upgrade STEP 3. INSTALL MYSQL SERVER IF NOT INSTALLED sudo apt list --installed | grep -i mysql-server sudo apt list | grep -i mysql-server sudo apt install mysql-server-8.0 STEP 4. ENABLE MYSQL SERVICE TO AUTO-START ON REBOOT sudo systemctl enable mysql.service STEP 5. START MYSQL SERVICE sudo systemctl start mysql.service STEP 6. CHECK STATUS OF MYSQL SERVICE systemctl status mysql.service ### VERIFICATION pidof mysqld sudo lsof -u mysql ### SECURE INSTALLATION sudo mysql ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'P@ssw0rd123'; exit mysql -u root -p ALTER USER 'root'@'localhost' IDENTIFIED WITH auth_socket; exit sudo mysql_secure_installation 

Y 2 Y Y Y Y

  •  INSTALL PERCONA MYSQL 8 COMMUNITY EDITION

##INSTALLATION STEPS STEP 1. DOWNLOAD PERCONA MYSQL 8 REPOSITORY PACKAGE wget https://repo.percona.com/yum/percona-release-latest.noarch.rpm STEP 2. INSTALL PERCONA MYSQL REPO LOCALLY sudo yum localinstall percona-release-latest.noarch.rpm STEP 3. ENABLE REPO FOR PERCONA MySQL 8 sudo percona-release setup -y ps80 STEP 4. INSTALL MYSQL SERVER sudo yum install percona-server-server STEP 5. ENABLE MYSQL SERVICE TO AUTO-START ON REBOOT sudo systemctl enable mysqld.service STEP 6. START MYSQL SERVICE sudo systemctl start mysqld.service STEP 7. CHECK STATUS OF MYSQL SERVICE systemctl status mysqld ### VERIFICATION pidof mysqld netstat -ntlp | grep 3306 sudo lsof -u mysql

  • DOWNLOAD MYSQL AND LOCAL INSTALL FROM RPMs

### INSTALLATION STEPS STEP 1. DOWNLOAD PERCONA MYSQL 8 REPOSITORY PACKAGE wget https://repo.percona.com/yum/percona-release-latest.noarch.rpm STEP 2. DOWNLOAD INDIVIDUAL RPM PACKAGES wget https://downloads.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.28-20/binary/redhat/7/x86_64/percona-server-server-8.0.28-20.1.el7.x86_64.rpm wget https://downloads.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.28-20/binary/redhat/7/x86_64/percona-server-client-8.0.28-20.1.el7.x86_64.rpm wget https://downloads.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.28-20/binary/redhat/7/x86_64/percona-server-shared-8.0.28-20.1.el7.x86_64.rpm wget https://downloads.percona.com/downloads/Percona-Server-LATEST/Percona-Server-8.0.28-20/binary/redhat/7/x86_64/percona-server-shared-compat-8.0.28-20.1.el7.x86_64.rpm STEP 3. INSTALL REPO sudo yum localinstall percona-release-latest.noarch.rpm STEP 4. ENABLE REPO FOR PERCONA MySQL 8 sudo percona-release setup -y ps80 STEP 5. LOCAL INSTALL ALL PACKAGES sudo yum localinstall percona-server-*.rpm STEP 6. VERIFY VERSION OF EACH PACKAGE rpm -qa | grep -i percona-server STEP 7. ENABLE MYSQL SERVICE TO AUTO-START ON REBOOT sudo systemctl enable mysqld.service STEP 8. START MYSQL SERVICE sudo systemctl start mysqld.service STEP 9. CHECK STATUS OF MYSQL SERVICE systemctl status mysqld ### VERIFICATION pidof mysqld netstat -ntlp | grep 3306 sudo lsof -u mysql 

 

  • INSTALL DOCKER AND MYSQL DOCKER IMAGE

## INSTALL DOCKER ### OS UPDATE sudo yum update ### SEARCH FOR DOCKER sudo yum search docker sudo yum info docker ### INSTALL DOCKER sudo yum install docker -y ### ADD CURRENT USER TO DOCKER GROUP sudo usermod -a -G docker $USER ### VERIFY GROUP MEMBERSHIP id exit ### ENABLE AND START DOCKER sudo systemctl enable docker.service sudo systemctl start docker.service systemctl status docker.service ### LIST DOCKER IMAGES docker images ### LIST DOCKER CONTAINERS docker ps ### SEARCH FOR MYSQL docker search mysql ### PULL MYSQL DOCKER IMAGE docker pull mysql docker images ### INSPECT MYSQL DOCKER IMAGE docker inspect mysql ### RUN MYSQL CONTAINER docker run --name mysql-831 -e MYSQL_ROOT_PASSWORD=P@ssw0rd -d mysql:latest ### VERIFY IF MYSQL IS RUNNING AS CONTAINER docker container ps pidof mysqld sudo netstat -ntlp | grep 3306 <-- No, why? ### INSPECT MYSQL CONTAINER docker container inspect mysql-831 ### MYSQL CONTAINER LOGS docker logs mysql-831 ### MYSQL CONTAINER HOST docker exec -it mysql-831 bash mysql -u root -p ### REMOVE MYSQL CONTAINER docker container stop mysql-831 docker ps docker ps -a docker container --help docker container rm --help docker container rm -fv mysql-831 ### EXPOSE CONTAINER PORT TO HOST docker container run --name mysql-831 -e MYSQL_ROOT_PASSWORD=P@ssw0rd -d --publish 3306:3306 mysql:latest ### BIND LOCAL VOLUME mkdir mysql-data docker run --name mysql-831 -e MYSQL_ROOT_PASSWORD=P@ssw0rd -d -p 3306:3306 -v /home/ec2-user/mysql-data:/var/lib/mysql mysql:latest ls -ltr mysql-data

 

  • MYSQL SECURE INSTALLATION (AFTER MYSQL INSTALLATION REQUIRED)

### STEPS STEP 1. ACCESS ROOT PASSWORD sudo grep password /var/log/mysqld.log STEP 2. SEARCH FOR MYSQL_SECURE_INSTALLATION SCRIPT which mysql_secure_installation file /usr/bin/mysql_secure_installation ls -ltr /usr/bin/mysql_secure_installation STEP 3. RUN MYSQL_SECURE_INSTALLATION SCRIPT sudo mysql_secure_installation Enter password for user root: The existing password for the user account root has expired. Please set a new password New password:xxxxxx Re-enter new password:xxxxxx Change the password for root ? ((Press y|Y for Yes, any other key for No) : N Remove anonymous users? (Press y|Y for Yes, any other key for No) : Y Disallow root login remotely? (Press y|Y for Yes, any other key for No) : Y Remove test database and access to it? (Press y|Y for Yes, any other key for No) : Y Reload privilege tables now? (Press y|Y for Yes, any other key for No) : Y Success. All done! STEP 4. LOGIN TO MYSQL AND VERIFY mysql --host=localhost --user=root --password STEP 5. CHECK MYSQL VERSION mysql> SELECT @@hostname, @@server_id, @@version;

 

 

 

 

Comments

Post a Comment

Popular posts from this blog

How do I Use the Linux Top Command?

The Unix top command is designed to help users determine which processes are running and which applications are using more memory or processing power than they should be. The top command is very easy to use but you should know the things in details. The output of to is : top output: top - 22:09:08 up 14 min, 1 user, load average: 0.21, 0.23, 0.30 Tasks: 81 total, 1 running, 80 sleeping, 0 stopped, 0 zombie Cpu(s): 9.5%us, 31.2%sy, 0.0%ni, 27.0%id, 7.6%wa, 1.0%hi, 23.7%si, 0.0%st Mem: 255592k total, 167568k used, 88024k free, 25068k buffers Swap: 524280k total, 0k used, 524280k free, 85724k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 3166 apache 15 0 29444 6112 1524 S 6.6 2.4 0:00.79 httpd 3161 apache 15 0 29444 6112 1524 S 5.9 2.4 0:00.79 httpd 3164 apache 15 0 29444 6112 1524 S 5.9 2.4 0:00.75 httpd 3169 apache 15 0 29444 6112 1524 S 5.9 2.4 0:00.74 httpd 3163 apache 15
Read more

IOPS measurement

Image
IOPS (input/output operations per second) is the standard unit of measurement for the maximum number of reads and writes to non-contiguous storage locations of devices like hard disk drives (HDD), solid state drives (SSD), and storage area networks (SAN). IOPs is often measured with an open source network testing tool called an Iometer. Some commonly accepted averages for random IO operations, calculated as 1/(seek + latency) = IOPS:  IOPS calculations Every disk in your storage system has a maximum theoretical IOPS value that is based on a formula. Disk performance — and IOPS — is based on three key factors: Rotational speed (aka spindle speed). Measured in revolutions per minute (RPM), most disks you'll consider for enterprise storage rotate at speeds of 7,200, 10,000 or 15,000 RPM with the latter two being the most common. A higher rotational speed is associated with a higher performing disk. This value is not used directly in calculations, but it is highly i
Read more