Operating System & Version
windows 10
cPanel & WHM Version
86.0.21

MattSeidel

Registered
Jun 4, 2020
1
0
1
aw4yiow123
cPanel Access Level
Root Administrator
I am creating a database in mysql, however I cannot create views due to lack of permissions and in order to solve a requirement it is necessary to access this mysql function. The question is how can I grant the permissions?
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,271
313
Houston
The Database user needs the create view privilege in order to do this. The changes to the user should be made in cPanel>>Databases>>MySQL Databases -> Current Databases -> select the user you want to modify associated with the database you want to modify.