Webinoly is just the perfect tool for NGINX experts. Give it a try!
0 votes
515 views
by Rookie

Hello ... Today I have a error while one of my plugin try to CREATE VIEW on the database :

https://i.imgur.com/Zw7fxAl.png

Webinoly create a user with SELECT,ALTER,UPDATE,INSERT,CREATE,DELETE,DROP,INDEX,REFERENCES rights instead of ALL PRIVILEGES and that's may cause the problems

Could you please help !

1 Answer

0 votes
by Expert

Hi Mitch,

You're right!

The thing is that now some Cloud Providers does not support "GRANT ALL PRIVILEGES" and "GRANT OPTION", so we recently changed our script to create users with limited privileges as you noted (GRANT SELECT,ALTER,UPDATE,INSERT,CREATE,DELETE,DROP,INDEX,REFERENCES). Also, newer MySQL/MariaDB versions have some changes on this matter.

Definitely, this is something we can improve, you can always change/update your user privileges manually according to your needs.

by Rookie
Thanks for your instant reply, 
I changed the permission (GRANT CREATE VIEW or GRANT ALL) and it works.
However it's always better to tell you the compatibility issues  I use Lightsail !
by Rookie
For other members' information : The newest version has 'database user role' to solve the problem I had. Thanks for the updates !
by Expert

That's right!

Now we have multiple options to set the default privileges when a DB is created, check the "dbrole" option: https://webinoly.com/documentacion/webinoly/#confile

Welcome to the Community site for Webinoly.

Our Optimized LEMP Web Server is a powerful set of commands for doing just about anything you could wish.

With Webinoly you can set up your NGINX web server in just one step.

* * * * * * *

To report a bug, please create a new issue on GitHub or ask a question here with the bug tag.
Webinoly Support Paypal Donations

PayPal · GitHub Sponsors · Bitcoin

It is very important that any visitor to the site read the disclaimer, terms of use and privacy and legal statement before start browsing.

...