Install mysql 5.5 centos 7

Remi Repository or Les RPM de Remi repository is one of the popular 3rd party repositories for CentOS. [See //rpms.famillecollet.com/] Remi repository provides and maintains the latest version of MySQL and PHP. Remi repository can be very useful
when you need the latest version of Linux Apache MySQL and PHP [LAMP] server. In this post, i will share on how to install MySQL 5.5 database on linux CentOS 6.2 using 3rd party repository, Remi repository.

Prerequisites :
How to Install Remi yum Repository on CentOS 6.2 x86 and x86_64

Simply run the following command to install latest MySQL Server packages :

[root@centos62 ~]# yum install mysql mysql-server -y
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
 * base: centos.ipserverone.com
 * extras: centos.ipserverone.com
 * remi: rpms.famillecollet.com
 * remi-test: rpms.famillecollet.com
 * updates: centos.ipserverone.com
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.5.25-1.el6.remi will be installed
--> Processing Dependency: mysql-libs[x86-32] = 5.5.25-1.el6.remi for package: mysql-5.5.25-1.el6.remi.i686
---> Package mysql-server.i686 0:5.5.25-1.el6.remi will be installed
--> Processing Dependency: libaio.so.1[LIBAIO_0.4] for package: mysql-server-5.5.25-1.el6.remi.i686
--> Processing Dependency: libaio.so.1[LIBAIO_0.1] for package: mysql-server-5.5.25-1.el6.remi.i686
--> Processing Dependency: libaio.so.1 for package: mysql-server-5.5.25-1.el6.remi.i686
--> Running transaction check
---> Package libaio.i686 0:0.3.107-10.el6 will be installed
---> Package mysql-libs.i686 0:5.5.25-1.el6.remi will be installed
--> Finished Dependency Resolution

Dependencies Resolved

====================================================================================================
 Package                   Arch              Version                        Repository         Size
====================================================================================================
Installing:
 mysql                     i686              5.5.25-1.el6.remi              remi              5.8 M
 mysql-server              i686              5.5.25-1.el6.remi              remi               10 M
Installing for dependencies:
 libaio                    i686              0.3.107-10.el6                 base               21 k
 mysql-libs                i686              5.5.25-1.el6.remi              remi              771 k

Transaction Summary
====================================================================================================
Install       4 Package[s]

Total download size: 17 M
Installed size: 77 M
Downloading Packages:
[1/4]: libaio-0.3.107-10.el6.i686.rpm                                        |  21 kB     00:00
[2/4]: mysql-5.5.25-1.el6.remi.i686.rpm                                      | 5.8 MB     12:36
[3/4]: mysql-libs-5.5.25-1.el6.remi.i686.rpm                                 | 771 kB     01:35
[4/4]: mysql-server-5.5.25-1.el6.remi.i686.rpm                               |  10 MB     21:41
----------------------------------------------------------------------------------------------------
Total                                                               8.0 kB/s |  17 MB     35:56
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mysql-libs-5.5.25-1.el6.remi.i686                                                1/4

WARNING : This MySQL RPM is not an official Fedora/Redhat build and it
overrides the official one. Don't file bugs on Fedora Project nor Redhat.
Use dedicated forums //forums.famillecollet.com/

  Installing : mysql-5.5.25-1.el6.remi.i686                                                     2/4
  Installing : libaio-0.3.107-10.el6.i686                                                       3/4
  Installing : mysql-server-5.5.25-1.el6.remi.i686                                              4/4

Installed:
  mysql.i686 0:5.5.25-1.el6.remi                mysql-server.i686 0:5.5.25-1.el6.remi

Dependency Installed:
  libaio.i686 0:0.3.107-10.el6                  mysql-libs.i686 0:5.5.25-1.el6.remi

Complete!

Start the MySQL daemon service :

[root@centos62 ~]# service mysqld start
Starting mysqld:                                           [  OK  ]

Login to database :

[root@centos62 ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.5.25 MySQL Community Server [GPL] by Remi

Copyright [c] 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> exit

Check existing MySQL installed related packages :

[root@centos62 ~]# rpm -qa | grep mysql
compat-mysql51-5.1.54-1.el6.remi.i686
mysql-libs-5.5.25-1.el6.remi.i686
mysql-5.5.25-1.el6.remi.i686
mysql-server-5.5.25-1.el6.remi.i686

Check mysql version :

[root@centos62 ~]# mysql -V
mysql  Ver 14.14 Distrib 5.5.25, for Linux [i686] using readline 5.1
[root@centos62 ~]#

How do I install MySQL on CentOS 7?

Guide To Installing MySQL on CentOS 7. Step 1: Download Repository Packages. Step 2: Add the Software Repositories. Step 3: Install MySQL..
Using MySQL. Managing MySQL Service. Find Temporary Password. Configuring and Securing. Log into MySQL..

What version of MySQL do I have CentOS 7?

Check MySQL Version with V Command. The easiest way to find the MySQL version is with the command: mysql -V. ... .
How to Find Version Number with mysql Command. The MySQL command-line client is a simple SQL shell with input editing capabilities. ... .
SHOW VARIABLES LIKE Statement. ... .
SELECT VERSION Statement. ... .
STATUS Command..

How do I start MySQL on CentOS 7?

To install MySQL 8 on CentOS 7, you follow these steps:.
Setup Yum repository. Execute the following command to enable MySQL yum repository on CentOS: ... .
Install MySQL 8 Community Server. ... .
Start MySQL Service. ... .
Show the default password for root user. ... .
MySQL Secure Installation. ... .
Restart and enable the MySQL service. ... .
Connect to MySQL..

How do you check MySQL is installed or not in CentOS 7?

Type mysql --version to see if it is installed.

Chủ Đề