How to solve the php connection mysql 500 error problem

Solution to php connection mysql 500 error: 1. Enter the ext/mysql directory of the php source code; 2. Run phpize; 3. Run configure; 4. Compile and install to generate mysql.so; 5. Add mysql .so extension configuration; 6. Restart php-fpm.

The operating environment of this article: windows7 system, PHP7.1 version, DELL G3 computer

How to solve the php connection mysql 500 error problem ?

The mysql_connect() function is not available when PHP connects to mysql, and a 500 error is reported

I did not install the mysql extension when setting up the environment, but today when maintaining a project, If an error occurs

Fatal error: Uncaught Error: Call to undefined function mysql_connect()

You can use the phpize tool to manually compile and generate the mysql.so extension to solve the problem

The following are the steps:

1. Enter the ext/mysql directory of the PHP source code

cd /home/oldboy/tools/php-5.5.32/ext/mysql/

2. Run phpize and generate a configure file in this directory (php installation directory: /application/php/)

/application/php/bin/phpize

3. Run configure and specify the location of the php-config file (/ application/php/bin/php-config) and mysql installation directory

 ./configure --with-php-config=/application/php/bin/php-config --with-pdo-mysql=mysqlnd

4. Compile and install, generate mysql.so

make && make install

5. Modify the php.ini file and add the mysql.so extension Configuration, save and exit

extension=mysql.so

6. Restart php-fpm

service php-fpm restart

7. Test, add php files in the web directory, such as /usr/local/nginx/html/mysql.php

<?php
$con = mysql_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;);
if($con){
    die(&#39;ok&#39;);
}else{
    die(&#39;Could not connect: &#39; . mysql_error());
}

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to solve the php connection mysql 500 error problem. For more information, please follow other related articles on the PHP Chinese website!