Installing MySQL:

apt-get install mysql-server

The above command installs mysql server and its related components. you will be asked to setup a password for the root account. 

Post Installation Measures:

Exposing MYSQL to External Applications:

Edit /etc/mysql/my.cnf and comment the line

bind-address =  127.0.0.1

you can change port to some no standard ports by changing 

port  =  3306 ----> any port you like

Restart Mysql server with

service mysql restart

This will expose your database, but there are no users that can connect to it. create a database and assign a user to it.

create database test;
grant all privileges on test.l* to test-user@"%" identified by "<some-secret-password>";

This way test-user can connect to database test from any PC.

Few Security tips:

  1. If only applications are meant to be connected setup firewall rules to specific IP Addresses to connect to that port.
  2. you can change location and encrypt mysql data.
  3. change admin username from root.

Subscribe To our news letter

Subscribe to our news letter to receive latest blog posts into your inbox. Please fill your email address in the below form.
*We don't provide your email contact details to any third parties
Latest Comments
Related Articles
Web Hooks for Gitlab using PHP and Shell Scripts Jagadeesh V

Web-hooks play vital role if you are in Continuous Integration(CI). Higher Level organizations follow GitLab for CI purposes if they operate on open source solutions ...

Continue Reading...
Setting Up Sentry - Web Application Event Tracking platform Jagadeesh V

When you want to track your exception and log mesages in a UI rather than storing it in a file(which we usually do), we can ...

Continue Reading...
How to backup and restore your database(mysql, postgresql, mongodb) Nikhila Mergu

Data loss can happen when we accidentally delete the files, or when server crashes or system fails, or when we applied migrations to the data ...

Continue Reading...