How To Create a New User and Grant Permissions in MySQL

Access MariaDB Server

mysql -u root -p

Create new database

CREATE DATABASE bdhostidb;

Check whether the database created

SHOW DATABASES;

GRANT ALL PRIVILEGES ON 'sqI_bdhositit_co'.* TO 'sqI_bdhositit_co'@localhost;