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
personal knowledge base repo
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.
Sourced from: http://defaultreasoning.com/2009/11/16/synchronize-time-with-external-ntp-server-on-windows-server-2008-r2/