Phpmyadmin error the mysql extension is missing
Moderator: General Moderators
Phpmyadmin error the mysql extension is missing
I have installed and configured Apache, PHP, & MySQL separately all appear to be running just fine but I have been unable to get phpmyadmin to run. phpinfo() runs just fine though it’s showing me some weird stuff. For example it says the php ini file is located at C:\WINDOWS but there absolutely is no such file to be found at C:\WINDOWS. In fact the only place a php.ini file can be found is C:\PHP and also in the download copy in the Downloads folder, also seems I’ve ended up with a copy in the Apache/htdocs/ folder. So apparently I don’t understand where phpinfo() gets its values i.e. “Configuration File (php.ini) Path” = C:\WINDOWS.
I’m thinking that maybe because of the method of downloading and duplicating file such as php.ini during the setup process perhaps the .ini file it’s reading isn’t necessarily the file I’m changing i.e. uncommentinting the mysql entries. Why does phpinfo() think php.ini is located at c:\WINDOWS
In any event when I try to go to localhost/phpmyadmin/ I get the following error
PHPmyadmin error
The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
Also I’m not really getting the href reference
I’m thinking that maybe because of the method of downloading and duplicating file such as php.ini during the setup process perhaps the .ini file it’s reading isn’t necessarily the file I’m changing i.e. uncommentinting the mysql entries. Why does phpinfo() think php.ini is located at c:\WINDOWS
In any event when I try to go to localhost/phpmyadmin/ I get the following error
PHPmyadmin error
The mysqli extension is missing. Please check your PHP configuration. <a href="Documentation.html#faqmysql" target="documentation"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a>
Also I’m not really getting the href reference
Re: Phpmyadmin error the mysql extension is missing
PHP will claim to be looking in C:\Windows if it can't find a php.ini.
You're sure there is a C:\PHP\php.ini, that being the directory where you have PHP installed? And it's not php.ini-development or php.ini-production but really php.ini?
You're sure there is a C:\PHP\php.ini, that being the directory where you have PHP installed? And it's not php.ini-development or php.ini-production but really php.ini?
Re: Phpmyadmin error the mysql extension is missing
Thanks for your reply,
Yes there is a php.ini file also a php.ini-development and a php.ini-production file. Also if I remember correctly the php.ini is just a copy of php.ini-development, or maybe it was php.ini-production that has been renamed
Like I said I suspect maybe it’s looking at something I’m not aware of. One of the problems is I’ve been tinkering around with this so long I lose track of what I’ve changed at some point I have uncommented “;extension=mysql.dll” and any other reference to mysql I can find in the php.ini file but since PHP appear to be unable to find the php.ini file. So where does it get it’s location for the php.ini file?
Yes there is a php.ini file also a php.ini-development and a php.ini-production file. Also if I remember correctly the php.ini is just a copy of php.ini-development, or maybe it was php.ini-production that has been renamed
Like I said I suspect maybe it’s looking at something I’m not aware of. One of the problems is I’ve been tinkering around with this so long I lose track of what I’ve changed at some point I have uncommented “;extension=mysql.dll” and any other reference to mysql I can find in the php.ini file but since PHP appear to be unable to find the php.ini file. So where does it get it’s location for the php.ini file?
Re: Phpmyadmin error the mysql extension is missing
The configuration file
When you installed and configured Apache and PHP, and where you tell Apache to load the PHP module, did you include a
When you installed and configured Apache and PHP, and where you tell Apache to load the PHP module, did you include a
Code: Select all
PHPIniDir C:\PHPRe: Phpmyadmin error the mysql extension is missing
Yes if I understand what you’re asking I have added these lines to the httpd.conf file idouble checked after you asked and saw that I had been using forward slashes and then changed them to back slashes like you see here
Code: Select all
LoadModule php5_module "c:\php\php5apache2_4.dll"
AddHandler application/x-httpd-php .php
PHPIniDir 'c:\php"
Re: Phpmyadmin error the mysql extension is missing
darn I was really hoping that was gonna do it but still throwing the same phpmyadmin error ...
Code: Select all
The mysqli extension is missing...yada, yada, yada...
Re: Phpmyadmin error the mysql extension is missing
But does phpinfo() show the right path?
Re: Phpmyadmin error the mysql extension is missing
OK I appolagize I’m still getting familiar with php.
“Configuration File (php.ini) Path” is still showing “C:\WINDOWS”
However “Loaded Configuration File”, and I only just noticed this, is showing: “C:\PHP\php.ini”
“Configuration File (php.ini) Path” is still showing “C:\WINDOWS”
However “Loaded Configuration File”, and I only just noticed this, is showing: “C:\PHP\php.ini”
Re: Phpmyadmin error the mysql extension is missing
Alright, so it definitely has the right file now.
Did you uncomment the extension=php_mysqli.dll line?
Did you uncomment the extension=php_mysqli.dll line?
Re: Phpmyadmin error the mysql extension is missing
Hey thanks for your help, it looks like I finally stumbled on the fix. Hey even a blind squrel finds a nut one in a while.
I was reading through the php.ini file searching the occurences of “extension” and I found the examples for loading extensions dynamicly so I copied the windows example and added it below the list of extension in the Dynamic Extensions section of the file so in the copied line I added the full path to the .dll file…
extension=C:\PHP\ext\php_mysqli.dll
Again, thanks a bunch for your help sometimes you just need someone to prompt you to keep digging and going over stuff you’ve already looked at a hundred times.
I was reading through the php.ini file searching the occurences of “extension” and I found the examples for loading extensions dynamicly so I copied the windows example and added it below the list of extension in the Dynamic Extensions section of the file so in the copied line I added the full path to the .dll file…
extension=C:\PHP\ext\php_mysqli.dll
Again, thanks a bunch for your help sometimes you just need someone to prompt you to keep digging and going over stuff you’ve already looked at a hundred times.