How to Remote MySQL on IIS?

WockoLad · Sep 21, 2015

Hey, How do you Remote MySQL on IIS?

Ecko · Sep 21, 2015

Go open port 3306 on firewall and then grant remote IP access in mysql:

GRANT ALL PRIVILEGES ON databasename.* TO 'user'@'ipadress'

bruhguy · Oct 28, 2015

Windows Server?

Open MySQL Command
It's should look like this

Code:

mysql>

Then copy this

Code:

GRANT ALL ON databasename.* TO username@'IP.IP.Here.Here' IDENTIFIED BY 'your_sql_user_password';

Run the query

Check your computer's public ip, your gonna need it

Brad · Oct 28, 2015

Or you could just open the mysql Database on navicat and run this

Code:

GRANT ALL ON databasename.* TO root@'IP' IDENTIFIED BY 'password';

Ecko · Oct 28, 2015

aka just repost my advice just slightly altered