Mysql queries for databse user, privileges OJS

I came across several servers with difficulties in phpmyadmin. WHich Mysql queries/command you suggest as the best to create databse, user and granting privileges in order to do installation of OJS properly?


Hi @vvucic

create database ojs_db;
grant all privileges on ojs_db.* to ‘ojs_user_name’@‘localhost’ identified by ‘ojs_user_pass’;

The last command should also create that user, with that password.


Yes, I checked that. I found out that in some cases it was needed to put that host is instead of localhost during installation. If otherwise, it reported that there is database permission denied.