CODEWITHSUNDEEP
mysqlsql
wrek
wrek

Reputation: 1161

How to create a local database for MYSQL workbench?

Is it possible to create a local database on my home-computer for MYSQL workbench?

This server is only for my own use. Not to the outside community.

Upvotes: 3

Views: 7835

Answers (3)

Aditya Chauhan
Aditya Chauhan

Reputation: 104

Download XAMPP on your machine and install it. (Windows) After successful installation, you will be able to see an icon on your toolbar. Click on it and start Apache, MySQL and if anything you need. Open browser, type : localhost/phpmyadmmin This will give you an GUI to manage databases locally on your machine. XAMPP basically provides you local server.

Upvotes: 2

4EACH
4EACH

Reputation: 2197

You can download WAMP (Apache, Mysql, PHP) server on Windows.

Then add new connection in workbench.

host:127.0.0.1
username:root
password:<Empty>

Upvotes: 1

Yishagerew
Yishagerew

Reputation: 94

If this is what you are looking for, after creating a database in MySQL from your local machine, then that you could access the database through MySQL workbench as a local instance. It asks you to authenticate based on your MySQL conf though. Just the normal way!

Upvotes: 1

Related Questions