Help out a newbie make first MYSQL Database locally on a Windows 7 PC

Discussion in 'MySQL' started by xarzu, Jan 31, 2015.

0
  1. #1
    I downloaded mysql-installer-community-5.6.22.0 from the MySql web site and I ran it to install it. I checked the option to install everything. I do not know where to begin?

    I have installed mysql on a WIndows 7 PC. My goal is to create a simple database with maybe a couple of tables with a few fields. Then, I want to link to this local database with a java program.

    The MySql command line client appears in my start menu; and I have a MySql menu folder on my sustem with the following items:

    MySql Workbench 6.2 CE
    MySql Connector Net 6.95
    MySql for Visual Studio 1.2.3
    MySql Installer - Community
    MySql Notifier 1.1.6
    MySql Server 5.6
    MySql Utilities

    I do not know where to begin. I thought the workbench would provide a way to easily start creating a database and tables, but I did not find it.

    The online documentation provided some API references but I did not see any tutorials.

    Please help. I will be satisfied with just creating one with the command line tool if necessary.
     
    xarzu, Jan 31, 2015 IP
  2. PoPSiCLe

    PoPSiCLe Illustrious Member

    Messages:
    4,623
    Likes Received:
    725
    Best Answers:
    152
    Trophy Points:
    470
    #2
    You need to either research cli mysql commands, or install a database manager. My suggestion, although albeit a little beyond what you need, is to download WAMP, install it and use phpMyAdmin to setup the database
     
    PoPSiCLe, Jan 31, 2015 IP
  3. xarzu

    xarzu Well-Known Member

    Messages:
    58
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    111
    #3
    I figured out MySql Workbench 6.2 CE. It calls databases "schemas". Once I got it figured out, it is not a bad tool to use.
     
    xarzu, Feb 1, 2015 IP