how to configure MySQL server in Linux step by step

Question : how to configure MySQL server in Linux ?Question : step by step MySQL configuration in centos 6 ?Question : what is database and how to configure ?

IP - 10.20.2.33

Hostname - khandwa.lokesh.com

OS - CentOS 6

PORT - 3306

MySQL is a freely available open source Relational Database Management System (RDBMS) that uses Structured Query Language (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.

Required Packages :

mysql-server : The MySQL server and related files

mysql : MySQL client programs and shared libraries
Additionally, you may need to install the following packages to access mysql using various programming languages:

php-mysql : A module for PHP applications that use MySQL databases.

perl-DBD-MySQL : A MySQL interface for perl.

MySQL-python : An interface to MySQL.

step 1Install MySQL Server & Client

# yum install mysql* -y

For Using * after mysql , take all package related to mysql

Import Mysql server files and ports

Mysql server config file: /etc/my.cnf

Mysql server log file: /var/log/mysqld.log

Mysql database storage directory: /var/lib/mysql/

step 2Open my.cnf file and add line

# vi /etc/my.cnf

character-set-server=utf8

step 3 Start MySql Service

# service mysql restart

# chkconfig mysql on

step 4 Configuration mysql Server

# mysql_secure_installation

Note:Press enter to give password for root when that program asks for it by default root password is null