Do you need to create a new schema in Toad for MySQL? Here are the summarized steps.
1. Access to MySQL with user: root
2. Object Explorer -> Databases
Right click: Create Database
Name
3. Open editor window
File -> New -> Editor
USE nombre_esquema
CREATE TABLE ́ nombre_tabla ́
They must be created in the correct order according to the constraints that have been defined.
This point is very important, if you are not going to return an error the system.
4- Create database user
Create User User
: UsernameHost: %
Password: enter password
Repeat password -> repeat passwordIf the password was not created at the time of user creation
4.1- About the user -> Right button -> Alter UserCheck box: Redefine -> enter password
Repeat password -> repeat password
