Home>Article>Backend Development> How to solve php mysql 500 error problem

How to solve php mysql 500 error problem

藏色散人
藏色散人 Original
2020-08-01 09:51:06 3205browse

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.

How to solve php mysql 500 error problem

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


      

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn