{"id":1600,"date":"2012-01-08T10:12:59","date_gmt":"2012-01-08T02:12:59","guid":{"rendered":"https:\/\/webhostinggeeks.com\/howto\/?p=1600"},"modified":"2023-06-22T22:52:28","modified_gmt":"2023-06-22T22:52:28","slug":"how-to-install-mysql-database-server-on-centos-6-2","status":"publish","type":"post","link":"https:\/\/webhostinggeeks.com\/howto\/how-to-install-mysql-database-server-on-centos-6-2\/","title":{"rendered":"How to Install MySQL Database Server on CentOS 6.2"},"content":{"rendered":"

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.<\/p>\n

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.<\/p>\n

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

Now, let’s get started with the installation process.<\/p>\n

Step 1: Setting Up Local Yum Repository<\/h2>\n

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<\/a>.<\/p>\n

Once you have your local yum repository set up, you can proceed with the installation of MySQL.<\/p>\n

Step 2: Installing MySQL and MySQL Server<\/h2>\n

To install MySQL and MySQL server, you will use the yum command. Open your terminal and type the following command:<\/p>\n

\r\n[root@centos6 ~]# yum install mysql mysql-server\r\n<\/pre>\n
This command will initiate the installation process. The system will resolve dependencies and check the transaction before starting the installation.<\/p>\n
\r\n[root@centos6 ~]# yum install mysql mysql-server\r\nLoaded plugins: fastestmirror\r\nLoading mirror speeds from cached hostfile\r\nSetting up Install Process\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package mysql.i686 0:5.1.52-1.el6_0.1 will be installed\r\n---> Package mysql-server.i686 0:5.1.52-1.el6_0.1 will be installed\r\n--> Processing Dependency: perl-DBI for package: mysql-server-5.1.52-1.el6_0.1.i686\r\n--> Processing Dependency: perl-DBD-MySQL for package: mysql-server-5.1.52-1.el6_0.1.i686\r\n--> Processing Dependency: perl(DBI) for package: mysql-server-5.1.52-1.el6_0.1.i686\r\n--> Running transaction check\r\n---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be installed\r\n---> Package perl-DBI.i686 0:1.609-4.el6 will be installed\r\n--> Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n=================================================================================================\r\n Package                Arch         Version                  Repository                    Size\r\n=================================================================================================\r\nInstalling:\r\n mysql                  i686         5.1.52-1.el6_0.1         CentOS6.2-Repository         898 k\r\n mysql-server           i686         5.1.52-1.el6_0.1         CentOS6.2-Repository         8.3 M\r\nInstalling for dependencies:\r\n perl-DBD-MySQL         i686         4.013-3.el6              CentOS6.2-Repository         134 k\r\n perl-DBI               i686         1.609-4.el6              CentOS6.2-Repository         705 k\r\n\r\nTransaction Summary\r\n=================================================================================================\r\nInstall       4 Package(s)\r\n\r\nTotal download size: 10 M\r\nInstalled size: 27 M\r\nIs this ok [y\/N]: y\r\nDownloading Packages:\r\n-------------------------------------------------------------------------------------------------\r\nTotal                                                             13 MB\/s |  10 MB     00:00\r\nRunning rpm_check_debug\r\nRunning Transaction Test\r\nTransaction Test Succeeded\r\nRunning Transaction\r\n  Installing : perl-DBI-1.609-4.el6.i686                                                     1\/4\r\n  Installing : perl-DBD-MySQL-4.013-3.el6.i686                                               2\/4\r\n  Installing : mysql-5.1.52-1.el6_0.1.i686                                                   3\/4\r\n  Installing : mysql-server-5.1.52-1.el6_0.1.i686                                            4\/4\r\n\r\nInstalled:\r\n  mysql.i686 0:5.1.52-1.el6_0.1               mysql-server.i686 0:5.1.52-1.el6_0.1\r\n\r\nDependency Installed:\r\n  perl-DBD-MySQL.i686 0:4.013-3.el6                  perl-DBI.i686 0:1.609-4.el6\r\n\r\nComplete!\r\n<\/pre>\n
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.<\/p>\n
When prompted with “Is this ok [y\/N]:”, type ‘y’ and press Enter to proceed with the installation.<\/p>\n
The system will then download the packages and run a transaction test before finally installing the packages.<\/p>\n
Once the installation is complete, you will see a message that confirms the installed packages.<\/p>\n
Congratulations! You have successfully installed MySQL and MySQL server on your CentOS 6.2 system.<\/p>\n
Commands Mentioned<\/h2>\n