29 Jul 2011

Allow remote access to MySQL

I’m recently working on a project where I wanted to start playing with MySQL workbench to create an ER diagram for an existing database. I’m running Workbench on a Windows 7 machine with MySQL running on Ubuntu. Run the following to give the remote machine access.

mysql> grant all privileges on *.* to root@'remote_machone' identified by 'root password';
Query OK, 0 rows affected (0.12 sec)

You may not want to use the root account, but this will give you remote access.

Leave a Reply