MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. This is guide, howto install or upgrade MySQL Community Server latest and greatest version 5.5.18 on Fedora 16 (15,14,13, 12, 11, 10, 9, 8), CentOS 5.5 and Red Hat (RHEL) 5.5/6.
Follow steps given Below:-
1. Change root user
2. Install Remi repository
Fedora
## Remi Dependency on Fedora 16,15,14, 13, 12, 11, 10, 9, 8
rpm -Uvh http://download1.rpmfusion.org/free/fedora/rpmfusion-free-release-stable.noarch.rpm
rpm -Uvh http://download1.rpmfusion.org/nonfree/fedora/rpmfusion-nonfree-release-stable.noarch.rpm
## Fedora 16 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-16.rpm
## Fedora 15 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-15.rpm
## Fedora 14 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-14.rpm
## Fedora 13 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-13.rpm
## Fedora 12 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-12.rpm
## Fedora 11 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-11.rpm
## Fedora 10 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-10.rpm
## Fedora 9 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-9.rpm
## Fedora 8 ##
rpm -Uvh http://rpms.famillecollet.com/remi-release-8.rpm
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.5 and Red Hat (RHEL) 5.5
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
3. Check Available MySQL versions
Fedora 16,15,14
Fedora 16,15,14, (13, 12, 11, 10, 9, 8)
yum --enablerepo=remi list mysql mysql-server
CentOS 5.5 and Red Hat (RHEL) 5.5/6
yum --enablerepo=remi,remi-test list mysql mysql-server
4. Update or Install MySQL 5.5.10
Fedora 14 (13, 12, 11, 10, 9, 8, 7)
yum --enablerepo=remi install mysql mysql-server
CentOS 5.5 and Red Hat (RHEL) 5.5
yum --enablerepo=remi,remi-test install mysql mysql-server
5. 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
6. 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
7. Connect to MySQL database (localhost) with password
mysql -u root -p
## OR ##
mysql -h localhost -u root -p
8. 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 PRIVILEGES;
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
if You Enjoy the post ...then must like and share.....Enjoy.....
nice