RHEL 6 Platform Mysql database Server installation Method _mysql

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 following describes the installation method for the Rhel 6 platform MySQL database server.

1, the installation of a complete MySQL database requires the following RPM package files:

Data APIs for Perl-dbi-1.609-4.e16.i686.rpm:perl languages
Interface packages for Perl-dbd-mysql-4.013-3.e16.i686.rpm:mysql and Perl languages
Mysql-5.1.61-4.e16.i686.rpm:mysql Database client program
Mysql-connector-odbc-5.1.5r1144-7.e16.i686.rpm:mysql Database and ODBC connectors
Mysql-server-5.1.61-4.e16.i686.rpm:mysql Database Server Program

2. After copying the above files to the current directory, execute the following commands to install them sequentially:

# 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

3, after the successful installation, the MySQL server software for several important documents are distributed as follows:

/etc/rc.d/init.d/mysqld:mysql Server Startup script
/usr/bin/mysqlshow: Displaying database, table, and column information
/USR/LIBEXEC/MYSQLD: Server's Process program file
/usr/libexec/mysqlmanager: Instance Management Program Files
/usr/share/doc/: directory where the description file is stored
/usr/share/man/man 1/...: the catalogue m of the store manual page
/var/lib/mysql/: Server database File storage directory
Log file for/var/log/mysqld.log:mysql 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

When the process is started, you can use the command to see if the mysqld default listening port is open :

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

Visible, 3306 ports are already open, to ensure that clients on the network can access the MySQL server , you can 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 through the client. Finally, to ensure that the server starts properly, you can enter the following command to view:

# mysqladmin Version

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

Wonderful topic sharing: MySQL different versions of the installation Tutorials mysql5.7 version Installation Tutorials

The above is about MySQL database server installation method of detailed introduction, I hope to help you learn.