LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Networking
User Name
Password
Linux - Networking This forum is for any issue related to networks or networking.
Routing, network cards, OSI, etc. Anything is fair game.

Notices


Reply
  Search this Thread
Old 05-02-2015, 12:45 PM   #1
dmchess
Member
 
Registered: Jan 2005
Posts: 244

Rep: Reputation: 43
Router ? - Allowing MariaDB to be accessed by entire network


I have a Belkin N600 router and I would like to open MariaDB to the local network only.
I have Added under Port Forwarding:

On Desc Inbound Port Type PrivateIP Private Port
x MySQL 3306 3306 TCP 192.168.n.n 3306 3306

Will this work?


I have changed my PrivateIP from Integers to value n for
security, it is my local IP Address on my desktop.
 
Old 05-02-2015, 03:11 PM   #2
michaelk
Moderator
 
Registered: Aug 2002
Posts: 25,916

Rep: Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988Reputation: 5988
Nope. Setting a port forwarding rule in the router opens that port up to the world for outside connections. No router settings are required for just your local network. To allow network connections open port 3306 on the firewall if running on the server as well as configuring MariaDB to listen to an address besides local host. In your my.cnf file change bind-address=127.0.0.1 to bind-address=0.0.0.0. Restart MariaDB

In addition you need to grant remote access to your user from the remote IP address. I'm not much of a mysql user but something like.

GRANT ALL ON database.* to user@'IP_address' IDENTIFIED BY 'your-root-password'; ( is a wildcard for all)

Last edited by michaelk; 05-02-2015 at 03:13 PM.
 
Old 05-02-2015, 05:10 PM   #3
dmchess
Member
 
Registered: Jan 2005
Posts: 244

Original Poster
Rep: Reputation: 43
You are correct, I thought I could ping that port to test it. Apparently that doesn't work,
but i can log in.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
postfix,courier-imap & mariadb - not allowing login psycroptic Linux - Networking 2 06-17-2013 03:57 PM
[SOLVED] gnome network manager not allowing entire password vince60 Linux - Wireless Networking 2 05-30-2012 11:19 AM
Allowing asymmetric traffic through 'router' geustace Linux - Networking 3 12-22-2009 02:23 PM
Linux router not allowing traffic through theinfidel Linux - Networking 9 12-26-2008 02:44 PM
FDisk not allowing entire cylinders for partition laggerific Linux - Software 2 04-29-2007 06:34 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Networking

All times are GMT -5. The time now is 03:46 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration