Page History: How to Create a MySQL Database with MySQL Workbench

Compare Page Revisions

2 1 0 Current 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 22/05/2012 23:57

Table of Contents [Hide/Show] Introduction Prerequisites Using Mysql Workbench Version 5.2

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.
• Note that in most circumstances, MySQL servers are configured to now allow root login from a remote host. You will need to first create a DBA user login, or otherwise use MySQL Workbench locally on the Mysql Windows Server.
• You will need to have MySQL workbench installed. To download the latest version click here.
  

Using Mysql Workbench Version 5.2¶