MySQL database entry-level big check

The following articles mainly introduce the MySQL database entry series, that is, the actual steps for obtaining and installing the MySQL software correctly, the following appendix describes how to obtain and install the software required to run MySQL (the best combination with PHP) and the third-party software described in this document.

For example, Perl DBI and CGI. pm support environments, PHP, and apache (the most popular WEB server platform on Unix. This Appendix also describes how to obtain files related to the MySQL database sample used in this book.

This chapter aims to bring together the installation instructions for all packages, but does not replace the installation instructions attached to each package. In fact, we encourage you to read the notes that come with the package. This appendix provides a description that meets the requirements in most cases, but each software distribution package also contains instructions on how to Troubleshoot Failures when the independent installation process fails. For example, there are quite a few chapters in the MySQL (best combination with PHP) manual that describe the installation process, as well as solutions specifically for many system problems.

Select the content to install MySQL (the best combination with PHP)

If you have not installed MySQL (the best combination with PHP), you must install it, but you also need to install the following three tools:

If you want to write a script to access the MySQL (the best combination with PHP) database, you must install the MySQL (the best combination with PHP) Client programming support environment and DBI module. If you want to write a DBI script that provides Web access to the MySQL database, you should also install the CGI. pm module and need a Web server. This book uses apache (the most popular WEB server platform on Unix) servers, but other servers can also be used.

If you want to write a PHP script, you must install MySQL (the best combination with PHP). The client programming supports both the environment and PHP. PHP is generally used for Web scripting, which means a Web server is also required. This book uses apache (the most popular WEB server platform on the Unix platform) server, because apache (the most popular WEB server platform on the Unix platform) server has a PHP module support environment.

This indicates that PHP can be installed as an internal component of apache (the most popular WEB server platform on the Unix platform. If you cannot copy your apache (the most popular WEB server platform on Unix), for example, if you work on an ISP host while apache (the most popular WEB server platform on Unix) is controlled by the ISP), or is running another different Web server, you can set PHP as an independent program and run the PHP script as a standard CGI script. Using PHP as a module of apache (the most popular WEB server platform on the Unix platform) provides better performance than running it as an independent program.

Many installation packages can be pre-compiled. L I n ux provides various RPM files. If you prefer to compile the source program or the program distribution package is not available on your platform, you need a C compiler MySQL (the best combination with PHP) that requires C ++ ). MySQL (the best combination with PHP) Developers suggest using gcc 2.95.1 or an updated version to create MySQL (the best combination of PHP and PHP ). The egcs version is available in Versions later than 1.03.

Other required tools include gunzip and t a r if they are installed using compressed tar files) or rpm if they are installed using RPM files ).

Obtain MySQL (the best combination with PHP) Software

The main distribution points of each package are shown in the following table. Some packages can be obtained from multiple locations: package location
MySQL (best combination with PHP) http://www.MySQL (best combination with PHP ). com/ftp://ftp.MySQL (best combination with PHP ). com/pub/MySQL (the best combination with PHP )/
DBI http://www.symbolstone.org/technology/perl/DBI/

Http://www.MySQL (best combination with PHP). com/Contrib/

PHP http://www.php.net/

Ftp://ftp.php.net/

Apache (the most popular WEB server platform for Unix) http://www.apache (the most popular WEB server platform for Unix). org/ftp://ftp.apache (the most popular WEB server platform for Unix). org/
CGI. pm http://stein.cshl.org/WWW/software/CGI/

If you use FTP to transfer files, you should use binary to transfer them to avoid errors.

There are many mirror sites for MySQL (the best combination with PHP. W. mySQL (the best combination with PHP ). com is located in S c a n d I n a v I a. Therefore, if you select a site closest to you, the download time can be shortened. The following addresses list image sites:

Http://www.MySQL (best combination with PHP). com/mirrors.html

For Perl software, you can use h t p: // c p a n. per l. o rg/to find the image of the required module.

Select the version to install

Which package version should be installed based on requirements:

If you need great stability, the MySQL database should be conservative and use the latest stable non-B version of the software package. In this way, we can get new functions, but there are not many problems as B.

If you are adventurous or a developer, you may want to use the latest version B. Of course, if you require only some functions in Version B, there is no choice except to use this version.

For MySQL (the best combination with PHP), pre-compiled systems and RPM distribution packages are generally optimized and established, which is better than using the configuration scripts in the source program distribution package. MySQL (the best combination with PHP) developers also use some commercial optimization compilers that make MySQL (the best combination with PHP) faster to build distribution packages. Therefore, programs in these distribution packages may be faster than those compiled by you. If you want the best performance, try to use the pre-compiled distribution package.

The Web site of each Software Package specifies which versions are the latest stable release and which versions are the latest B release. They also provide a list of feature changes for previous versions to help determine which version is best for you.

If you are using a binary code or RPM distribution package, unlocking the distribution package is equivalent to installing it, because the unlocked file will enter the corresponding directory. If a file is mounted to a protected directory in the distribution package, you may need to open the distribution package as a root user.

For the source program distribution package, You can unpack it where it is used for compilation, and then install the software to the target address. Installation Steps may need to be completed as root, but not configuration or compilation steps ).

Subscription help email list

When installing a package, it is a good idea to subscribe to the comprehensive discussion table of the package, because you can ask questions and get answers through it. If you are installing Release B, you should be prepared to attend and read emails related to the software to get error reports and solutions at any time. If you do not participate in the comprehensive discussion, you should at least subscribe to the announcement to receive notifications from the new release. The instructions for booking email lists and using them are described in the introduction. The Web site of each package also provides reservation information.

If the source program is used for installation, several packages are configured with the configure utility, which makes it easy to set up and establish software on various systems. If the creation fails, you may need to provide different options for configure based on the original options. This is necessary, because it is necessary to prevent configure from using the information you saved when running it the previous time. You can clear the original configuration information as follows:

% Make distclean

You can also clear it as follows:

% Rm config. cache

% Make clean

You can re-run configure either way.

(Best combination with PHP) Getting Started series: Getting and installing MySQL (best combination with PHP) software "width =" 19 "height =" 16 "/> View the full set of" MySQL (the best combination with PHP) Tutorials ">>>>

The above content is an introduction to the MySQL database entry series: Getting and installing the MySQL software. I hope you will have some gains.