Menu
Why I cannot alter my schema name from the MYSQL Workbench? Am i missing something? :(
As you can the name is dissabled
258
To change the name of the default schema, double-click the schema tab. This opens a schema editor window docked at the bottom of the application. To undock or redock this window, double-click anywhere in the editor title bar. To rename the schema, use the field labeled Name.
Right-click on the tables which are on the wrong schema, and select "Copy SQL to clipboard". Paste the script in a new SQL window. Repeat for each table you want to migrate. Edit the script to change the schema name.
The Schema Privileges tab refines the way you assign access rights to one or more schemas by user account. To assign privileges to the selected account by schema, do the following: Add a schema entry (or rule) that specifies which schema or schemas apply the selected user account.
To rename a schema you must also have the CREATE privilege for the database. To alter the owner, you must also be a direct or indirect member of the new owning role, and you must have the CREATE privilege for the database. (Note that superusers have all these privileges automatically.)
There is no RENAME available for schema names. You will have to export the schema, then import with a new database name.
This is a limitation of the MySQL server itself.
105
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
