MySQL: Steps for creating a DB
MySQL Installation First you need to install the MySQL server on your local environment. As soon as the installation is finished, the server should be up and running. MySQL WORKBENCH I use MySQL WORKBENCH extensively for creating and managing easily all my databases. You must install MySQL WORKBENCH on your computer if you've not done that yet. You can easily add a connection via this window : Create Schema Add a new Model (File/New Model) Edit the default schema (On Physical Schemas, right click ' mydb ') Change the schema name Add tables, views... Forward Engineer to Database We assume that your schema is ready to 'deploy' to your MySQL server. Click Database/Forward Engineer... Select your MySQL server Accept default options values Revue the SQL script to be executed Click next to continue The database should have been successfully created on your MySQL server. Adding administrator for the created database Open yo...