If when you start your pc you get the failure message:
"Failed to Connect to a Windows Service -  Windows could not connect to the System Event Notification Service.... etc
then the problem can usually be resolved by setting the "Windows Modules Installer" to manual.

If you are new to this or not particularly technically minded then the
following will explain how to do this. 

Click Start > Run.
Now type services.msc and click OK.
Scroll down the window until you find Windows Modules Installer.
Double click it. This will bring up it's Properties box.
Click the Startup type drop down list. Here you will see a number of options in the menu.
Select Manual. (you may have to select Disable instead)
Click Apply.
Click OK to close its Properties box. 
Close the Services window.
Restart your computer.

IMPORTANT: if you had to Disable, you will need to change it back to Enable to download any Windows Updates. 

Afterwards, you might find that your firewall notifies you by display a popup with a message along the lines of "the Windows Modules Installer is trying to modify an existing driver...." and asks you to select 'Allow' or 'Deny'. It is quite possible that if you select 'Allow' that the Windows Modules Installer will reset to Automatic again.. so just select 'Deny'.

NOTE: if you look in the Windows Task Manager (Ctrl+Alt+Del) and select the 'Services' tab, you will note a service called TrustedInstaller. This is the culprit. When you open Windows Modules Installer in the Services window as explained above, you will see that is what it's called. So just set it to manual.

Clark

Posted by pump777 at 9:11 PM EST

Updated: Wednesday, 12 March 2008 5:17 PM EDT

Share This Post

Post Comment | Permalink

There are many long winded tutorials on the Net explaining how to do this but there is a very simple way...

My First Point However: It can be quite a security risk to connect to a remote database. Why not just install phpMyAdmin on the server in a folder and give it another name instead of phpMyAdmin so curious eyes don't automatically stumble across it. I personally never suffer any perfomance reduction issues when running phpMyAdmin remotely. 

Secondly, If you say you have "changed the info in the config file, and works fine for mysql databases in the localhost" then it is pointing to your localhost because it is reading databases on your pc. You must tell it (change it) to point to a remote host. The following example is used to point to a remote host.

cfg['Servers'][$i]['only_db'] = 'NAME OF DATABASE';

That line will only show the database developed for the business and will stop non technical staff (who require access) from creating new databases - thus ensuring they don't mess things up. Any technical staff who need to will know how to change it if necessary.

<?php
$i = 0;
$i++;
$cfg['Servers'][$i]['host'] = 'PUT YOUR MYSQL SERVER IP HERE - NOT YOUR WESITES URL';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';
$cfg['blowfish_secret'] = 'belly';   /* YOU MUST FILL IN THIS FOR COOKIE AUTH! - put any word you want. HERE I HAVE PUT IN belly AS AN EXAMPLE BUT YOU CAN CHOOSE ANYTHING - MAX 46 CHARS */

/* End of servers configuration */

$cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/refman';
$cfg['MySQLManualType'] = 'viewable';
?>

NOTE: You may need to define several other important parameters to get it working as your web host provider may have tightened up their security because of the associated vulnerabilities. Or you may need to contact them and explain why you want to as they may judge on a case by case basis. 

Clark

Posted by pump777 at 5:35 PM EST

Updated: Wednesday, 12 March 2008 5:18 PM EDT

Share This Post

Post Comment | Permalink