MySQL is a relational database management system developed by the Swedish MySQL AB company and is currently a product 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.
Installing a complete MySQL database requires the following RPM package files:
perl-DBI- 1.609-4.e16.i686.rpm: Perl language data API
perl-DBD-MySQL-4.013-3.e16.i686.rpm: MySQL and Perl language interface program Package
mysql-5.1.61-4.e16.i686.rpm:MySQL database client program
mysql-connector-odbc- 5.1.5r1144-7.e16.i686.rpm:Connector between MySQL database and ODBC
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 commands in order 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 the installation is successful, the relevant Several important files of the MySQL server software are distributed as follows:
In order to run mysql, you can enter the following command:
# /etc/rc.d/init.d/mysqld start
Then enter the following command to check whether the process is started:
#ps -eaf | grep mysqld
When the process is started, you can use the following command to check the mysqld default Check whether the listening port has been opened:
# netstat -anlp | grep 3306tcp 0 0 0.0.0.0:3306 0.0.0.0:* LISTEN 1121/mysqld
It can be seen that port 3306 is already open. In order 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
Finally, in order to ensure that the server has started normally, you can enter the following command to check:
# mysqladmin version
The above is the detailed content of How to quickly deploy a MySQL database server. For more information, please follow other related articles on the PHP Chinese website!