How to Install MySQL Database Server on CentOS 6.2

In this guide, we will walk you through the process of installing the MySQL server on CentOS 6.2 using the yum command. This tutorial assumes that you have a minimal installation type of CentOS 6.2 and have set up your local yum repository. However, if your server has a direct internet connection, you can use the internet CentOS yum repository instead.

Before we dive into the installation process, it’s important to understand what MySQL is and why it’s a crucial component for many web servers. MySQL is an open-source relational database management system that is widely used in web applications to store, organize, and retrieve data. It’s a key part of the LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack, a popular open-source web development platform.

For more information about different types of web servers, you can visit our guide on the best web servers. If you’re interested in learning about Apache, Nginx, or LiteSpeed servers, you can check out our detailed articles on Apache, Nginx, and LiteSpeed respectively.

Now, let’s get started with the installation process.

Step 1: Setting Up Local Yum Repository

Before you can install MySQL, you need to set up your local yum repository. If you’re not sure how to do this, you can follow our guide on How to Setup Local Yum Repository from CD-ROM/DVD-ROM image on CentOS 6.2.

Once you have your local yum repository set up, you can proceed with the installation of MySQL.

See also  How to Install and Configure Apache2, PHP and MySQL 5.6 on Ubuntu 14.04

Step 2: Installing MySQL and MySQL Server

To install MySQL and MySQL server, you will use the yum command. Open your terminal and type the following command:

[root@centos6 ~]# yum install mysql mysql-server

This command will initiate the installation process. The system will resolve dependencies and check the transaction before starting the installation.

[root@centos6 ~]# yum install mysql mysql-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.1.52-1.el6_0.1 will be installed
---> Package mysql-server.i686 0:5.1.52-1.el6_0.1 will be installed
--> Processing Dependency: perl-DBI for package: mysql-server-5.1.52-1.el6_0.1.i686
--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.52-1.el6_0.1.i686
--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.52-1.el6_0.1.i686
--> Running transaction check
---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be installed
---> Package perl-DBI.i686 0:1.609-4.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=================================================================================================
 Package                Arch         Version                  Repository                    Size
=================================================================================================
Installing:
 mysql                  i686         5.1.52-1.el6_0.1         CentOS6.2-Repository         898 k
 mysql-server           i686         5.1.52-1.el6_0.1         CentOS6.2-Repository         8.3 M
Installing for dependencies:
 perl-DBD-MySQL         i686         4.013-3.el6              CentOS6.2-Repository         134 k
 perl-DBI               i686         1.609-4.el6              CentOS6.2-Repository         705 k

Transaction Summary
=================================================================================================
Install       4 Package(s)

Total download size: 10 M
Installed size: 27 M
Is this ok [y/N]: y
Downloading Packages:
-------------------------------------------------------------------------------------------------
Total                                                             13 MB/s |  10 MB     00:00
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : perl-DBI-1.609-4.el6.i686                                                     1/4
  Installing : perl-DBD-MySQL-4.013-3.el6.i686                                               2/4
  Installing : mysql-5.1.52-1.el6_0.1.i686                                                   3/4
  Installing : mysql-server-5.1.52-1.el6_0.1.i686                                            4/4

Installed:
  mysql.i686 0:5.1.52-1.el6_0.1               mysql-server.i686 0:5.1.52-1.el6_0.1

Dependency Installed:
  perl-DBD-MySQL.i686 0:4.013-3.el6                  perl-DBI.i686 0:1.609-4.el6

Complete!

During the installation process, you will see a list of packages that will be installed, including MySQL and MySQL server, along with their dependencies. The system will also display the total download size and the installed size.

See also  How to Securing MySQL Database Server on CentOS 5.8

When prompted with “Is this ok [y/N]:”, type ‘y’ and press Enter to proceed with the installation.

The system will then download the packages and run a transaction test before finally installing the packages.

Once the installation is complete, you will see a message that confirms the installed packages.

Congratulations! You have successfully installed MySQL and MySQL server on your CentOS 6.2 system.

Commands Mentioned

  • yum install mysql mysql-server – This command installs MySQL and MySQL server on your system.

Conclusion

In this tutorial, we have walked you through the process of installing MySQL and MySQL server on CentOS 6.2 using the yum command. This process involves setting up your local yum repository, initiating the installation process, resolving dependencies, and confirming the installation.

By following these steps, you can successfully install MySQL and MySQL server on your system, enabling you to store, organize, and retrieve data for your web applications.

Remember, choosing the right hosting for your server is crucial for the performance of your web applications. If you’re interested in learning more about different types of hosting, you can check out our articles on dedicated, VPS, cloud, and shared hosting.

We hope this guide has been helpful in your journey to becoming a proficient webmaster or website administrator. Remember, the key to mastering these skills is practice and continuous learning. Don’t hesitate to revisit this guide or any of our other resources as you continue to hone your skills.

See also  How to Find the DNS Servers using the Nslookup Command

Happy hosting!

FAQ

  1. What is MySQL?

    MySQL is an open-source relational database management system. It is widely used in web applications to store, organize, and retrieve data. It’s a key part of the LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack, a popular open-source web development platform.

  2. Why do I need to set up a local yum repository?

    A local yum repository is required to install packages on CentOS. It contains the metadata for the available packages and enables you to install, upgrade, or remove software on your system using the yum command.

  3. What does the ‘yum install mysql mysql-server’ command do?

    The ‘yum install mysql mysql-server’ command installs MySQL and MySQL server on your CentOS system. It resolves dependencies and checks the transaction before starting the installation.

  4. What are the dependencies for MySQL server?

    The dependencies for MySQL server include perl-DBI and perl-DBD-MySQL. These are Perl modules that provide a database independent interface for Perl and a MySQL driver for the Perl5 Database Interface, respectively.

  5. How do I confirm that MySQL and MySQL server are installed?

    Once the installation is complete, the terminal will display a message confirming the installed packages. This message indicates that MySQL and MySQL server have been successfully installed on your system.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *