note 73994 added to install.windows.manual

IIS Windows 2003 server. You have upgraded to PHP5 from PHP4. phpinfo- works fine. You cannot however communicate with mysql (for example) through phpMyAdmin as it throws up an error stating it cannot load the mysqli extension and/or you get the 'bad handshake' warning. Solution: update your libmySQL.dll file in your system32 folder. This requires you to stop all internet services on your computer i.e IIS. Full details below. ############################# Background: my server is set up as follows: php files folder == C:\PHP I have configured my php.ini file opening up the required extensions etc I have mapped the necessary extension to IIS I have configured my website extension(s) I have mapped my windows path ';C\PHP;C\PHP\ext' I have registered my ini file I have tested my phpinfo() and it works I have installed phpMyAdmin and it refuses to work I have tried simple mysql connection scripts ...nada I have checked everything 50 times I am bald. Then I did this: ############################## 1) Copy 'libmySQL.dll' from C:\PHP (or the folder where you have loaded php into) 2) Open 'Windows\system32' folder. Do nothing at the moment, just have this window 'to hand'. 3)Open IIS manager snap in(control panel - administrative tools - IIS manager) Right click server name as shown below: - Internet Information Services - My Computer (local computer) - right click Select 'all tasks' then 'Restart IIS...' Use drop down then select 'stop internet services on XXXXX' and click 'OK' 4) Return to your 'Windows\system32' folder. Paste 'libmySQL.dll' (it is already in your clipboard from step 1). It will warn you about overwrite the current one. Select YES. 5) Return to IIS manager. Follow steps as in '3' above except now choose 'Restart Internet Services on XXX' (the default option), click OK. ############################# I hope this works for you. ---- Server IP: 87.124.64.96 Probable Submitter: 217.41.29.190 ---- Manual Page -- http://www.php.net/manual/en/install.windows.manual.php Edit -- https://master.php.net/note/edit/73994 Del: integrated -- https://master.php.net/note/delete/73994/integrated Del: useless -- https://master.php.net/note/delete/73994/useless Del: bad code -- https://master.php.net/note/delete/73994/bad+code Del: spam -- https://master.php.net/note/delete/73994/spam Del: non-english -- https://master.php.net/note/delete/73994/non-english Del: in docs -- https://master.php.net/note/delete/73994/in+docs Del: other reasons-- https://master.php.net/note/delete/73994 Reject -- https://master.php.net/note/reject/73994 Search -- https://master.php.net/manage/user-notes.php