Access denied; in OpenSIS 9.1 Installation

[nikitakothari06]

Hi,

I am trying to install OpenSIS 9.1 on my cpanel server with PHP 8.0 and Mysql 8.0. I am getting following error post filling database details in an installer form.

Access denied; you need (at least one of) the SUPER or SYSTEM_VARIABLES_ADMIN privilege(s) for this operation

I have created a database from my cpanel user database section and given all the privileges that it supports.

What could be the issue ?

[msaikens]

Are you using a VPS environment? Does the user you created have superuser privileges within phpMyAdmin on WHM as well?

[nikitakothari06]

I am on a shared hosting environment.

[msaikens]

Shared environments will likely not work with open SIS because the core MySQL installation on the server your shared environment uses, almost certainly will not allow super privileges to any one shared environment user. It's a security risk. You'd have access to every database in every shared environment within your shell. You need a VPS or dedicated environment where you have roos user access to MySQL

…

On Wed, Sep 4, 2024, 1:36 AM nikitakothari06 ***@***.***> wrote: I am on a shared hosting environment. — Reply to this email directly, view it on GitHub <#314 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ABAAL743EBG522MBSWGJS6DZU2L7VAVCNFSM6AAAAABGU2RHL6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGMRXHE3DAOJSG4> . You are receiving this because you commented.Message ID: ***@***.***>