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.

 

Advertisements

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/