Hello,
Here the steps that you can follow to enable MySQL remote connection in the Windows 2008 R2 server.
First, need to go to the MySQL BIN directory, check this,
====================>>>
C:\Users\UserName> cd C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin
C:\Program Files (x86)\MySQL\MySQL Server 5.0\bin>mysql -uroot -p <Root Pswword>
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.27 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.25 sec)
====================>>>
Note: MySQL installation path could be different.
Done! You can verify MySQL remote connection via this command or by accessing MySQL from your remote machine.
#mysql --host=192.168.xxx.xxx --user=root --password=<Your Password>
=================>>>
Thank you,