CentOS 6.5 Yum Installation MySQL-5.5 full process graphics and text tutorial _mysql

Installing MySQL in Linux is a difficult thing, yum installation is generally installed mysql5.1, now through their own unremitting efforts to finally be able to install mysql5.5 with Yum. The following two ways to introduce CentOS 6.5 yum installation MySQL-5.5 the whole process, together to learn.

Method One:

The specific methods and steps are as follows:

1. The first step is to see whether the Linu installed MySQL, after rpm-qa|grep mysql check see CentOS installed under the mysql5.1, then start unloading

2. The next step is to uninstall mysql5.1, command: Rpm-e mysql-libs--nodeps

After 3.yum mysql5.1, installation or 5.1, now you need to add a new repo

RPM-UVH http://mirror.steadfast.net/epel/6/i386/epel-release-6-8.noarch.rpm

4. A total of two additional repo is required and now another

RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-6.rpm

5. Now check to see if some of the increases were successful, yum--enablerepo=remi,remi-test list MySQL Mysql-server

See below these are installed successfully.

6. The next step is to install the mysql5.5.

Yum--enablerepo=remi,remi-test install MySQL Mysql-server

7. Be sure to choose y when this thing appears. Or God will not save you, will be reinstalled.

8. See the following picture to prove that your MySQL installation was successful.

9. Next you need to start MySQL

/etc/init.d/mysqld start

10. The following command is set to boot from the start, the province of every time we boot up to start MySQL.

Chkconfig--levels 345 mysqld on

11. To enable MySQL security settings, enter the following command

/usr/bin/mysql_secure_installation

12. To verify that MySQL was installed successfully. If the input sees the following interface, then you are installed successfully. Give yourself a treat.

Attention matters

All commands must pay attention to the case

Do not add any space.

Be sure to install the above root user

Method Two:

Installing MySQL in Linux is a difficult thing, yum installation is generally installed mysql5.1, now through their own unremitting efforts to finally be able to install with Yum mysql5.5,

1. Installation of mysql-5.5 Yum source

RPM-IVH http://repo.mysql.com/yum/mysql-5.5-community/el/6/x86_64/mysql-community-release-el6-5.noarch.rpm

2. Modify the installed Yum source

Edit the/etc/yum.repos.d/mysql-community.repo file to change the 5.5 to 1,5.6 enabled to 0

# Enable to use MySQL 5.5
[mysql55-community]
name=mysql 5.5 Community Server
baseurl=http:// repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/ Rpm-gpg/rpm-gpg-key-mysql
# Enable to use MySQL 5.6
[mysql56-community]
name=mysql 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=0
gpgcheck=1

3. Install mysql-5.5

Yum install mysql-community-client mysql-community-devel mysql-community-server php-mysql

4. Adjust the configuration

Edit/etc/my.cnf File

Innodb_file_per_table=1 set InnoDB as a standalone tablespace mode, each table in each database generates a data directory

innodb_buffer_pool_size= Default value: 128M, set to operating system memory 70%-80% Best