Intallation for the Ubuntu



setting up MariaDB repositories


choose a version

run the commands to install for Ubuntu, DB 10.1

sudo apt-get install software-properties-common sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xF1656F24C74CD1D8

sudo add-apt-repository ‘deb [arch=amd64,i386,ppc64el] http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu xenial main’

sudo apt update

sudo apt install mariadb-server

ref) https://downloads.mariadb.org/mariadb/repositories/#mirror=kaist&distro=Ubuntu&distro_release=xenial–ubuntu_xenial&version=10.1


configuring MariaDB for Remote

# mysql -u root -p

# maria> create database just;

# maria> create user ‘test’@’%’ identified by ‘mypassword’;

# maria> create user ‘test’@’localhost’ identified by ‘mypassword’;

# maria> grant all privileges on just.* to test@’%’;

# maria> flush privileges;


# sudo vi /etc/mysql/my.cnf

bind_address=  (basic)



or bind_address=

or bind_address=      (db server public ip)

# sudo service mysql restart






Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s