Admin-Ahead Community

Windows => General Windows => Topic started by: Chetan Singh on July 21, 2014, 12:02:05 pm

Title: Enable MySQL remote access!
Post by: Chetan Singh on July 21, 2014, 12:02:05 pm

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,