I own a SQL private database, and I would to generate new databases with PHP code. My first step was to ensure I could send MySQL queries, but The
CREATE DATABASE command cannot be executed . In the other hand, I can create and delete new table without problem.
When I try to create a new database with MySQL workbench, the console say that I do not have the rights to do so🤔. I’m using the user from the User&Rights tab, and they only have the rights for the selected databases, so that’s not really surprising at all. Thus, isn’t there a kind of ‘super user’ or administrator user that I can use to send MySQL commands such as
Thank you for your answers😊