The Remi Repository, also known as Les RPM de Remi repository, is a renowned third-party repository for CentOS. It is highly regarded for providing and maintaining the latest versions of MySQL and PHP. When you need the most recent version of the Linux Apache MySQL and PHP (LAMP) server, the Remi repository can be an invaluable resource.<\/p>\n
This tutorial will guide you through the process of installing MySQL 5.5 database on CentOS 6.2 using the Remi repository. Before we start, make sure you have installed the Remi yum Repository on CentOS 6.2 x86 and x86_64.<\/p>\n
The first step in the installation process is to install the latest MySQL Server packages. To do this, run the following command:<\/p>\n
\r\nyum install mysql mysql-server -y\r\n<\/pre>\nThis command will initiate the installation process, resolving dependencies, and running a transaction check. It will install the MySQL package and the MySQL server package. During this process, the system will also install the necessary dependencies, such as libaio and mysql-libs.<\/p>\n
\r\n[root@centos62 ~]# yum install mysql mysql-server -y\r\nLoaded plugins: fastestmirror, priorities\r\nLoading mirror speeds from cached hostfile\r\n * base: centos.ipserverone.com\r\n * extras: centos.ipserverone.com\r\n * remi: rpms.famillecollet.com\r\n * remi-test: rpms.famillecollet.com\r\n * updates: centos.ipserverone.com\r\nSetting up Install Process\r\nResolving Dependencies\r\n--> Running transaction check\r\n---> Package mysql.i686 0:5.5.25-1.el6.remi will be installed\r\n--> Processing Dependency: mysql-libs(x86-32) = 5.5.25-1.el6.remi for package: mysql-5.5.25-1.el6.remi.i686\r\n---> Package mysql-server.i686 0:5.5.25-1.el6.remi will be installed\r\n--> Processing Dependency: libaio.so.1(LIBAIO_0.4) for package: mysql-server-5.5.25-1.el6.remi.i686\r\n--> Processing Dependency: libaio.so.1(LIBAIO_0.1) for package: mysql-server-5.5.25-1.el6.remi.i686\r\n--> Processing Dependency: libaio.so.1 for package: mysql-server-5.5.25-1.el6.remi.i686\r\n--> Running transaction check\r\n---> Package libaio.i686 0:0.3.107-10.el6 will be installed\r\n---> Package mysql-libs.i686 0:5.5.25-1.el6.remi 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.5.25-1.el6.remi remi 5.8 M\r\n mysql-server i686 5.5.25-1.el6.remi remi 10 M\r\nInstalling for dependencies:\r\n libaio i686 0.3.107-10.el6 base 21 k\r\n mysql-libs i686 5.5.25-1.el6.remi remi 771 k\r\n\r\nTransaction Summary\r\n====================================================================================================\r\nInstall 4 Package(s)\r\n\r\nTotal download size: 17 M\r\nInstalled size: 77 M\r\nDownloading Packages:\r\n(1\/4): libaio-0.3.107-10.el6.i686.rpm | 21 kB 00:00\r\n(2\/4): mysql-5.5.25-1.el6.remi.i686.rpm | 5.8 MB 12:36\r\n(3\/4): mysql-libs-5.5.25-1.el6.remi.i686.rpm | 771 kB 01:35\r\n(4\/4): mysql-server-5.5.25-1.el6.remi.i686.rpm | 10 MB 21:41\r\n----------------------------------------------------------------------------------------------------\r\nTotal 8.0 kB\/s | 17 MB 35:56\r\nRunning rpm_check_debug\r\nRunning Transaction Test\r\nTransaction Test Succeeded\r\nRunning Transaction\r\n Installing : mysql-libs-5.5.25-1.el6.remi.i686 1\/4\r\n\r\nWARNING : This MySQL RPM is not an official Fedora\/Redhat build and it\r\noverrides the official one. Don't file bugs on Fedora Project nor Redhat.\r\nUse dedicated forums http:\/\/forums.famillecollet.com\/\r\n\r\n Installing : mysql-5.5.25-1.el6.remi.i686 2\/4\r\n Installing : libaio-0.3.107-10.el6.i686 3\/4\r\n Installing : mysql-server-5.5.25-1.el6.remi.i686 4\/4\r\n\r\nInstalled:\r\n mysql.i686 0:5.5.25-1.el6.remi mysql-server.i686 0:5.5.25-1.el6.remi\r\n\r\nDependency Installed:\r\n libaio.i686 0:0.3.107-10.el6 mysql-libs.i686 0:5.5.25-1.el6.remi\r\n\r\nComplete!\r\n<\/pre>\nStarting the MySQL Daemon Service<\/h2>\n
Once the installation is complete, the next step is to start the MySQL daemon service. Run the following command to do this:<\/p>\n
\r\nservice mysqld start\r\n<\/pre>\nYou should see a message indicating that the process has started successfully.<\/p>\n
\r\n[root@centos62 ~]# service mysqld start\r\nStarting mysqld: [ OK ]\r\n<\/pre>\nLogging into the Database<\/h2>\n
After starting the MySQL daemon service, you can log into the database using the following command:<\/p>\n
\r\nmysql -u root -p\r\n<\/pre>\nYou will be prompted to enter your password. After successful login, you will be welcomed to the MySQL monitor.<\/p>\n
\r\n[root@centos62 ~]# mysql -u root -p\r\nEnter password:\r\nWelcome to the MySQL monitor. Commands end with ; or \\g.\r\nYour MySQL connection id is 2\r\nServer version: 5.5.25 MySQL Community Server (GPL) by Remi\r\n\r\nCopyright (c) 2000, 2011, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nOracle is a registered trademark of Oracle Corporation and\/or its\r\naffiliates. Other names may be trademarks of their respective\r\nowners.\r\n\r\nType 'help;' or '\\h' for help. Type '\\c' to clear the current input statement.\r\n\r\nmysql> exit\r\n<\/pre>\nChecking Installed MySQL Related Packages<\/h2>\n
To verify the installation, you can check the existing MySQL installed related packages by running the following command:<\/p>\n
\r\nrpm -qa | grep mysql\r\n<\/pre>\nThis command will list all the installed MySQL related packages.<\/p>\n
\r\n[root@centos62 ~]# rpm -qa | grep mysql\r\ncompat-mysql51-5.1.54-1.el6.remi.i686\r\nmysql-libs-5.5.25-1.el6.remi.i686\r\nmysql-5.5.25-1.el6.remi.i686\r\nmysql-server-5.5.25-1.el6.remi.i686\r\n<\/pre>\nChecking MySQL Version<\/h2>\n
Finally, you can check the version of MySQL installed on your system by running the following command:<\/p>\n
\r\nmysql -V\r\n<\/pre>\nThis command will display the version of MySQL installed on your system.<\/p>\n
\r\n[root@centos62 ~]# mysql -V\r\nmysql Ver 14.14 Distrib 5.5.25, for Linux (i686) using readline 5.1\r\n[root@centos62 ~]#\r\n<\/pre>\nCommands Mentioned<\/h2>\n
\n
- yum install mysql mysql-server -y<\/span> \u2013 Installs the MySQL server packages.<\/li>\n
- service mysqld start<\/span> \u2013 Starts the MySQL daemon service.<\/li>\n
- mysql -u root -p<\/span> \u2013 Logs into the MySQL database.<\/li>\n
- rpm -qa | grep mysql<\/span> \u2013 Checks the installed MySQL related packages.<\/li>\n
- mysql -V<\/span> \u2013 Checks the version of MySQL installed.<\/li>\n<\/ul>\n
Conclusion<\/h2>\n
In conclusion, the Remi Repository is a valuable resource for CentOS users, providing and maintaining the latest versions of MySQL and PHP. This tutorial has guided you through the process of installing MySQL 5.5 on CentOS 6.2 using the Remi repository, from installing the MySQL Server packages to checking the version of MySQL installed on your system. By following these steps, you can ensure that you have the latest version of MySQL installed on your system, allowing you to take full advantage of the features and benefits that MySQL has to offer. Whether you’re running a VPS server<\/a> or a cloud hosting<\/a> service, understanding how to install and manage MySQL is a crucial skill for any webmaster or website administrator.<\/p>\n
FAQ<\/h2>\n
\n
- \n
What is the Remi Repository?<\/p>\n
\n The Remi Repository, also known as Les RPM de Remi repository, is a third-party repository for CentOS. It provides and maintains thelatest versions of MySQL and PHP, making it a valuable resource when you need the most recent version of the Linux Apache MySQL and PHP (LAMP) server.<\/span>\n <\/p>\n<\/li>\n
- \n
How do I install MySQL Server packages?<\/p>\n
\n You can install the MySQL Server packages by running the command ‘yum install mysql mysql-server -y’. This command will initiate the installation process, resolving dependencies, and running a transaction check.<\/span>\n <\/p>\n<\/li>\n
- \n
How do I start the MySQL daemon service?<\/p>\n
\n You can start the MySQL daemon service by running the command ‘service mysqld start’. You should see a message indicating that the process has started successfully.<\/span>\n <\/p>\n<\/li>\n
- \n
How do I log into the MySQL database?<\/p>\n
\n You can log into the MySQL database by running the command ‘mysql -u root -p’. You will be prompted to enter your password. After successful login, you will be welcomed to the MySQL monitor.<\/span>\n <\/p>\n<\/li>\n
- \n
How do I check the version of MySQL installed on my system?<\/p>\n
\n You can check the version of MySQL installed on your system by running the command ‘mysql -V’. This command will display the version of MySQL installed on your system.<\/span>\n <\/p>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"
The Remi Repository, also known as Les RPM de Remi repository, is a renowned third-party repository for CentOS. It is highly regarded for providing and maintaining the latest versions of…<\/p>\n","protected":false},"author":6,"featured_media":343,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"wds_primary_category":0,"footnotes":""},"categories":[2055,1008,2062],"tags":[1253,1536,1546,1585],"class_list":["post-3448","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-mysql","category-yum","tag-centos-6-2","tag-linux","tag-linux-utilities","tag-mysql"],"_links":{"self":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/3448","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/comments?post=3448"}],"version-history":[{"count":0,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/posts\/3448\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media\/343"}],"wp:attachment":[{"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/media?parent=3448"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/categories?post=3448"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webhostinggeeks.com\/howto\/wp-json\/wp\/v2\/tags?post=3448"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}