Web Hosting Talk : Web Hosting Main Forums : Programming Discussion : MySQL and PHP!?!? On Windows

[GPearce]

I have installed the latest Apache on my Windows Server 2k3, just to play with, and PHP. Then mysql, which all went in fine.
Then i added phpmyadmin, @ http://64.22.126.226/phpmyadmin , and i get an error:

Cannot load mysql extension. Please check your PHP configuration. - Documentation

I clicked the link on Mysql, and got the following info:

MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. Also, PHP needs access to the MySQL client library. A file named libmysql.dll is included in the Windows PHP distribution and in order for PHP to talk to MySQL this file needs to be available to the Windows systems PATH. See the FAQ titled "How do I add my PHP directory to the PATH on Windows" for information on how to do this. Although copying libmysql.dll to the Windows system directory also works (because the system directory is by default in the system's PATH), it's not recommended.

I have added my PHP directory to PATH , and rebooted, but i still have the problem. How do i enable php_mysql.dll in the php.ini file? I searched for it in the file, and it came up as not there.
I installed PHP5.2.2 , and Apache 2.2, plus the latest community MYSQL, but they don't talk to each other



How would i finish the config to make it work? The server is only a playground, and i trust Apache more than IIS xD



Thanks

[kuldeeps]

A much simpler way to install Apache, PHP, MySQL, PHPMyadmin under
Windows is to use XAMPP for Windows which you can download from http://www.apachefriends.org/en/xampp-windows.html
It includes all the latest components and works perfectly.

[Jatinder]

In your PHP directory, you will have a file named php.ini-recommended. Copy this file and paste it to Apache/bin directory. Rename php.ini-recommended file to php.ini and restart Apache.

A much simpler way to install Apache, PHP, MySQL, PHPMyadmin under Windows is to use XAMPP for Windows which you can download from http://www.apachefriends.org/en/xampp-windows.html
It includes all the latest components and works perfectly.

If you learning PHP to make a career out of it, I wouldn't recommend Xampp or any other easy to install Apache/PHP combo.

[Shining Star]

Originally Posted by scorpioxuk

I have installed the latest Apache on my Windows Server 2k3, just to play with, and PHP. Then mysql, which all went in fine.
Then i added phpmyadmin, @ http://64.22.126.226/phpmyadmin , and i get an error:



I clicked the link on Mysql, and got the following info:




I have added my PHP directory to PATH , and rebooted, but i still have the problem. How do i enable php_mysql.dll in the php.ini file? I searched for it in the file, and it came up as not there.
I installed PHP5.2.2 , and Apache 2.2, plus the latest community MYSQL, but they don't talk to each other



How would i finish the config to make it work? The server is only a playground, and i trust Apache more than IIS xD



Thanks

You can enable php_mysql.dll, In php.ini windows extension block search

;extension=php_mysql.dll

change to

extension=php_mysql.dll

restart apache

[GPearce]

I'm confused! I can't find php.ini-reccommended , and i'm not sure what windows extension block is

Could someone explain in "dummies terms" ?
I'm going to use it as an adrotator, that's all

[Shining Star]

In php.ini search for

;extension=php_mysql.dll

and change it to

extension=php_mysql.dll

restart apache

[Jatinder]

I'm confused! I can't find php.ini-reccommended

Check in you PHP folder. This would be folder where you extracted the contents of the archive which you downloaded from php.net site.

[GPearce]

I installed using a MSI installer, it's just the simplest way.

;;;;;;;;;;;;;;;;;;;;;;
; Dynamic Extensions ;
;;;;;;;;;;;;;;;;;;;;;;
;
; If you wish to have an extension loaded automatically, use the following
; syntax:
;
; extension=modulename.extension
;
; For example, on Windows:
;
extension=msql.dll
;
; ... or under UNIX:
;
; extension=msql.so
;
; Note that it should be the name of the module only; no directory information
; needs to go here. Specify the location of the extension with the
; extension_dir directive above.


; Windows Extensions
; Note that ODBC support is built in, so no dll is needed for it.
; Note that many DLL files are located in the extensions/ (PHP 4) ext/ (PHP 5)
; extension folders as well as the separate PECL DLL download (PHP 5).
; Be sure to appropriately set the extension_dir directive.

This? I took the ; off of the windows one, and restarted Apache, nothing changed.

There isn't anything else like it there xS

EDIT - Ill try cahnging it to php_mysql.dll Another EDIT - that failed too

[jt2377]

Why use Apache on Windows? It's a mismatched. You probably better off with IIS6 and PHP on Windows than Apache/PHP on Windows.

[GPearce]

I don't get how to install and run IIS on Windows, if anyone can help then i'd do that
The tutorials are vague...

[dkitchen]

I would second the reccomendation to use IIS, the only reason I'd ever use Apache on Windows is to serve Java/JSP apps...

It's pretty simple to install, control panel, add / remove programs / windows components / IIS... there are plenty tutorials out there on management once you've got it installed.

Dan

[Shining Star]

Originally Posted by scorpioxuk

I installed using a MSI installer, it's just the simplest way.
This? I took the ; off of the windows one, and restarted Apache, nothing changed.

There isn't anything else like it there xS

EDIT - Ill try cahnging it to php_mysql.dll Another EDIT - that failed too

;Windows Extensions
;Note that ODBC support is built in, so no dll is needed for it.
;

;extension=php_bz2.dll
;extension=php_cpdf.dll
extension=php_curl.dll
;extension=php_dba.dll
;extension=php_dbase.dll
;extension=php_dbx.dll
;extension=php_exif.dll
;extension=php_fdf.dll
;extension=php_filepro.dll
extension=php_gd2.dll
;extension=php_gettext.dll
;extension=php_ifx.dll
;extension=php_iisfunc.dll
extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_java.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mhash.dll
;extension=php_mime_magic.dll
;extension=php_ming.dll
extension=php_mssql.dll
extension=php_msql.dll
extension=php_mysql.dll
;extension=php_oci8.dll
;extension=php_openssl.dll

[GPearce]

Right. on advice, i binned Apache, and now have IIS serving teh IP address from the site, i think.
I'm going to download and install PHP5 for it, what else do i then have to do, configuration wise?

[GPearce]

Ok, it should be installed and working, but now i have a problem.
I copy-pasted PHPMYADMIN in as a directory, all good, but to reach the dir http://64.22.126.226/phpmyadmin/ i have to enter user/password . I tried my root one, and it loaded, but then i get page not found on index.php and main.php , both of which ARE there.
What do i do now?
Im no good at this
I setup a site for the IP address, and it's ok and i think it's working

Edit - I don't put a password in anymore i dont think, but i can't load it still, its "Not Authorized To View This PAge"

Another Edit - i went back to using the default website on the IIS manager, which does the job for now, but it still says not found inside the folders. There is no longer a permission issue though, i guess

[jt2377]

Originally Posted by scorpioxuk

Ok, it should be installed and working, but now i have a problem.
I copy-pasted PHPMYADMIN in as a directory, all good, but to reach the dir http://64.22.126.226/phpmyadmin/ i have to enter user/password . I tried my root one, and it loaded, but then i get page not found on index.php and main.php , both of which ARE there.
What do i do now?
Im no good at this
I setup a site for the IP address, and it's ok and i think it's working

Edit - I don't put a password in anymore i dont think, but i can't load it still, its "Not Authorized To View This PAge"

what's the default user? it should be something like iusr_machine. you need to grant permission for that account.

Not to pimp my own site but check this tutorial on phpmyadmin that i have. it's old but it should apply to your problem.

http://www.endlesscomputer.com/tutor...phpmyadmin.htm

your phpmyadmin problem sounded like an permission issue.