Once at the MySQL console, create the new user with the command: create user 'dbadmin'@'%' identified by 'PASSWORD'; where PASSWORD is a strong and unique password. Grant the user the rights to ...

Click apply to create the MySQL scheme; The MySQL workbench executes the required SQL statement under the covers, and the schema is listed in the tool. With the schema created, you can now provide any ...

Creating new databases is similarly easy—in short, create database dbname and presto, you've got a new database named dbname. MySQL users who have privileges on *.* will have privileges to work ...