MySQL Setup and Security

Reading Time : ~ .

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 the 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 MySQL
  3. change admin username from root.
    By Posted On
SENIOR DEVELOPER at MICROPYRAMID

Need any Help in your Project?Let's Talk

Latest Comments
Related Articles
How to Do Page Redirections with Nginx. Ashwin Kumar

Here we learn how to redirect a www to non-www or vice-versa also we see how to redirect pages. We will see differences between 301 ...

Continue Reading...
Automate Django Deployments with fabfile Shirisha Gaddi

Fabric is a Python library and command-line tool with the ability to execute commands on a remote server. It is designed to use SSH to ...

Continue Reading...
php7 hosting on Ubuntu Server with Nginx(LEMP stack) Ashwin Kumar

PHP7 is the latest version with lot of performance improvements and every one want to update their servers and code to it. Lets see how ...

Continue Reading...

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