LAB: Install MySQL on CentOS 7 | Install CentOS 7 on Vmware Workstation | MySQL Training|TechPledge
For Details Visit Us: https://www.techpledgeconsulting.com/
Email: info@techpledgeconsulting.com
Whats up: +91-7676-7 03-141
========================================================
MySQL is an open-source database management system,. It uses a relational database and SQL (Structured Query Language) to manage its data.
You Need A CentOS 7 with a non-root user with sudo privileges.
$ wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm
Once the rpm file is saved, we will verify the integrity of the download by running md5sum and comparing it with the corresponding MD5 value listed on the site:
$ md5sum mysql57-community-release-el7-9.noarch.rpm
Now that we’ve verified that the file wasn’t corrupted or changed, we’ll install the package:
$ sudo rpm -ivh mysql57-community-release-el7-9.noarch.rpm
This adds two new MySQL yum repositories, and we can now use them to install MySQL server:
$ sudo yum install mysql-server
We’ll start the daemon with the following command:
$ sudo systemctl start mysqld
$ sudo systemctl status mysqld
During the installation process, a temporary password is generated for the MySQL root user. Locate it in the mysqld.log with this command:
$ sudo grep ‘temporary password’ /var/log/mysqld.log
MySQL includes a security script to change some of the less secure default options for things like remote root logins and sample users.
$ sudo mysql_secure_installation
Set the password Password@123
Now Login
$ mysql -u root -p
centos 7