Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

MySQL Install on Windows won't accept remote host connections

Everything works great from the localhost, but remote connections get an error like "MySQL Connection is not allowed from host, YOURHOST"

Obviously I'm missing a config of some sort, this is a fresh install of 5.0.45 on Windows Server 2003 32-bit.

Thanks for any help with what I need to do/add/configure/etc
0
dban00b
Asked:
dban00b
1 Solution
 
Aleksandar BradarićSoftware DeveloperCommented:
You have to use the GRANT command to allow access from other servers, like:
---
GRANT ALL ON yourDatabase.yourTable TO yourUser@yourHost IDENTIFIED BY 'yourPassword';
FLUSH PRIVILEGES;
---

See more here: http://dev.mysql.com/doc/refman/5.0/en/grant.html
0
 
DiscoNovaCommented:
My suggest stems from Linux, but I believe Windows might have something similar going on. Latest version of MySQL at least will by default bind itself to "localhost" (loopback interface) instead of "0.0.0.0" (all available interfaces) as a security measure. This setting can be changed from within my.cnf (my.ini, whatever:) with setting "bind-address" (which is under section "mysqld").
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now