Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!

Author Topic: Enable MySQL remote access!  (Read 2959 times)

0 Members and 1 Guest are viewing this topic.

Chetan Singh

  • Full Member
  • ***
  • Posts: 123
  • Karma: +2/-0
  • Bienvenido a las Tecnologías de la Admin-Ahead.
    • Admin-Ahead Server Technologies.
Enable MySQL remote access!
« 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,
Get your server issues fixed by our experts for a price starting at just 25 USD/Hour. Click here to register and open a ticket with us now!