Friday, September 22, 2023

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

Read more »
at No comments:
Subscribe to: Posts (Atom)

SHOW ENGINE INNODB STATUS

  The SHOW ENGINE INNODB STATUS command in MySQL provides detailed information about the internal state of the InnoDB storage engine. This ...

  • Change the stored Procedure Definer
     Change Views DEFINER without ALTER VIEW: UPDATE `mysql`.`proc` p SET definer = ‘root@localhost’ WHERE definer=’root@foobar’ AND db=’w...
  • 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 process...
  • InnoDB data off the disk
    MySQL's InnoDB storage engine data refresh every situation. This post from InnoDB down, look at the data from the memory to the InnoDB ...