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.
-
Yes, it is very possible and I have done it. MySQL is open source, so you can just download the free community edition and get started. You would be able to "see" the database from your local machine, if you plan to do any development work there.Tim Biegeleisen– Tim Biegeleisen2016-11-03 05:00:55 +00:00Commented Nov 3, 2016 at 5:00
Add a comment
|
3 Answers
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.
1 Comment
Aditya Chauhan
For Ubuntu: techtunes007.wordpress.com/2014/07/30/…
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!
Comments
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>
