Linux Learning (i)------CentOS installation mysql5.5 Database

The specific methods and steps are as follows:

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

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

3.yum after mysql5.1, installation or 5.1, now 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 are required and now another

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

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

See below that the installation was successful.

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

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

7. Be sure to select Y when this thing appears. Otherwise God can not save you, will have to reinstall.

8. See this image below 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, save us 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. Check to see if MySQL was installed successfully. If the input sees the following interface, then you have installed successfully. Treat yourself to it.

Precautions

All commands must pay attention to capitalization.

Do not add spaces.

Be sure to do the above installation under the root user

Method Two:

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

1. Installing the 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/etc/yum.repos.d/mysql-community.repo file, change 5.5 to 1,5.6 enabled to 0

?

1234567891011121314

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

3. Installing 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 setting InnoDB to stand-alone tablespace mode, each table in each database generates a data directory

innodb_buffer_pool_size= Default value: 128M, set to OS memory 70%-80% best

Linux Learning (i)------CentOS installation mysql5.5 Database