troubleshooting Question

WAMP - Allow remote access to MySQL

Avatar of MDWinter
MDWinter asked on
DatabasesMySQL Server
2 Comments1 Solution5255 ViewsLast Modified:
Hi,

I have MySQL set up on a windows server. I wish to migrate to a new server running WAMP.

I installed WAMP just fine, and now I want to conect to MySQL with the MySQL Admininistrator tool so I can restore my backups.

When I open the MySQL adminitrator and enter the IP address of my new WAMP server,I get an error Number 1130 (Host 'xxxx' is not allowed to connect to this MySQL server'

How do I configure MySQL in WAMP such that I am allowed to use the MySQL tool to conect as root in order to perform administrative tasks?

Note - security is not the primary concern here - ease of use is. This is only being used internally. I'm quite happy to open it up to ALL remote hosts so that I can use the tool on other machines...

Thanks.
ASKER CERTIFIED SOLUTION
jaxstorm

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros