Make sure to change the DocumentRoot, ServerName and Directory location according to your needs. ServerAlias ErrorLog '/private/var/log/apache2/-error_log'ĬustomLog '/private/var/log/apache2/-access_log' common Pankajs-MacBook-Pro:~ root# vi /etc/apache2/extra/nfĪdd following configuration for a new VirtualHost and save it. We can proceed now to HTTPD virtual hosts file. Now when Apache will load the configuration file, it will also load the virtual hosts configuration file. Pankajs-MacBook-Pro:~ root# vi /etc/apache2/nf To enable VirtualHosts, we need to make some changes in Apache Configuration file (nf). Here for reference is an example connection using MySQL Adminstrator going to localhost: note the Server Host address of 127.0.0.1 which will be transparently forwarded.Default location for Apache web server project files is /Library/WebServer/Documents/ which is not a convenient place to keep our project files, also we will have to access it in browser with localhost, so I decided to create my own virtual host pointing to my development directory. Connect to MySQL on Amazon EC2 from Linux / Mac It needs to be running whenever you try to connect to MySQL database. This will run the ssh session in background. In this case, 127.0.0.1 refers to 192.150.15.1 and not your local machine. After reaching EC2 instance, it is sent to 127.0.0.1:3306. So when you try connecting to port 3100 on your laptop it will be sent to 192.150.15.1.

Otherwise, check with your AMI provider.

For an Ubuntu AMI, the user name is ubuntu.

For a RHEL AMI, the user name is often root but might be ec2-user.

For an Amazon Linux AMI, the user name is ec2-user.

$remote_port – port on which MySQL server runs on EC2. This is the port that listens to connection requests $local_port – port on your local machine that you are forwarding to MySQL server on EC2.

$key – location of your private key file (.pem) downloaded from Amazon while creating EC2 instance

Just open the shell/terminal and type a command with the syntax ssh -i '$key' -f -N -L $local_port:127.0.0.1:$remote_port it means: If you are not familiar with SSH tunnel, you can read about connecting to Amazon EC2 instance from Linux / Mac using SSH. Here’s how you can connect to MySQL on Amazon EC2 from Linux / Mac using SSH tunnel. Since it is over SSH, no one can track it either. No need to open the port of your MySQL server on EC2 instance. Now when you connect to your local port, it is forwarded to connect to MySQL server on Amazon EC2 over SSH instead. You can forward your local port over Secure Shell (SSH) instead. But you may not want to open any port on EC2 instance for security reasons. You may want to connect to MySQL on Amazon EC2 from Linux / Mac laptop.

How to link mysql on mac