[LINUX] Install MariaDB on Sakura's VPS

A memorandum from the completion of Sakura's VPS application to the installation of MariaDB for the first time

Specify repository

Specify the MariaDB repository with the following command.

$ curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash

Install MariaDB

Follow the steps below to install.

Installation

$ sudo yum install MariaDB-server MariaDB-client

MariaDB service started

$ sudo systemctl start mariadb

Make the service start automatically when the server starts

$ sudo systemctl enable mariadb

MariaDB initial settings

$ mysql_secure_installation

Location of configuration files

MariaDB configuration files are located in the following directory.

/etc/my.conf.d

By the way

For security reasons, you should change the port number, change the user authority, and make additional settings depending on your requirements.

Recommended Posts

Install MariaDB on Sakura's VPS
Install mecab on Marvericks
Install Tensorflow on Mac
Install TensorFlow on Ubuntu
Install Faiss on CentOS 7
Install pyenv on mac
Install pip on Mavericks
Install Python on Pidora.
Install mongodb on termux
Install Scrapy on python3
Install docker on Fedora31
Install numba on CentOS 7.2
Install Ansible on Mac
Install Python on Mac
Install Python 3 on Mac
Install Plone (4.3.6) on MacOSX (10.10.3)
Install PySide2 on Ubuntu
Install Python3.4 on CentOS 6.6
Install gensim on Marvericks
Install JModelica on Ubuntu
Install Anaconda on Windows 10
Install numpy on Marvericks
Install python on windows
Install enebular-agent on Chromebook
Install pycuda on Windows10
Install mecab-python on CentOS
Install Python 2.7.3 on CentOS 5.4
Install aws-cli on MacPorts
Install pygraphviz on Windows 10
Install Docker on AWS
Install Python 3.3 on Ubuntu 12.04
Install Chainer 1.5.0 on Windows
Install Python 3.4 on Mac
Install Caffe on Mac
Install Theano on Ubuntu 12.04
Install pyenv on OSX
Install mecab on mac
Install awscli on centos7
Install angr on Ubuntu 18.04
Install Chainer on CentOS 6.7
Install mecab-python on Mac
Install pip / pip3 on Ubuntu
Install Python 3.6 on Docker
Install octave_kernel on Jupyter [additional]
Install Numpy on virtualenv on Windows
Install Minecraft on Arch Linux
Install cvxopt on 64bit Anaconda
Install Scrapy on Raspbian (Jessie)
Install Linux on your Chromebox
Install watchdog on Windows + Python 3.3
Install Win-Kex (kali-linux) on Windows 10.
Install pygame on python3.4 on mac
Install tomcat 9 on Cent OS 8
Install cvxpy on windows, Anaconda
Install ImageMagick-6.2.x series on CentOS7.7
Install Python 3.8 on CentOS 7 (SCL)
Install the JDK on Linux
Install numba on your Mac
Install pandas 0.14 on python3.4 [on Mac]
Install GoLand IDE on Ubuntu
Install OpenCV on Ubuntu + python