Page History: How to Create a MySQL Database with MySQL Workbench
Compare Page Revisions
Page Revision: 23/05/2012 00:04
Introduction
MySQL workbench is a windows GUI software agent used to administrate MySQL servers and databases, and is often installed by default on a windows server running MySQL, however you can also install it remotely on a client or developer machine. This tutorial illustrates how to create a new database and a new user to access that database on a MySQL Server using phpMyAdmin.
Prerequisites
- You will require a root or DBA user login to the MySQL server, or a user login with permission to create new databases.
- MySQL servers are usually configured to NOT allow a root user login from a remote host. You will need to first create a DBA user login, or use MySQL Workbench locally installed on the Mysql Server.
- You will need to have MySQL workbench installed. To download the latest version click here.
Using Mysql Workbench Version 5.2
Open the MySQL Workbench software.
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench01.png)
Click on your MySQL instance under the
SQL Development section of Workbench to create a new schema.
NOTE: Databases are called schema's in MySQL Workbench.
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench02.png)
MySQL workbench requires a login to your Mysql server. Enter your root or user that has been assigned dba server privileges.
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench03.png)
Click on the
New Schema icon in the menu, and then enter a
name for your new database in the field as shown. Click the
Apply button to generate the SQL script.
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench04.png)
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench05.png)
Click the
Apply button again to execute the create database statement, and create your new database.
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench06.png)
Click
Finish. Your database should now be listed on the left with your other database schemas.
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench07.png)
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench08.png)
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench09.png)
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench10.png)
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench11.png)
![Image](GetFile.aspx?File=/images/screenshots/mysql/workbench12.png)