MySQL Database server Setup

Guide

MySQL database is the most used database system on Linux operating system, it can be easily integrated with other servers, such as Apache, VSFTPD, Postfix and so on. The installation method for the Rhel 6 platform MySQL database server is described below.

The following RPM package files are required to install the full MySQL database:

1. Data API for Perl-dbi-1.609-4.e16.i686.rpm:perl languages
2. Perl-dbd-mysql-4.013-3.e16.i686.rpm:mysql interface package with Perl language
3. Mysql-5.1.61-4.e16.i686.rpm:mysql Database client program
4. Mysql-connector-odbc-5.1.5r1144-7.e16.i686.rpm:mysql Database with ODBC connector
5. Mysql-server-5.1.61-4.e16.i686.rpm:mysql Database Server Program

After copying the above files to the current directory, execute the following command to install them:

# RPM-IVH perl-dbi-1.609-4.e16.i686.rpm# RPM-IVH perl-dbd-mysql-4.013-3.e16.i686.rpm# RPM-IVH mysql-5.1.61-4.e16.i686.rpm# RPM-IVH mysql-connector-odbc-5.1.5r1144-7.e16.i686.rpm# RPM-IVH mysql-server-5.1.61-4.e16.i686.rpm

After successful installation, several important files about MySQL server Software are distributed as follows:

1. /etc/rc.d/init.d/mysqld:mysql Server Startup scripts
2. /usr/bin/mysqlshow: Displaying database, table, and column information
3. /USR/LIBEXEC/MYSQLD: server's process Program files
4. /usr/libexec/mysqlmanager: Instance Management Program Files
5. /usr/share/doc/: directory where the description file is stored
6. /usr/share/man/man 1/...: book m on the Storage manual page
7. /var/lib/mysql/: Server database File storage directory
8. /var/log/mysqld.log:mysql log files for the server

In order to run MySQL, you can enter the following command:

#/etc/rc.d/init.d/mysqld Start

Then enter the following command to see if the process starts:

#ps-eaf | grep mysqld

Once the process has started, you can use the command to see if the MYSQLD default listening port is open:

# NETSTAT-ANLP | grep 3306tcp     0      0 0.0.0.0:3306       0.0.0.0:*     LISTEN        1121/mysqld

As you can see, Port 3306 is already open, and to ensure that clients on the network can access the MySQL server, enter the following command to open this port:

# iptables-i input-p TCP--dport  3306  -j  ACCEPT

Once the above process is complete, you can connect to the MySQL server via the client. Finally, to ensure that the server is up and running, you can enter the following command to view:

# mysqladmin Version

When the version details appear, the MySQL server is running correctly.

This article was reproduced from: http://www.linuxprobe.com/mysql-database-server-set-up/
Free to provide the latest Linux technology tutorials Books, for open-source technology enthusiasts to do more and better: http://www.linuxprobe.com/

MySQL Database server Setup