mgrex's Profile User Rating: -----

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
188 (0.11 per day)
Joined:
25-March 10
Profile Views:
1,192
Last Active:
User is offline Sep 08 2014 06:24 PM
Currently:
Offline

Previous Fields

Country:
Who Cares
OS Preference:
Who Cares
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
0
Icon   mgrex has not set their status

Posts I've Made

  1. In Topic: Workbench 6.1, location of "SQL Development"

    Posted 7 Sep 2014

    Thanks for the last 2 post, they were very fortelling by far.
    I already had XAMPP downloaded on my computer, I had forgotten to install it.

    Server status with XAMPP "MySQL Module" disabled: http://i.imgur.com/Mz3XAsb.jpg

    Enabling MySQL Module in XAMPP resulted in 2 error messages: http://i.imgur.com/oJYkvUn.jpg, Code 1049: http://i.imgur.com/J7VLUhn.jpg

    If one could tell how to disable the "Fast reply" box at the bottom of each thread it would be grateful. It fails to send my post, and redirects me to the main forum page. Been having this problem for years.

    XAMPP "Shell" is able to recognize "mysql commands".
  2. In Topic: Workbench 6.1, location of "SQL Development"

    Posted 7 Sep 2014

    View PostSheepings, on 06 September 2014 - 11:32 AM, said:

    I agree with Aston, as you can't go wrong with command line knowledge. You can try this Tutorial which will give you a quick run-through of the program. I think the bookworm around here is probably modi123_1, and perhaps if he sees this post, he might recommend you a good book on database interactions. I don't think you will find any books on Workbench, and the most you can hope for is their Docs and tutorials on YouTube.



    I'd rather stick with Workbench 6.1.

    I looked at that you tube video. I tried setting up a server named "host1" using the localhost ip address 127.0.0.1, set a simple password. The bottom left corner reads:

    "Name:  host1
    Host: 127.0.0.1
    Port: 3306
     NO CONNECTION"
    


    How do I establish a connection?
    http://i.imgur.com/hMATRsN.jpg

    host1 settings: http://i.imgur.com/pc494UI.jpg

    My main goal here is to be execute options commands, in mysql CLI utility.
  3. In Topic: Workbench 6.1, location of "SQL Development"

    Posted 6 Sep 2014

    View Postastonecipher, on 06 September 2014 - 07:49 PM, said:

    Type:

    SHOW databases;

    and see what happens. are you using a LAMP/ WAMP stack currently?


    I got an "unknown command: SHOW databases;"

    I'm unaware of what LAMP / WAMP stack is.


    I installed the utility on my desktop which I have administrative access on (Windows 7).
  4. In Topic: Workbench 6.1, location of "SQL Development"

    Posted 6 Sep 2014

    WHere can I get a functioning mysql command line program?

    The one I'm using (MySQL utilities Console) states:

    Launching console ...
    
    Welcome to the MySQL Utilities Client (mysqluc) version 1.4.4
    Copyright (c) 2010, 2014 Oracle and/or its affiliates. All rights reserved.
    This is a release of dual licensed MySQL Utilities. For the avoidance of
    doubt, this particular copy of the software is released
    under the version 2 of the GNU General Public License.
    MySQL Utilities is brought to you by Oracle.
    
    Type 'help' for a list of commands or press TAB twice for list of utilities.
    
    mysqluc> mysql --helpThe utility mysql is not accessible (from the path: C:\Prog
    ram Files (x86)\MySQL\MySQL Utilities).
    mysqluc>
    


    The same message displays when I type "mysql-- version"
  5. In Topic: Workbench 6.1, location of "SQL Development"

    Posted 6 Sep 2014

    I've decided to start reading Dubois's "My SQL 5" instead, which places more emphasis on certificate preparation.

    He brings the up "World database" supplied on Oracle's website. What program should I primarily use to open and read it?

    http://dev.mysql.com...ndex-other.html : "world database (MyISAM version, used in MySQL certifications and training)"

    If one may direct me to books dealing with creating MySQL databases with Workbench 6 (preferable 6.1), it would appreciated. I have taken C++, so programming isn't entirely new to me.

    Eventually I'd like to study PHP from then on.

My Information

Member Title:
D.I.C Head
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:

Contact Information

E-mail:
Private

Friends

mgrex hasn't added any friends yet.

Comments

mgrex has no profile comments yet. Why not say hello?