MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). basic steps of configuring MySQL for use with a MySQL-based application in which the application runs on the same server as the database.
SQL is the most popular language for adding, accessing and managing content in a database. It is most noted for its quick processing, proven reliability, ease and flexibility of use. MySQL is an essential part of almost every open source PHP application.
Preparing MySQL For Applications
Install and start MySQL.
Create a MySQL “root” user.
Create a regular MySQL user that the application will use to access the database.
Create your applications database.
Create your databases data tables.
Perform some basic tests of your database structure.
Installation Features of MySQL
The MySQL database server, which manages databases and tables, controls user access, and processes SQL queries.
MySQL client programs, which make it possible to connect to and interact with the server.
Libraries and header files that come in handy when compiling other programs that use MySQL.
Shared libraries for the MySQL client.
Benchmark and performance testing tools for the MySQL database server.
MySQL Installation Layout for Linux RPM Packages
Client programs and scripts
The mysqld server
Log files, databases
MySQL manual in Info format
Unix manual pages
Include (header) files
Support files, including error messages, character set files, sample configuration files, SQL for database installation
Types are used with MySQL
/etc/my.cnf (or) /etc/mysql/my.cnf
/var/run/mysqld/mysqld.pid & /var/lib/mysql/mysql.sock
Installation of MySQL Server 5.6 for CentOS
yum -y update
rpm -ivh mysql-community-release-el7-5.noarch.rpm
ls -1 /etc/yum.repos.d/mysql-community*
Installing MySQL Server
yum install mysql-server
Re-Starting MySQL Services
systemctl start mysqld
systemctl stop mysqld
systemctl restart mysqld
systemctl status mysqld