mariadb: Create database and User

Create database

create database DATABASE_NAME;

Create user with remote access, change 192.168.x.x to remote server address

grant all privileges on DATABASE_NAME.* TO 'USER_NAME'@'192.168.x.x' identified by 'PASSWORD';
flush privileges;

Leave a Reply

Your email address will not be published.