MySQL Database Server Install and Monitoring?
Step 1: Installing Remi
Repository
For
RHEL / CentOS 6-5
Step 2. Checking MySQL
5.5.30 Availability
Sample
Output:
Updating or
Installing MySQL 5.5.30
Step 4: Starting/Stopping
MySQL Server
Step 5: Connecting to
MySQL Server
Sample
Output:
Step 1: Installing Remi
Repository
Firstly, we need to install the Remi repository on your selected Linux
distributions.
For
RHEL / CentOS 6-5
## Install Remi Repository on RHEL/CentOS 6.7-6.0 ##
rpm -Uvh http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
## Install Remi Repository on RHEL/CentOS 5.4-5.0 ##
rpm -Uvh http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
Step 2. Checking MySQL
5.5.30 Availability
After, installing Remi repository on your system, then look
for MySQL latest version using –enablerepo=remi switch option.
# yum --enablerepo=remi list mysql mysql-server
Sample
Output:
Available Packages
mysql.i686 5.5.30-1.el6.remi remi
mysql-server.i686 5.5.30-1.el6.remi remi
Updating or
Installing MySQL 5.5.30
Once you see the latest MySQL version is
available for installation, then follow below steps to update or install MySQL
5.5.30.
# yum --enablerepo=remi install mysql mysql-server
Step 4: Starting/Stopping
MySQL Server
Follow the below command to start/stop of the
MySQL service.
# /etc/init.d/mysqld start
# /etc/init.d/mysqld stop
# /etc/init.d/mysqld status
Step 5: Connecting to
MySQL Server
Connecting to newly installed MySQL server by
providing username and password. If you haven’t yet set any password for your
MySQL installation the simply hit enter.
# mysql -u root -p
Sample
Output:
[root@twiki ~]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1052
Server version: 5.5.30 MySQL Community Server (GPL) by Remi
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
mysql>
That’s it, you’ve successfully installed MySQL
5.5.30 on your
system. If you’re having any trouble installing feel free to use our comment
section for solutions.
No comments:
Post a Comment