*SOLVED* Problem installing MYSQL with PHP
Posted 07 July 2006 - 05:54 AM
I have installed Apache/PHP5 and Mysql from scratch and have apache and php5 working well. It's installed on an XP box used just for development. I'm able to serve up phpinfo fine. I am also able to use mysql to run on the command line. I've uncommented extension=php_mysql.dll in php.ini but I can't for the life of me get phpinfo to show the mysql info. I'm able to manipulate the php.ini file to change other extensions, but not mysql or mysqli, and the dll's are in the right spot. Any help? I wish i could show you, but like i said, it's a development machine and not online. Thanks in advance.
Posted 07 July 2006 - 01:50 PM
EDIT: FWIW, I followed http://www.expertsrt...all-apache.html these instructions to the t to get this all set up...everything else works great, and the install directory is exactly the same as these instructions.
Posted 07 July 2006 - 02:31 PM
Also verify that PHP is using the correct php.ini too, by running the phpinfo function. Check that Configuration File (php.ini) Path is pointing to the correct folder in which your php.ini file is located in. If PHP is not pointing to the correct php.ini file then, Add the following line:
PHPIniDir "C:/php"Change C:/php to the correct folder location in which the php.ini file is located in. Restart Apache and check that php is using the correct php.ini file.
If it is using the correct php.ini and mysql extension still isn't loaded, Check that the extension_dir setting is point to PHPs extension folder which stores all your extensions in. Also find display_startup_errors = off and change off to on. Save your php.ini and restart Apache. If PHP is having any trouble loading up it should popup a little error message with whats wrong.
Posted 07 July 2006 - 02:57 PM
PHP Startup: Unable to load dynamic library 'D:\Web\WebServer\PHP\ext\php_mysql.dll' - The specified procedure could not be found.
However, when I look in that directory for that file (as well as the 10 others that are giving me the same message because I uncommented all the extensions) that file is located in that directory. This does not happen for all of the extensions though, so I'm at a loss for what to do next. Thanks for your continued help!
Posted 07 July 2006 - 04:13 PM
For now just enable two extensions, suhc as GD2 and MySQL and copy libmysql.dll file to your WINDOWS folder. Restart Apache. Does PHP now load up the extension.
Posted 07 July 2006 - 05:42 PM
Posted 07 July 2006 - 06:28 PM
Also I had a read through the tutorial you linked to and that is fine, everything said in that tutorial is what I do when I setup Apache, PHP and MySQL.
Posted 07 July 2006 - 06:32 PM
Posted 08 July 2006 - 04:23 AM
Posted 08 July 2006 - 11:45 AM
Also I'll mark this as solved for you.
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users