How to create an alias for IP address for JDBC connection

aliasMySQLNetwork

I have the “db” alias in my JDBC connection specified in the Java properties file for MYSQL. This alias does not currently work on my local computer.

I would like not to change the properties file but instead of this create the alias “db” that will work the same as IP address for JDBC connection. Is it possible?

I am on OS X Mavericks

Best Answer

Add the alias to the file /etc/hosts with a line like this:

123.123.123.123 db

Where 123.123.123.123 should be substituted with your IP-address and db must match the name given as alias in the JDBC connection.

After editing the file, run the following command in the Terminal:

sudo killall -HUP mDNSResponder

This will reload the hosts file.

Related Solutions

Connect from OS X 10.8 to MySQL – How to Guide

Step one is to ensure your ports are open and there isn’t a network issue.

In the Finder, open /Applications/Utilities/Network Utility.app

Then choose "Port Scan". Enter the IP address (or the name if DNS is set up in your network) of the Linux Box and scan all ports less than 4000.

A success would look like your results:

Port Scanning host: 192.168.1.2

     Open TCP Port:     3306        mysql
Port Scan has completed…

That should be a quick check that the network and/or DNS are working. It's almost certainly not being blocked - you have to do a lot of non-default work to block arbitrary outbound ports.

If not, you’ll need a follow on question with enough details for someone to help.

If the network is working, you can be assured it’s not related to OS X and perhaps focus on a code level question on Stack Overflow.

How to Create a Bash Alias to Enter a String in Terminal

Here's how I would approach it. Use this related question to write the function that would reside in your bashrc or bash_profile. Then add a line in the function that would delete the most recent line in your bash history using this

Best Answer

Related Solutions

Connect from OS X 10.8 to MySQL – How to Guide

How to Create a Bash Alias to Enter a String in Terminal

Related Question