Solve : MySQL & XP Firewall Issue?

1.	Solve : MySQL & XP Firewall Issue?
Answer» So I have a mySQL database running on a computer that is running Windows XP Pro SP3. I also have another computer also running Windows XP Pro SP3 that is to connect to this other systems mySQL database as a client to the server. If I shut off the firewall on the system that is serving up MySQL, everything works perfect. If I enable the firewall on this system that is serving up MySQL database the communications are blocked, so I know that I need to add an exception for MySQL to communicate on this system acting as a MySQL database server. I tried adding the MySQL to list of exceptions as well as opening up port 3306 which is the default port for MySQL and still not working. Prior to this issue, I had an issue where MySQL was only offering communications with the local machine at 127.0.0.1 I fixed this by telling it to open up communications to all via this example of instructions from shell at mySQL prompt. Quote $ mysql -U root -p Enter password: mysql> use mysql mysql> GRANT ALL ON . to [email protected]'192.168.2.1' IDENTIFIED BY 'your-root-password'; mysql> FLUSH PRIVILEGES; Dont really want to keep the firewall disabled even though this system is not on the DMZ. Want to correct this to have the correct exceptions to have it configured properly. Anyone else run into this issue and can point out what I might be missing? BTW: The IP of this Windows XP Pro SP3 system acting as a MySQL database server is static at 192.168.2.1, and the other system is also set to static 192.168.2.2 with correct MATCHING subnet etc, same workgroup etc. *Messing around with Client/Server and MySQL vs just local TESTING on same machine. And thats when I hit these issues.Did you try Port 3307 ? ? Any clues in Event Viewer ?Will check this out when I get home from 12 hr shift. I connect to it with SQLyog Community edition through user/password/port 3306 locally which is way easier to look at the big picture of the database vs command shell mysql prompt inquirys etc. Never set up anything manually on port 3307, so I dont THINK anything is using that port, but worth checking into what ports are in use on system to see if any listed alert me to one that might need to be open etc. Will netstat system acting as MySQL server and see. Haven't looked in event viewer yet since nothing was crashing etc. But will take a look in there anyways.Kind of makes no sense, but uninstalled and reinstalled mySQL and that fixed it. Its using port 3306 with firewall exception.It's MS... It's not supposed to make any sense... Quote It's MS... It's not supposed to make any sense... LOL

Answer»

So I have a mySQL database running on a computer that is running Windows XP Pro SP3.
I also have another computer also running Windows XP Pro SP3 that is to connect to this other systems mySQL database as a client to the server.

If I shut off the firewall on the system that is serving up MySQL, everything works perfect. If I enable the firewall on this system that is serving up MySQL database the communications are blocked, so I know that I need to add an exception for MySQL to communicate on this system acting as a MySQL database server.

I tried adding the MySQL to list of exceptions as well as opening up port 3306 which is the default port for MySQL and still not working.

Prior to this issue, I had an issue where MySQL was only offering communications with the local machine at 127.0.0.1
I fixed this by telling it to open up communications to all via this example of instructions from shell at mySQL prompt.

Quote

$ mysql -U root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to [email protected]'192.168.2.1' IDENTIFIED BY 'your-root-password';
mysql> FLUSH PRIVILEGES;

Dont really want to keep the firewall disabled even though this system is not on the DMZ. Want to correct this to have the correct exceptions to have it configured properly.

Anyone else run into this issue and can point out what I might be missing? BTW: The IP of this Windows XP Pro SP3 system acting as a MySQL database server is static at 192.168.2.1, and the other system is also set to static 192.168.2.2 with correct MATCHING subnet etc, same workgroup etc.

*Messing around with Client/Server and MySQL vs just local TESTING on same machine. And thats when I hit these issues.Did you try Port 3307 ? ?
Any clues in Event Viewer ?Will check this out when I get home from 12 hr shift. I connect to it with SQLyog Community edition through user/password/port 3306 locally which is way easier to look at the big picture of the database vs command shell mysql prompt inquirys etc.

Never set up anything manually on port 3307, so I dont THINK anything is using that port, but worth checking into what ports are in use on system to see if any listed alert me to one that might need to be open etc. Will netstat system acting as MySQL server and see. Haven't looked in event viewer yet since nothing was crashing etc. But will take a look in there anyways.Kind of makes no sense, but uninstalled and reinstalled mySQL and that fixed it. Its using port 3306 with firewall exception.It's MS...
It's not supposed to make any sense... Quote

Solve : MySQL & XP Firewall Issue?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment