MySQL is an open-source relational database management system. Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.
Download and Install MySQL from the following link
https://dev.mysql.com/downloads/
rpm -ih mysql80-community-release-el7-3.noarch.rpm yum update -y yum install -y mysql-server
Configure
systemctl enable mysqld systemctl start mysqld
mysql_secure_installation
# default password grep -oP 'temporary password(.*): \K(\S+)' /var/log/mysqld.log
Create user and database with permissions
mysql -u root -p # mysql > CREATE DATABASE dbname; CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass'; GRANT ALL PRIVILEGES ON dbname.* TO 'myuser'@'%'; FLUSH PRIVILEGES;
Starting with MySQL 8 you no longer can (implicitly) create a user using the GRANT command. Use CREATE USER instead, followed by the GRANT statement:
CREATE USER 'root'@'%' IDENTIFIED BY 'root'; GRANT ALL PRIVILEGES ON . TO 'root'@'%' WITH GRANT OPTION;