Install MySQL 5.5 with Yum (for centos6.2/5.8 and Fedora 17/16 platforms)

Currently centos/red Hat (RHEL) 6.2 officially comes with the MySQL version for 5.1,mysql5.5 has come out.

The improvements are not only made in several ways compared to mysql5.1,mysql5.5:

• The performance has improved a lot.
• Change the default storage engine to InnoDB
• CPU multi-core processing performance improvement
• Enhanced replication, new semi-synchronous replication
• Enhanced table partitioning Capabilities
• Wait a minute

This article will guide you on how to install the latest version of the community version of MySQL under centos/red Hat (RHEL) 6.2 and Fedora 17/16. If you are upgrading MySQL, please back up your data and configuration files before upgrading. Installing MySQL 5.5 in centos/red Hat (RHEL) 6.2/5.8 and Fedora 17/16 let's get started. Step1. Switch to root user [Plain]View Plaincopy

1. Su-
2. # # OR # #
3. Sudo-i

Step2. Installing the Remi Software source Fedora Platform [Plain]View Plaincopy

2. # # Remi Dependency on Fedora 17, 16, 15
4. RPM-UVH http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
6. RPM-UVH http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
10. # # Fedora 17 # #
12. RPM-UVH http://rpms.famillecollet.com/remi-release-17.rpm
16. # # Fedora 16 # #
18. RPM-UVH http://rpms.famillecollet.com/remi-release-16.rpm
22. # # Fedora 15 # #
24. RPM-UVH http://rpms.famillecollet.com/remi-release-15.rpm
28. # # Fedora 14 # #
30. RPM-UVH http://rpms.famillecollet.com/remi-release-14.rpm
34. # # Fedora 13 # #
36. RPM-UVH http://rpms.famillecollet.com/remi-release-13.rpm
40. # # Fedora 12 # #
42. RPM-UVH http://rpms.famillecollet.com/remi-release-12.rpm

CentOS and Red Hat (RHEL) platforms [Plain]View Plaincopy

2. # # Remi Dependency on CentOS 6 and Red Hat (RHEL) 6 # #
4. RPM-UVH http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
8. # # CentOS 6 and Red Hat (RHEL) 6 # #
10. RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
14. # # Remi Dependency on CentOS 5 and Red Hat (RHEL) 5 # #
16. RPM-UVH http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
20. # # CentOS 5 and Red Hat (RHEL) 5 # #
22. RPM-UVH http://rpms.famillecollet.com/enterprise/remi-release-5.rpm

Step3. View MySQL version number Fedora 17, 16, 15, 14, 13, 12 [Plain]View Plaincopy

1. Yum--enablerepo=remi list MySQL Mysql-server

CentOS 6.2/6.1/6/5.8 and Red Hat (RHEL) 6.2/6.1/6/5.8
[Plain]View Plaincopy

1. Yum--enablerepo=remi,remi-test list MySQL Mysql-server

Output:
[Plain]View Plaincopy

2. Loaded Plugins:changelog, Fastestmirror, Presto, Refresh-packagekit
4. ...
6. Remi | 3.0 KB 00:00
8. remi/primary_db | 106 KB 00:00
10. Available Packages
12. mysql.i686 5.5.25-1.fc14.remi @remi
14. mysql-server.i686 5.5.25-1.fc14.remi

Step4. Install or upgrade to MySQL5.5.25
Fedora 17, 16, 15, 14, 13, 12 [Plain]View Plaincopy

1. Yum--enablerepo=remi install MySQL Mysql-server

CentOS 6.2/6.1/6/5.8 and Red Hat (RHEL) 6.2/6.1/6/5.8
[Plain]View Plaincopy

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

Step5. Turn on the MySQL service and configure the self-boot
Fedora 17/16 [Plain]View Plaincopy

1. Systemctl Start Mysqld.service
2. Systemctl Enable Mysqld.service

Fedora 15/14/13/12/11, CentOS 6.2/6.1/6/5.8 and Red Hat (RHEL) 6.2/6.1/6/5.8 [Plain]View Plaincopy

1. /etc/init.d/mysqld start
2. # # OR # #
3. Service mysqld Start
4. Chkconfig--levels 235 mysqld on

Step6. MySQL Security Settings

• Set (Modify) root password
• Delete anonymous user
• Disable root Telnet
• Delete Test Database Tests
• Overloaded Permissions Table

To enable MySQL security settings, enter the following command
[Plain]View Plaincopy

1. /usr/bin/mysql_secure_installation

Output [Plain]View Plaincopy

2. Note:running all PARTS of this SCRIPT are RECOMMENDED for all MySQL
4. SERVERS in PRODUCTION use! Please READ each STEP carefully!
10. In order-to-log into MySQL-secure it, we\ ' ll need the current
12. Password for the root user. If you\ ' ve just installed MySQL, and
14. You haven\ ' t set the root password yet, the password would be blank,
16. So, should just press ENTER here.
20. Enter current password to root (enter for none):
22. OK, successfully used password, moving on ...
26. Setting The root password ensures that nobody can log into the MySQL
28. Root user without the proper authorisation.
32. Set root Password? [y/n] Y
34. New Password:
36. Re-enter new password:
38. Password Updated successfully!
40. Reloading privilege tables.
42. ... success!
48. By default, a MySQL installation have an anonymous user, allowing anyone
50. To log into MySQL without has to has a user account created for
52. them. This was intended only for testing, and the installation
54. Go a bit smoother. You should remove them before moving into a
56. Production environment.
60. Remove anonymous users? [y/n] Y
62. ... success!
66. Normally, Root should only is allowed to connect from ' localhost '. This
68. Ensures that someone cannot guess at the root of password from the network.
72. Disallow Root login remotely? [y/n] Y
74. ... success!
78. By default, MySQL comes with a database named ' test ' that anyone can
80. Access. This was also intended only for testing, and should be removed
82. Before moving into a production environment.
86. Remove test database and access to it? [y/n] Y
88. -Dropping test database ...
90. ... success!
92. -Removing privileges on test database ...
94. ... success!
98. Reloading the privilege tables would ensure that all changes made so far
100. would take effect immediately.
104. Reload privilege tables now? [y/n] Y
106. ... success!
110. Cleaning up ...
118. All done! If you\ ' ve completed all of the above steps, your MySQL
120. Installation should now is secure.
124. Thanks for using mysql!

Note: If you do not want to start the MySQL security Settings command, but at least you have to change the root user password [Plain]View Plaincopy

1. mysqladmin-u root password [your_password_here]
2. # # example # #
3. Mysqladmin-u Root Password Myownsecrectpass

Step7. Connect a local database with a password

[Plain]View Plaincopy

1. Mysql-u root-p
2. # # OR # #
3. Mysql-h Localhost-u Root-p

Step8. Specifies the user configuration for the specified database, specifying client (IP) remote access

The configuration parameters for this example are as follows
[Plain]View Plaincopy

1. Db_name = WebDB
2. user_name = Webdb_user
3. REMOTE_IP = 10.0.15.25
4. PASSWORD = password123
5. PERMISSIONS = All

1. Create a database WebDB
[Plain]View Plaincopy

1. mysql> CREATE DATABASE webdb;

2. Create User Webdb_user
[Plain]View Plaincopy

1. mysql> CREATE USER ' webdb_user ' @ ' 10.0.15.25 ' identified by ' password123 ';

3. Authorization
[Plain]View Plaincopy

1. Mysql> GRANT all on webdb.* to [email protected] ' 10.0.15.25 ';

4. Overloaded Permissions Table
[Plain]View Plaincopy

1. mysql> FLUSH privileges;

Step9. Configure the firewall to turn on 3306 Port 1. To modify the/etc/sysconfig/iptables file:
[Plain]View Plaincopy

1. Vi/etc/sysconfig/iptables

2. Add the following before commit:
[Plain]View Plaincopy

1. -A input-m state--state new-m tcp-p TCP--dport 3306-j ACCEPT

3. Restart Iptables:
[Plain]View Plaincopy

1. Service Iptables Restart
2. # # OR # #
3. /etc/init.d/iptables restart

4. Test the remote Access database on the client computer:
[Plain]View Plaincopy

1. Mysql-h dbserver_name_or_ip_address-u webdb_user-p WebDB

********************************************
* Ye Wentao
* Link: Install MySQL 5.5* source in centos/red Hat (RHEL) 6.2/5.8 and Fedora 17/16: Install MySQL 5.5.25 on Fedora 17/16, centos/red Hat (RH EL) 6.2/5.8
Reprint please indicate source ***************

Install MySQL 5.5 with Yum (for centos6.2/5.8 and Fedora 17/16 platforms)