Allow remote access to Mysql on Wamp

Permitir acceso remoto para mysql en wamServer


To allow remote access to apache on Windows change the file: c:\wamp\bin\apache\Apache2.2.17\conf\httpd.conf
You need to allow remote access to directory C:\wamp\www like this:
<Directory "c:/wamp/www/">
    ExecCGI MultiViews
    Options Indexes FollowSymLinks
    AllowOverride all
    Order allow,deny
    Allow from all
</Directory>

To grant remote access to MySQL:
use mysql;
GRANT ALL PRIVILEGES ON *.* to root@'%' IDENTIFIED BY 'sys';
flush privileges;

To see what is already allowed do this:
use mysql;
select user,host from user;
+------+-----------+
| user | host      |
+------+-----------+
| root |           |
| root | %         |
|        | localhost |
| root | localhost |
+------+-----------+
4 rows in set (0.00 sec)
“empty” places are nulls here. ‘%’ means from any host.