How install MySQL server in 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 the YUM server is not configured on your machine, click here and check how to configure the yum server.

How install MySQL server step by step?

Install MySQL Database Server

For RHEL 5 and 6 use the following command as the root user.

#yum install mysql-server mysql

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

#up2date mysql-server mysql

How do I start MySQL on Redhat Linux?

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 the 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 

OR

#/sbin/service mysqld reload

Create a 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 the comment box about this article.