How to install mysql8.0.25 on centos7

Опубликовано: 27 Октябрь 2024
на канале: We Love Pc

113

#install |#mysql | #centos |#centos7
Step-1
wget https://repo.mysql.com/mysql80-commun...

Step-2
yum localinstall mysql80-community-release-el7-1.noarch.rpm

Step-3
yum repolist enabled | grep "mysql.*-community.*"

Step-4
yum install mysql-community-server

Step-5
systemctl start mysqld
systemctl enable mysqld
Step-6
systemctl status mysqld

Step-7
When MySQL 8.0 version is installed, a temporary password for root is created. Run the below command to list the password.
cat /var/log/mysqld.log | grep 'temporary password'

Step-8
mysql_secure_installation

Step-9
mysql -u root -p

Step-9
How to create remote user login for mysql from me
CREATE USER 'root'@'%' IDENTIFIED BY 'Pasw0rd@456';
GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;
FLUSH PRIVILEGES;

Step-10
Firewall Entry is mandatory
firewall-cmd --add-port=3306/tcp --permanent --zone=public
firewall-cmd --reload