Solved

Freebsd adjust firewall

Posted on 2010-08-24
2
565 Views
Last Modified: 2013-12-06
Say in advance im noob in unix

I have a server #1 running on freebsd
and another server #2 running on redhat linux

i need server #2 to have access to mysql databse on server #1

How can i set this up?
0
Comment
Question by:CMDAI
2 Comments
 
LVL 3

Accepted Solution

by:
jodix2002 earned 500 total points
ID: 33519063
In the users table in mysql db, you will see the "host" field, not just username and password. It means that mysql user A may be able to connect locally, but user A may fail to connect from other machine. You need to do

GRANT ALL PRIVILEGES ON *.* TO username@’%’ IDENTIFIED BY ’password’ WITH GRANT OPTION;

If you enable firewall (ipfw or whatever) on server 1, you should also open port 3306 (mysql default) or whatever port you use for mysql. Make it available to trusted hosts only.

You may want to read this article: http://dev.mysql.com/doc/refman/4.1/en/security-guidelines.html
0
 
LVL 1

Author Closing Comment

by:CMDAI
ID: 33529662
Thanks, just got it running
0

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I promised to write further about my project, and here I am.  First, I needed to setup the Primary Server.  You can read how in this article: Setup FreeBSD Server with full HDD encryption (http://www.experts-exchange.com/OS/Unix/BSD/FreeBSD/A_3660-S…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In a previous video, we went over how to export a DynamoDB table into Amazon S3.  In this video, we show how to load the export from S3 into a DynamoDB table.

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question