CREATE VIEW command denied for user:

[kupak51]

Username (e.g. epiz_XXX) or Website URL

epiz_31134482

Greetings. I have a problem with the management of the database, in my application I use created views, and I can’t create the views in PHPMy Admin. when executing a statement like this:

DROP TABLE IF EXISTS `institution`;
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `institution` AS SELECT `treating_physician`.`Institution` AS `institution` FROM `treating_physician` ;

MySQL responds

Error Message

MySQL Said: Documentation
#1142 - CREATE VIEW command denied for user: ‘epiz_31134482’@‘192.168.0.6’ for table ‘institution’

Other Information

How do I make views on this site?

[Greenreader9]

This part is incorrect

`root`@`localhost`

Make sure you are using the correct info

[kupak51]

Thanks. I have tried all reasonable alternatives.
even its simplest form.
In local mode with XAMPP and mariaDB they all worked.

CREATE VIEW `institution` AS SELECT `treating_doctor`.`Institution` AS `institution` FROM `treating_doctor` ;

And here it is with the user and server data.

CREATE ALGORITHM=UNDEFINED DEFINER='epiz_31134482'@'192.168.0.6'SQL SECURITY DEFINER VIEW `institution` AS SELECT `treating_doctor`.`Institution` AS `institution` FROM `treating_doctor` ;

MySQL ha dicho:

`#1142 - CREATE VIEW comando negado para usuario: 'epiz_31134482'@'192.168.0.6' para tabla 'institucion'`

The question is: are free accounts allowed to create views?

[Greenreader9]

@kupak51

are free accounts allowed to create views?

No, free accounts cannot create MySQL views. Sorry about that

[kupak51]

Thanks, that answer is very sad and forces me to do the whole site again, for something so dumb. This is sad .