• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1063
  • Last Modified:

PHPmyadmin

When combining Apache, MySQL, PHP, and PHPmyadmin, there is a host of users reporting:

Can't load MySQL extensions. Check PHP configuration.

None of the suggested rededies seem to work for me to solve this 'final set up problem'.
Does anyone know if Vista could be a cause of same?
I have not elected to go down the WAMP route yet.
0
Mosher1
Asked:
Mosher1
  • 9
  • 6
  • 3
  • +2
1 Solution
 
Rob SiklosCommented:
Can you create a PHP page with <?phpinfo; ?>, and attach the result?
0
 
Rob SiklosCommented:
sorry, that should have been:

<?phpinfo();?>
0
 
JurgenvHCommented:
Is your MySQL-extension set in php.ini?
Open your php.ini (phpinfo() will tell you where to find if you don't know) and search for extension=mysql.so or extension=php_mysql.dll
There should not be a ; at the beginning of this line.
Next make sure the extension is available in your extensiondir (setting found in php.ini; something like extension_dir = "C:/php/ext/")
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
Mosher1Author Commented:
Hi

Is this the file that you are after.

Mosher1
PHP-listing.doc
0
 
goliathdrakkenCommented:
based on your phpinfo posting your server is not configured to use mysql. you need to edit your php.ini file (C:\Server\PHP\php.ini )

un comment the following line:
;extension=php_mysql.dll

you may also need to add the php directory to you PATH environmental variable.
1.)right click my computer and select properties
2.)click the advanced tab
3.)click environmental variables
4.)locate Path in system variables and click edit
5.)add a semicolon (;) to the end of the string and add your php path to the end: C:\Server\PHP
6.)restart computer
0
 
fosiul01Commented:
HI yah, what goliathdrakken , you should do the samething

i am just adding a link, if you need any extra help to install php .

http://fosiul.co.uk/subcategory.aspx?Id=97

and also sometime, if you dont add  a new Variable PHPRC and Variable value C:\PHP\ . it does give some problem


HOpe your problem would be solved.
0
 
Mosher1Author Commented:
Hi Both

extension=php_mysql.dll was already uncommented.

I've added the 2 variables paths, but still same error message.
Annoying because 3 out of the 4 applications work in this setup(Apache/MySQL/PHP)
Just PHPmyadmin that doesn't.
Any further thoughts.
Thanks

Mosher1
0
 
Rob SiklosCommented:
Can you post your php.ini file (located at C:\Server\PHP\php.ini)?
0
 
Mosher1Author Commented:
Hi Rob

Heres the file copied to word - cant send ini files.

Mosher1
PHP-ini.doc
0
 
fosiul01Commented:
HI yah
is your phpmyadmin configuraton is ok ??
I know its reasy easy to configure ,
but still .. its better to check.

like this extionstion, is this enable or disable ??
$cfg['Servers'][$i]['extension'] = 'mysql';
0
 
Mosher1Author Commented:
Hi

Just wondering what Rob makes of the php.ini file.
The line extension=php_mysql.dll in itself appears to be correctly stated if this is indeed what the error message is referring to.

Mosher1
0
 
Rob SiklosCommented:
If you look at the output of phpinfo(), you'll see that the value of "extension_dir" is "C:\php5".  However, in your php.ini file, you appear to have it set to "c:\Server\php\ext".

So for some reason, it's not liking the value in php.ini.

Try changing it to c:/Server/php/ext (i.e. remove the quotes and change the backslashes to regular slashes).  Restart your computer and see if the phpinfo() output has the correct value.
0
 
JurgenvHCommented:
And if all else fails, copy your ext-dir to both places and see if that works. If so, delete one of them and you'll know which is the one you should keep.
There's nothing wrong with some trial and error sometimes... :-)
0
 
Mosher1Author Commented:
Hi Rob
I can see what you mean, I think. PHP's path to the extensions for some reason is C:\php5(as is the reference to the PEAR folder)
 This whole installation came from:
www.wikihow.com/Install-Apache,-MySQL,-PHP,-and-phpMyAdmin-on-a-Windows-PC
but I can't see how this extension path has been created in the PHP engine section.
Changing the php.ini file as you suggested makes no difference to the error message.

I looked at Jurgens's suggestion which I think suggests copying the contents of the ext folder to C:\php5 and presumably changing the extension dir in php.ini accordingly. Still no change. Perhaps Jurgen could confirm if that is what he meant.

Much appreciated.

Mosher1
0
 
Rob SiklosCommented:
After you make any changes to php.ini, you should restart your computer to make sure they take effect.  Have you done this?
0
 
Mosher1Author Commented:
Hi Rob

Yes restarted each time.
Just to reflect, Apache, MySQL and PHP are all located on C:\Server as the installation notes suggested.
The only thing that occurs to me is that the latest version of PHP may contain some changes since the notes were written. If so would this just be a case of locating the relevant files where the PHP engine expects to find them, and is that C:\php5?

Mosher1
0
 
JurgenvHCommented:
Actually, that was my idea.
But I was walking through all the posts so far and the question that popped into my head was: have you alteady tried placing your php.in in the C:\Windows\ directory? I know phpinfo() says it loaded another file but sometimes windows and php can trick you allot. Afterwards restart and see what happens...
0
 
Mosher1Author Commented:
Hi Jurgen
Yes tried a copy of php.ini in C:/Windows/php presumably. No joy. Still puzzled by where the PHP listing gets extension dir as c:/php5, as Rob pointed out. Incidentally, the last few lines of the Apache config file read:
#BEGIN PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL
 #PHPIniDir "C:/Server/PHP/"
  #LoadModule php5_module "c:/Server/PHP/php5apache2_2.dll"
#END PHP INSTALLER EDITS - REMOVE ONLY ON UNINSTALL

ScriptAlias /php "c:/server/php/"
AddType application/x-httpd-php .php
Action application/x-httpd-php "/php/php-cgi.exe"

There seems to be more reference to php5 in the commented lines than the others. However if you swap the Script and Action lines for PHPiini dir and load module leaving addtype (as can be found in other install instructions on the web) Apache returns errors.
Don't know whether these lines are significant as Apache "runs all services" as they stand.

Thanks for the continued interest.

Mosher1

0
 
Rob SiklosCommented:
Any reason why you're running PHP as a CGI instead of an Apache module?
0
 
Mosher1Author Commented:
Hi Rob

Just followed the 4 steps in the link given earlier. I don't understand the difference between these two I'm afraid. Only logic tells me that there is some form of conflict in what I see, as you have pointed out.
Why might you select one method over another?
 My final step is to load my sports club database and make occasional adjustments before placing back on web - once I've acquired the knowledge.

Thanks

Mosher1
0
 
Mosher1Author Commented:
There does not appear to be a quick fix by installing in this way. So I tried WAMP5 at this link:

http://www.tinkertech.net/tutor/wamp/index.html

First time I have ventured down this road, but phpmyadmin worked first time.

Conclusion: don't try and and install the component parts separately go straight to the above.

The current problem ends here.

Thanks

Mosher1
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

  • 9
  • 6
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now