Regular database users cannot create views in MySQL / MariaDB. If you try to execute the CREATE and VIEW commands as a regular user you will receive the error "#1142 - CREATE VIEW command denied to user 'user'@'localhost' for table 'table'"

If you wish to grant these privileges to the database, you will have to login to the respective database using the username and password used for cPanel.

Was this answer helpful? 0 Users Found This Useful (0 Votes)

Most Popular Articles

Managing MySQL databases in cPanel

CPanel includes a very powerful tool for managing MySQL databases - "phpMyAdmin". For more...
Is MySQL / MariaDB access restricted to "localhost"?

To access the MySQL / MariaDB server from a remote location please contact our Tech Department....
What is the maximum size of a MySQL database?

HostX does not limit the number of databases that can be created within an account. However, to...
What is the maximum execution time of a MySQL query?

To ensure service quality for all users, each MySQL query can run for up to 8 seconds (maximum)....
How many simultaneous MySQL connections can a MySQL user open?

In the shared hosting environment a MySQL user can open up to 30 simultaneous connections to the...