MySQL
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.28 on CentOS 6 and
Red Hat (RHEL) 6.
Install MySQL Database 5.5.28 on CentOS
6/5, Red Hat (RHEL) 6/5
1. Change
root user
su -
CentOS and Red Hat (RHEL)
Run the
following command defined with your Operating system
## Remi Dependency on CentOS 6 and Red Hat
(RHEL) 6 ##
rpm -Uvh
http://download.fedoraproject.org/pub/epel/6/i386/epel-release-6-7.noarch.rpm
## CentOS 6 and Red Hat (RHEL) 6 ##
rpm -Uvh
http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
## Remi Dependency on CentOS 5 and Red Hat
(RHEL) 5 ##
rpm -Uvh
http://dl.fedoraproject.org/pub/epel/5/i386/epel-release-5-4.noarch.rpm
## CentOS 5 and Red Hat (RHEL) 5 ##
rpm -Uvh
http://rpms.famillecollet.com/enterprise/remi-release-5.rpm
3. Check
Available MySQL versions
yum
--enablerepo=remi,remi-test list mysql mysql-server
Output:
Loaded
plugins: changelog, fastestmirror, presto, refresh-packagekit
...
remi
| 3.0 kB 00:00
remi/primary_db | 106
kB 00:00
Available
Packages
mysql.i686
5.5.28-1.fc14.remi @remi
mysql-server.i686 5.5.28-1.fc14.remi @remi
4. Install
MySQL 5.5.28
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 or 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
Output:
NOTE:
RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL
SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
In order to
log into MySQL to secure it, we\'ll need the current
password for
the root user. If you\'ve just installed
MySQL, and
you haven\'t
set the root password yet, the password will be blank,
so you
should just press enter here.
Enter
current password for root (enter for none):
OK,
successfully used password, moving on...
Setting the
root password ensures that nobody can log into the MySQL
root user
without the proper authorisation.
Set root
password? [Y/n] Y
New
password:
Re-enter new
password:
Password
updated successfully!
Reloading
privilege tables..
... Success!
By default,
a MySQL installation has an anonymous user, allowing anyone
to log into
MySQL without having to have a user account created for
them. This is intended only for testing, and to
make the installation
go a bit
smoother. You should remove them before
moving into a
production
environment.
Remove
anonymous users? [Y/n] Y
... Success!
Normally,
root should only be allowed to connect from 'localhost'. This
ensures that
someone cannot guess at the root password from the network.
Disallow
root login remotely? [Y/n] Y
... Success!
By default,
MySQL comes with a database named 'test' that anyone can
access. This is also intended only for testing, and
should be removed
before
moving into a production environment.
Remove test
database and access to it? [Y/n] Y
- Dropping test database...
... Success!
- Removing privileges on test database...
... Success!
Reloading
the privilege tables will ensure that all changes made so far
will take
effect immediately.
Reload
privilege tables now? [Y/n] Y
... Success!
Cleaning
up...
All
done! If you\'ve completed all of the
above steps, your MySQL
installation
should now be secure.
Thanks for
using MySQL!
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 = xyz
USER_NAME = xyzuser
REMOTE_IP = 192.168.1.10
PASSWORD = 12345
PERMISSIONS = ALL
## CREATE DATABASE ##
mysql>
CREATE DATABASE xyz;
## CREATE USER ##
mysql>
CREATE USER xyzuser'@'192.168.1.10' IDENTIFIED BY '12345';
## GRANT PERMISSIONS ##
mysql>
GRANT ALL ON xyz.* TO 'xyzuser'@'192.168.1.10';
##
FLUSH PRIVILEGES, Tell the server TO reload the GRANT TABLES ##
mysql>
FLUSH PRIVILEGES;
9. 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 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 xyzuser -p xyz
0 comments:
Post a Comment