What is MySQL?

What is MySQL, My is the daughter’s name of MySQL’s co-founder, Monty Widenius. The name of My/SQL is the combination of My and SQLMySQL.

What is mysql database

MySQL is a DBMS (database management system) that allows you to manage RDBMS (relational databases). My/SQL is open-source Database software backed by Oracle. It means you can use My/SQL without paying money. In addition, if you want, you can change its source code to fulfill your needs.

If you have to need any support so you can buy a commercial license version software from Oracle to get premium support services.

MySQL is very easy to master in comparison with other DB software like Oracle DB, or Microsoft SQL Server.

My/SQL supports various platforms like Linux, UNIX, Windows, etc. You can install it on a server or even on a desktop. In addition, My/SQL is reliable, scalable, and fast database software.

The legal way to pronounce My/SQL is My Ess Que Ell, not My Sequel. However, you can pronounce it whatever you like, who cares?

If you develop any type of website or web applications, My/SQL database is a good choice. My/SQL is an important component of the LAMP stack, which includes Apache, Linux, My/SQL, and PHP.

Read – How to install MySQL Database Server on Redhat Linux

How to install Mysql Database Server on Redhat Linux

In this article I’m going to show you how to Install MySQL Database Server step by step on Redhat Linux.

For the MySQL database installation, we have required MySQL rpm files. You can find out these rpm files from your OS CD or from your YUM repository.

If YUM server not configured on your machine, click here and check how to configure yum server.

Install MySQL Database Server

For RHEL 5 and 6 use following command as Root user.

#yum install mysql-server mysql

For RHEL 3 and 4 use the following command as root user.

#up2date mysql-server mysql

How to start the MySQL server

After installing the above rpm start the MySQL servers using the following commands.

#chkconfig mysqld on
#/etc/init.d/mysqld start

Now make a password for root user of MySQL using the following command.

#mysqladmin -u root password yourpassword

Now check the MySQL connection using the following command.

# mysql -u root -p

Now we need to configure MySQL  Server, add the following settings in “/etc/my.cnf” file, you must remember the following values are sample values, set them as per your requirements.

#mysql settings
query_cache_type = 1
query_cache_limit = 1M
query_cache_size = 32M

# For MyISAM buffer size and recover options
key_buffer_size = 24M
myisam_recover = FORCE,BACKUP

# LOGGINGS for slow query
log_queries_not_using_indexes = 1
slow_query_log = 1
slow_query_log_file = /var/lib/mysql/mysqld-slow-query.log

#cache and other limits

tmp_table_size = 32M
max_heap_table_size = 32M
max_connections = 500
thread_cache_size = 50
open_files_limit = 65535
table_definition_cache = 4096
table_open_cache = 512

Save the above file and restart or reload the MySQL service using the following commands.

#/sbin/service mysqld restart 


#/sbin/service mysqld reload

Create Database and check it using the following command.

#mysql -u root -p
mysql> create database ocpgroup;
mysql> show databases;
| Database           |
| information_schema |
| mysql              |
| ocpgroup           |
| test               |
4 rows in set (0.00 sec)

If you enjoyed this article, Please write in comment box about this article.