[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Freebsd adjust firewall

Posted on 2010-08-24
2
Medium Priority
?
577 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
jodix2002 earned 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hello fellow BSD lovers, I've created a patch process for patching openjdk6 for BSD (FreeBSD specifically), although I tried to keep all BSD versions in mind when creating my patch. Welcome to OpenJDK6 on BSD First let me start with a little …
In tuning file systems on the Solaris Operating System, changing some parameters of a file system usually destroys the data on it. For instance, changing the cache segment block size in the volume of a T3 requires that you delete the existing volu…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
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.
Suggested Courses

656 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