Create a database with MySQL Workbench
BMPCreated with Sketch.BMPZIPCreated with Sketch.ZIPXLSCreated with Sketch.XLSTXTCreated with Sketch.TXTPPTCreated with Sketch.PPTPNGCreated with Sketch.PNGPDFCreated with Sketch.PDFJPGCreated with Sketch.JPGGIFCreated with Sketch.GIFDOCCreated with Sketch.DOC Error Created with Sketch.
Question

Create a database with MySQL Workbench

by
Bangel
Created on 2021-02-18 22:35:20 (edited on 2024-09-04 14:24:50) in Hosted Private Cloud

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 😐. 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😊


Replies are currently disabled for this question.