I've installed PHP, Mysql, and IIS 7, including CGI, and i've put phpmyadmin into a directory, made the folder "config" configured the config-inc.php or what ever its called, and get this error.
phpMyAdmin - Error
Cannot load mysql extension. Please check your PHP configuration. -
Documentation
I've also made it a web application, like most online tutorials show.
There are several guides online, but none added the simplicity of setting it up. The quickest way to install phpmyadmin is as followed:
1) Download the latest phpmyadmin (of course!)
2) Under the IIS management console, create a new website and call this phpmyadmin. Assign a host name to it (you may need to set up DNS if you assign host name). Alternatively leave this blank but this will be your default website if you typed in just the
IP address of this webserver.
3) Copy the content of the zip file into this new phpmyadmin website directory.
4) Voila! your done!
I've seen a number of users, who have had website access errors because they have created the directory manually 1st. Created it with IIS will set up the permission and access path correctly and quickly.
You can now browse through either with the hostname (that you set up) or if left default, then just type in the IP address and you will be prompted with phpmysql interface.
To get different site on different port, thats not hard either.
1) Under IIS6 management console and properties of the actual website directory. Go to the tab called Web Site. Here you can assign the port as well as the hostname.
2) If you are using IIS7, then right click on the website under Sites, Site Binding.
And like in the pervious post, you will need to uncomment extension=php_mysql.dll. And even possibly reboot.
I've used Apache before, but i'm probably one in the million perfer IIS7!
thank you coldhand, very simple now for the password i tried root and leave it blank but it did not work anyone has an idea where can i find the password? regards, jcslzr
<div id="BZipDump" class="error">Bzip2 compression and decompression requires functions (bzopen, bzcompress) which are unavailable on this system.</div><div id="config_rw" class="error">
Cannot load or save configuration
Please create web server writable folder config in phpMyAdmin top level directory as described in
documentation. Otherwise you will be only able to download or display it.</div><div id="ForceSSL" class="notice">
Force SSL connection
This option should be enabled if your web server supports it.</div><div id="no_https" class="notice">
Insecure connection
You are not using a secure connection; all data (including potentially sensitive information, like passwords) is transferred unencrypted! If your server is also configured to accept HTTPS requests follow
this link to use a secure </div>
baileyraetse...
5 Posts
phpMyAdmin setup?
Aug 25, 2009 05:57 AM|LINK
I've installed PHP, Mysql, and IIS 7, including CGI, and i've put phpmyadmin into a directory, made the folder "config" configured the config-inc.php or what ever its called, and get this error.
phpMyAdmin - Error
Cannot load mysql extension. Please check your PHP configuration. - Documentation
I've also made it a web application, like most online tutorials show.
I need help. Anyone?
ruslany
900 Posts
Microsoft
Moderator
Re: phpMyAdmin setup?
Aug 25, 2009 08:07 PM|LINK
Check if you have correctly enabled the mysql extension. Open php.ini and find these directives:
extension_dir - this should be set to the path where all php extensions are located, e.g. "C:\Program Files\PHP\ext"
extension=php_mysql.dll - this should be uncommented.
After you've modified the php.ini file restart the IIS application pool so that PHP picks up the config changes.
baileyraetse...
5 Posts
Re: phpMyAdmin setup?
Aug 25, 2009 08:43 PM|LINK
I've decided to stick with xampp. IIS is great, I liked it because you could put different sites for different ports...
But I never could get phpmyadmin running, and I did exactly what you said..
Thanks for the help though! :)
coldhand
4 Posts
Re: phpMyAdmin setup?
Aug 28, 2009 08:11 AM|LINK
There are several guides online, but none added the simplicity of setting it up. The quickest way to install phpmyadmin is as followed:
1) Download the latest phpmyadmin (of course!)
2) Under the IIS management console, create a new website and call this phpmyadmin. Assign a host name to it (you may need to set up DNS if you assign host name). Alternatively leave this blank but this will be your default website if you typed in just the IP address of this webserver.
3) Copy the content of the zip file into this new phpmyadmin website directory.
4) Voila! your done!
I've seen a number of users, who have had website access errors because they have created the directory manually 1st. Created it with IIS will set up the permission and access path correctly and quickly.
You can now browse through either with the hostname (that you set up) or if left default, then just type in the IP address and you will be prompted with phpmysql interface.
To get different site on different port, thats not hard either.
1) Under IIS6 management console and properties of the actual website directory. Go to the tab called Web Site. Here you can assign the port as well as the hostname.
2) If you are using IIS7, then right click on the website under Sites, Site Binding.
And like in the pervious post, you will need to uncomment extension=php_mysql.dll. And even possibly reboot.
I've used Apache before, but i'm probably one in the million perfer IIS7!
Hope that helps!
baileyraetse...
5 Posts
Re: phpMyAdmin setup?
Aug 31, 2009 03:59 AM|LINK
coldhand
4 Posts
Re: phpMyAdmin setup?
Sep 01, 2009 06:53 PM|LINK
Try this link.
http://forums.iis.net/t/1152473.aspx
jcslzr
1 Post
Re: phpMyAdmin setup?
Sep 13, 2011 01:53 PM|LINK
HCamper
8048 Posts
Re: phpMyAdmin setup?
Sep 13, 2011 02:12 PM|LINK
Suggestions:
Install PHP manager http://learn.iis.net/page.aspx/944/using-php-manager-for-iis-to-setup-and-configure-php/
Then install MySQL Server to start fresh to set a password of the right length and one that you can use.
Martin
Community Member Award 2011
slowpoke54
3 Posts
Re: phpMyAdmin setup?
Jan 25, 2012 12:59 AM|LINK
I tried it got these errors
<div id="BZipDump" class="error">Bzip2 compression and decompression requires functions (bzopen, bzcompress) which are unavailable on this system.</div><div id="config_rw" class="error">Cannot load or save configuration
Please create web server writable folder config in phpMyAdmin top level directory as described in documentation. Otherwise you will be only able to download or display it.</div><div id="ForceSSL" class="notice">Force SSL connection
This option should be enabled if your web server supports it.</div><div id="no_https" class="notice">Insecure connection
You are not using a secure connection; all data (including potentially sensitive information, like passwords) is transferred unencrypted! If your server is also configured to accept HTTPS requests follow this link to use a secure </div>Can you help?
slowpoke54
3 Posts
Re: phpMyAdmin setup?
Jan 25, 2012 02:26 AM|LINK
I can get in on phpmyadmin but can't create a database now,
but still getting bz error. ,when phpmyadmin created config it doesn't have any thing about database??