notes/article/mysql/mariadb.md

Mariadb Memo

Initialize Mariadb

Basic user and dir config, using:

mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql

Security Configuration

mysql_secure_installation

Mariadb can login as system user root without password. Usually root can only be allowed to login from localhost.

Create Operation Users

Create a user with CRUD access:

create user demo_rw@'%' IDENTIFIED by 'your password';

Then grant access:

grant select, insert, update, delete on `demo`.* to 'demo_rw'@'%';

And refresh privilages:

flush privileges;