Question : create database and grant user rights mariadb
Answered by : clumsy-chicken-qiykz1iaui27
create database [DB name];
CREATE USER '[DB_User_Name]'@'localhost' IDENTIFIED BY '[DB_Password]';
GRANT ALL PRIVILEGES ON [DB_Name].* TO '[DB_User_Name]'@'localhost';
show grants for 'demouser'@'localhost';
FLUSH PRIVILEGES;
Source : | Last Update : Sun, 29 Mar 20