OVH Community

Welcome to your community space. Ask questions, search for information, post content, and interact with other OVH Community members.

Create a database with MySQL Workbench

#1

Hello !
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 :neutral_face:. 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 CREATE DATABASE?
Thank you for your answers😊