SQL Remote Access

So, if you need to allow another host to connect to a mysql DB here’s how you can accomplish this:

GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’  identified by ‘password’;

the % allows all host with the user root.



NTP on Windows Domain Controller

  1. First, locate your PDC Server. Open the command prompt and type: C:\>netdom /query fsmo
  2. Log in to your PDC Server and open the command prompt.
  3. Stop the W32Time service: C:\>net stop w32time
  4. Configure the external time sources, type: C:\> w32tm /config /syncfromflags:manual /manualpeerlist:”time-c.nist.gov
  5. Make your PDC a reliable time source for the clients. Type: C:\>w32tm /config /reliable:yes
  6. Start the w32time service: C:\>net start w32time
  7. The windows time service should begin synchronizing the time. You can check the external NTP servers in the time configuration by typing:C:\>w32tm /query /configuration
  8. Check the Event Viewer for any errors.

Sourced from: http://defaultreasoning.com/2009/11/16/synchronize-time-with-external-ntp-server-on-windows-server-2008-r2/