How to solve php mysql 500 error problem

php mysql 500 error solution: first enter the "ext/mysql" directory of the php source code; then run phpize; then compile and install through the command "make && make install" to generate "mysql.so"; finally Just modify the "php.ini" file.

Recommended: "PHP Video Tutorial"

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

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

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

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

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 to generate a configure file (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 the 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, add the mysql.so extension configuration, save and exit

extension=mysql.so

6. Restart php-fpm

service php-fpm restart

7. To test, add the php file 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());
}

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