467,076 Members | 933 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,076 developers. It's quick & easy.

MySql does not show in Php info

Hello everyone,

I successfully installed Php in IIS 5, but ran into a big problem in running MySql. I successfully installed MySql in my system but it does not show when I try to run phpinfo() although I have MySql running properly.

I have uncommented the following lines in php.ini.

---
extension=php_mysql.dll
extension=php_mysqli.dll
---

Can anyone help me on this? How do I bind/attach MySql to Php or vice versa? Here are some of the info regarding my Php and MySql installation... I don't know if this helps.

---
Php install folder - C:\php (php)
Php ini location - C:\windows\php.ini
MySql installation path - C:\Program Files\MySQL\MySQL Server 5.0
---
Feb 22 '07 #1
  • viewed: 11390
Share:
5 Replies
ronverdonk
Expert 4TB
Have you uncommnted the extension_dir in php.ini (step 3)? Like in the following:

Expand|Select|Wrap|Line Numbers
  1. Fine tuning Step 3
  2. Open php.ini for editing and try to find the line:
  3. extension_dir
  4. Change the line from
  5. ;extension_dir = "./"
  6. to
  7. extension_dir = "D:\Program Files\php\ext"
  8. Take care that the first semicolon(;) was removed.
  9. ------------------------------------------------------------------
  10. Fine tuning Step 4.
  11. Next step is allow the MySQL extension. Try to find the line:
  12. ;extension=php_mysql.dll
  13. Remove the semicolon from the first place.
  14. Save the file.
  15. ------------------------------------------------------------------
  16. Fine tuning Step 5.
  17. To make sure that Apache will find the correct MySQL dll copy the 
  18. libmysql.dll from the php directory into the Apache/bin directory.
  19. ------------------------------------------------------------------
  20. Fine tuning Step 6.
  21. Restart Apache and check the PHP Info page again. Now you have 
  22. to find a MySQL section.
  23.  
  24.  
Ronald :cool:
Feb 23 '07 #2
Hi Ronald,

I already those things you mentioned above but without the quotations.

c:\php\ext instead of "c:\php\ext"

Would that make any difference?
Feb 23 '07 #3
ronverdonk
Expert 4TB
Yes it would to the ini interpreter, since it contains 'funny' characters like slashes.

Ronald :cool:
Feb 23 '07 #4
Hi Ronald,

I changed the php.ini so that c:\php\ext will be enclosed in quotations but it still not made any difference. Please someone help me... asides from php.ini is there anything that I could have missed during the installation of php or mysql? Thanks very much in advance.. :)
Feb 24 '07 #5
I copied libmysql.dll from php directory and overwrite the libmysql.dll in windows/system32 then I restarted IIS. Run phpinfo in the browser and there it is! :) Thanks for your time guys, Ronald. I hope this will help some newbies like me find the solution for the same problem.
Feb 24 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Eric W. Holzapfel | last post: by
reply views Thread by Lenz Grimmer | last post: by
reply views Thread by Mike Chirico | last post: by
8 posts views Thread by eholz1 | last post: by
Atli
6 posts views Thread by Atli | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.