[MariaDB] Install MariaDB on Linux and create a DB and an operating user.

This is a memo when MariaDB is installed to use EC2 of Linux2 as a DB server on AWS. (Overwhelmingly for myself)

First of all

sudo yum update -y

installation of mariaDB

sudo yum -y install mariadb-server

mariaDB start

sudo systemctl start mariadb

Set the password for the DB root account

mysqladmin -u root password

Log in to the DB with the password you set with the root account

mysql -u root -p

Create DB with {database name}

CREATE DATABASE {Database name} DEFAULT CHARACTER SET utf8 COLLATE uft8_general_ci;

The user who has given full operation authority to the created {database name} DB Created with {username} and {password}

grant all on {Database name}.* to {username}@"%" identified by '{password}';

From the next time onward, set mariaDB to start automatically when the server starts

sudo systemctl enable mariadb

Recommended Posts

[MariaDB] Install MariaDB on Linux and create a DB and an operating user.
Install LAMP on Amazon Linux 2 and build a WordPress environment.
Install Arch Linux on DeskMini A300
Create a Linux environment on Windows 10
I created an SFTP-only user on Linux.
Install wsl2 and master linux on windows
Install and launch k3s on Manjaro Linux
Install and Configure TigerVNC server on Linux
Create a Linux virtual machine on Windows
[Python] Create a linebot to write a name and age on an image
Build Linux on a Windows environment. Steps to install Laradock and migrate
Try to create a new command on linux
[Ubuntu] Install Android Studio and create a shortcut
A story about trying to install uwsgi on an EC2 instance and failing
Until you create an Ubuntu boot USB on your Macbook and install Ubuntu on your Thinkpad
Specify the volume on linux and make a sound
Create a QR code for the URL on Linux
How to install Linux on a 32bit UEFI PC
How to create a Python 3.6.0 environment by putting pyenv on Amazon Linux and Ubuntu
Create an environment for MkDocs on Amazon Linux (attempted)
Compile and install MySQL-python for python2.7 on amazon linux
Install Docker on Arch Linux and run it remotely
Install procs, an alternative tool for ps, on Linux (also available on Mac and Windows)
Create a decent shell and python environment on Windows
Create a shape on the trajectory of an object
[Linux] Create a self-signed certificate with Docker and apache
How to set up WSL2 on Windows 10 and create a study environment for Linux commands
On a Linux environment, create a NuGet package from a C # project and load it into another project
Create a partial correlation matrix and draw an independent graph
Create a VS Code + Docker development environment on a Linux VM
I installed FreeCAD on Linux (Ubuntu) and created an icon
Create a partition and then install the Raspberry Pi OS
Install Linux (CentOS) on your PC using a USB stick
How to create an ISO file (CD image) on Linux
Install Minecraft on Arch Linux
Install Linux on your Chromebox
Install the JDK on Linux
Recording and playback on Linux
Install MariaDB on Sakura's VPS
Install tomcat 5.5 on Amazon Linux.
Create a classroom on Jupyterhub
Install Homebrew on Amazon Linux 2
Install strongSwan 5.9.1 on Amazon Linux 2
I tried to create an environment of MkDocs on Amazon Linux
Create a Docker container image with JRE8 / JDK8 on Amazon Linux
I made a POST script to create an issue on Github and register it in the Project
Procedure until you can create a general user and execute the sudo command on CentOs (memorial note)
Install Pyethapp and generate an account
Install Python Pillow on Amazon Linux
Install Mecab and mecab-python3 on Ubuntu 14.04
Install oracle java8 on amazon linux2
Install and run dropbox on Ubuntu 20.04
Install OpenCV and Chainer on Ubuntu
(Windows10) Install Linux environment and gnuplot.
Install CUDA 8.0 and Chainer on Ubuntu 16.04
Create a Python environment on Mac (2017/4)
Build and install OpenCV on Windows
Install CUDA on Linux Mint Mate 20
How to create an email user
Run a Linux server on GCP
How to install VMware-Tools on Linux