MySQL Installation for CentOS

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/ & /var/lib/mysql/mysql.sock

MySQL Syntax
SELECT column_name(s)
FROM table_name
LIMIT number;

Installation of MySQL Server 5.6 for CentOS
Updating System
yum -y update

Install MySQL-community
rpm -ivh mysql-community-release-el7-5.noarch.rpm

After Installation
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

Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s