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

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
191 (0.11 per day)
Joined:
25-March 10
Profile Views:
1,260
Last Active:
User is offline Oct 28 2014 07:40 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.2 error, while testing "server" connection

    Posted 28 Oct 2014

    I deleted the hold Host 1 connection, because it failed a connection test I stored in the a password in the vault, which was, 123.

    So I created another connection with the Hostname "127.0.0.1", and was able to test connection successfully. Default schema was left blank.

    I entered the code by smendoza
    GRANT ALL ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY '[PASSWORD]';
    


    And it was a dead end :(/>/>

    Posted Image


    Enter 123 for password: http://i.imgur.com/Q73PmNM.jpg, Then click Test Connection: http://i.imgur.com/pqUOUyx.jpg
    Then it's back to square one. Delete connection entirely, and re-create another connection without setting password.
  2. In Topic: Workbench 6.2 error, while testing "server" connection

    Posted 27 Oct 2014

    I followed both your recommendations, changing from 127.0.0.1 to localhost, and leaving default schema blank, and still have the same problem

    Posted Image

    Edit 1: After making the changes I went ahead and ran XAMPP at the same time, and I no longer got the code error 1049. So it seems smendoza or ArtificialSoldier's suggestion worked. Thank you both, for the response. Server is running in WorkBench it seems: http://i.imgur.com/m2P5aO9.jpg

    Posted Image

    Unfortunately I can't run commands such as "mysql --version", is not accessible:

    Posted Image

    Again the command is able to work in XAMPP when I run shell from that program.
  3. 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".
  4. 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.
  5. 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).

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?