Install MySQL 5.5.13 on Fedora 15/14, CentOS/Red Hat (RHEL) 5.6/6

參考下篇: ref.

http://www.if-not-true-then-false.com/2010/install-mysql-on-fedora-centos-red-hat-rhel/

 

Install Remi repository
CentOS and Red Hat (RHEL)
## Remi Dependency on CentOS and Red Hat (RHEL)
rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm
 
Red Hat (RHEL) 6
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
 
## CentOS 5.6 and Red Hat (RHEL) 5.6 
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
Check Available MySQL versions
CentOS 5.6 and Red Hat (RHEL) 5.6/6
yum --enablerepo=remi,remi-test list mysql mysql-server
Update or Install MySQL 5.5.13
CentOS 5.6 and Red Hat (RHEL) 5.6
yum --enablerepo=remi,remi-test install mysql mysql-server
Start MySQL server and autostart MySQL on boot
/etc/init.d/mysqld start ## use restart after update
## OR ##
service mysqld start ## use restart after update
 
chkconfig --levels 235 mysqld on
MySQL Secure Installation
  • Set (Change) root password
  • Remove anonymous users
  • Disallow root login remotely
  • Remove test database and access to it
  • Reload privilege tables
Start MySQL Secure Installation with following command
/usr/bin/mysql_secure_installation

Note: If you don’t want some reason, do a “MySQL Secure Installation” then at least it’s very important to change the root user’s password

mysqladmin -u root password [your_password_here]
 
## Example ##
mysqladmin -u root password myownsecrectpass
 
Connect to MySQL database (localhost) with password
mysql -u root -p
 
## OR ##
mysql -h localhost -u root -p
Create Database, Create MySQL User and Enable Remote Connections to MySQL Database

This example uses following parameters:

  • DB_NAME = webdb
  • USER_NAME = webdb_user
  • REMOTE_IP = 10.0.15.25
  • PASSWORD = password123
  • PERMISSIONS = ALL
## CREATE DATABASE ##
mysql> CREATE DATABASE webdb;
 
## CREATE USER ##
mysql> CREATE USER 'webdb_user'@'10.0.15.25' IDENTIFIED BY 'password123';
 
## GRANT PERMISSIONS ##
mysql> GRANT ALL ON webdb.* TO webdb_user@'10.0.15.25';
 
##  FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES  ##
mysql> FLUSH

Enable Remote Connection to MySQL Server –> Open MySQL Port (3306) on Iptables Firewall (as root user again)

1. Edit /etc/sysconfig/iptables file:
nano -w /etc/sysconfig/iptables
2. Add following line before COMMIT:
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
 
3. Restart Iptables Firewall:
service iptables restart
## OR ##
/etc/init.d/iptables restart
 
4. Test remote connection:
mysql -h dbserver_name_or_ip_address -u webdb_user -p webdb
Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • MySpace
  • Plurk
  • RSS
  • Google Buzz
  • Live
本篇發表於 CentOS-Linux, server, Yum。將永久鏈結加入書籤。

發表迴響

你的電子郵件位址並不會被公開。 必要欄位標記為 *