Shulou(Shulou.com)06/01 Report--

MySQL is a relational database management system developed by the Swedish company MySQL AB and currently belongs to the products of Oracle. MySQL is one of the most popular relational database management systems. In terms of WEB applications, MySQL is the best RDBMS (relational database management system) application software.

The following RPM package files are required to install a complete MySQL database:

Perl-DBI-1.609-4.e16.i686.rpm:Perl data APIperl-DBD-MySQL-4.013-3.e16.i686.rpm:MySQL and Perl language interface package 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 connector 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:

# 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 a successful installation, several important files about the MySQL server software are distributed as follows:

/ etc/rc.d/init.d/mysqld:MySQL server startup script / usr/bin/mysqlshow: display database, table and column information / usr/libexec/mysqld: server process program file / usr/libexec/mysqlmanager: instance management program file / usr/share/doc/: directory where instruction files are stored / usr/share/man/man 1 /... The directory of the man page / var/lib/mysql/: server database file storage directory / var/log/mysqld.log:MySQL server log file

To run mysql, 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 starts, you can use the command to see if the default listening port of mysqld is open:

# netstat-anlp | grep 3306tcp 0 0 0.0.0.0 grep 3306tcp 3306 0.0.0 0 LISTEN 1121/mysqld

It can be seen that port 3306 is already open. To ensure that clients on the network can access the MySQL server, type the following command to open this port:

# iptables-I INPUT-p tcp-- dport 3306-j ACCEPT

After the above process is complete, you can connect to the MySQL server through the client. Finally, to ensure that the server has started properly, you can view it by entering the following command:

# mysqladmin version

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

Here is, the editor will push for you more related knowledge points of the article, welcome to follow!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.