MySQL Installation for CentOS


MySQL
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.

MySQL.svg

SQL
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.

sql-logo

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
MySQL
The MySQL database server, which manages databases and tables, controls user access, and processes SQL queries.

MySQL-Dlient
MySQL client programs, which make it possible to connect to and interact with the server.

MySQL-Devel
Libraries and header files that come in handy when compiling other programs that use MySQL.

MySQL-Shared
Shared libraries for the MySQL client.

MySQL-Bench
Benchmark and performance testing tools for the MySQL database server.

MySQL Installation Layout for Linux RPM Packages
/usr/bin
Client programs and scripts

/usr/sbin
The mysqld server

/var/lib/mysql
Log files, databases

/usr/share/info
MySQL manual in Info format

/usr/share/man
Unix manual pages

/usr/include/mysql
Include (header) files

/usr/lib/mysql
Libraries

/usr/share/mysql
Support files, including error messages, character set files, sample configuration files, SQL for database installation

/usr/share/sql-bench
Benchmarks

Types are used with MySQL
mysqld_db_t
/var/lib/mysql/

mysqld_etc_t
/etc/my.cnf (or) /etc/mysql/my.cnf

mysqld_exec_t
/usr/libexec/mysqld

mysqld_initrc_exec_t
/etc/rc.d/init.d/mysqld

mysqld_log_t
/var/log/

mysqld_var_run_t
/var/run/mysqld/mysqld.pid & /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

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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