Accessibility Resource Center Skip to main content
Get gifts fast with In-Store & Curbside Pickup or same-day delivery.

How to Configure FIOS Router for Local MySQL Server

SOLVED
Reply
Contributor
Contributor
Posts: 2
Registered: ‎07-23-2011

How to Configure FIOS Router for Local MySQL Server

Message 1 of 5
(2,233 Views)

I just switched to FIOS and my router was replaced with the FIOS router.  I have not been able to  set up the new router to enable traffic on port 3306 between my local machines to support MySQL.    Of course, FIOS customer support considers this issue outside of their domain.

 

I have modified my connections to agree with the new ip addresses the FIOS router assigns and enabled 3306 to pass traffic in every way I could find to do this on the FIOS router. 

 

Any suggestions will be greatly appreciated.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Contributor
Contributor
Posts: 2
Registered: ‎07-23-2011

Re: How to Configure FIOS Router for Local MySQL Server

Message 4 of 5
(2,176 Views)

You and Smith were both correct.  There is nothing required at the router.   The actual proble was in fact related to the different IP addresses that were assigned by the router.  I simply forgot all the places that are dependent upon the IP address in my MySQL configuration:

 

1. The server had to be changed to bind the the new IP addres in /etc/mysql.conf

2. Several MySQL based programs had to be modified to connect to the new server address.

3. GRANT had to be invoked by MySQL root for each user on the new host IP addresses.

 

 Since you suggested that IP addresses  needed to be looked at, I am crediting your post with the solution.   Thanks.

View solution in original post

4 REPLIES 4
Highlighted
Platinum Contributor III Platinum Contributor III
Platinum Contributor III
Posts: 7,547
Registered: ‎12-15-2010

Re: How to Configure FIOS Router for Local MySQL Server

Message 2 of 5
(2,224 Views)

No additional configuring should be needed on the FiOS routers to run a server on your network and to have other PCs on your network reach the server. The only thing you needed to configure anything for would be if you were to run a MySQL server that is being reached from another computer out on the Internet; that would be Port Forwarding.

 

I assume you've done the basic ping checks to the computer hosting your MySQL database, correct? If it can be pinged, it should be reachable.

Highlighted
Gold Contributor III
Gold Contributor III
Posts: 1,122
Registered: ‎12-04-2009

Re: How to Configure FIOS Router for Local MySQL Server

Message 3 of 5
(2,216 Views)

As smith6612 stated, there is nothing that needs to be configured on the router to allow your local machines to reach your MySQL server.  Make sure all the machines have been rebooted and have 192.168.1.x addresses.

 

Highlighted
Contributor
Contributor
Posts: 2
Registered: ‎07-23-2011

Re: How to Configure FIOS Router for Local MySQL Server

Message 4 of 5
(2,177 Views)

You and Smith were both correct.  There is nothing required at the router.   The actual proble was in fact related to the different IP addresses that were assigned by the router.  I simply forgot all the places that are dependent upon the IP address in my MySQL configuration:

 

1. The server had to be changed to bind the the new IP addres in /etc/mysql.conf

2. Several MySQL based programs had to be modified to connect to the new server address.

3. GRANT had to be invoked by MySQL root for each user on the new host IP addresses.

 

 Since you suggested that IP addresses  needed to be looked at, I am crediting your post with the solution.   Thanks.

View solution in original post

Highlighted
Moderator Moderator
Moderator
Posts: 10,307
Registered: ‎03-18-2013

Re: How to Configure FIOS Router for Local MySQL Server

Message 5 of 5
(366 Views)

As this thread is now over eight years old, it will be locked in order to keep discussions current. If you have the same or a similar question/issue we invite you to start a new thread on the topic.

How-To Videos
 
The following videos were produced by users like you!
   
Videos are subject to the Verizon Fios Community Terms of Service and User Guidelines and contains content that is not created by Verizon.
Covid19


Browse Categories
Categories:
Posts

Verizon Troubleshooters
Unable to find your answer here? Try searching Verizon Troubleshooters for more options.