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

Reputation: 3 Apprentice
Group:
Active Members
Active Posts:
196 (0.11 per day)
Joined:
25-March 10
Profile Views:
1,566
Last Active:
User is offline Today, 06:33 AM
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 16 Nov 2014

    Thank you for the response smendoza.

    I followed the instruction in this video to learn how to create a schema: https://www.youtube....39BGSUkzw#t=180

    I then noticed when I tried to to add a table, I was given an error message, stating, no schema was selected, so then I right clicked on the "world" schema and selected, set as "default schema", then it became bolded text.

    I click, Server (Yellow Box in the Following Image, at upper left) -> Data Import -> Import from self contained file -> Default Target Schema (world) -> Start Import
    Image 1: http://i.imgur.com/hPBrnYl.jpg

    I get the following message:
    11:06:26 Restoring E:\HIS Documents\Course Archives\Certificate Preparation\Oracle CA\Workbench\dumps\world.sql
    Running: mysql.exe --defaults-file="c:\users\usr1\appdata\local\temp\tmpbxzcy_.cnf"  --host=127.0.0.1 --user=root --port=3306 --default-character-set=utf8 --comments --database=world < "E:\\HIS Documents\\Course Archives\\Certificate Preparation\\Oracle CA\\Workbench\\dumps\\world.sql"
    11:06:27 Import of E:\HIS Documents\Course Archives\Certificate Preparation\Oracle CA\Workbench\dumps\world.sql has finished
    
    


    And the Tables were able to appear on the right hand corner: http://i.imgur.com/P5peEWA.jpg

    Thanks for helping me get this far.
  2. In Topic: Workbench 6.2 error, while testing "server" connection

    Posted 5 Nov 2014

    I was able to load the "World" database by coincidentally clicking the icon under the Edit button, at the top left corner.

    Posted Image

    What would be the next best course of action to have a "world" database schema(?) icon appear along with, cdcol, phpmyadmin, test, and webauth? As I've seen in other tutorial screenshot.

    If one has link to a good beginners tutorial on Workbench, preferably 6.0 or higher, it would be appreciated. Linking to version 5.0 would be okay though.

    Another fellow linked to "Apache Friends" but its seems that forum is geared towards phpmyadmin (a competitor of workbench?) and German speaking individuals.
  3. In Topic: Workbench 6.2 error, while testing "server" connection

    Posted 2 Nov 2014

    SInce I can't edit my previous post, due to one of the images having personally identifiable information, I have to post the following:

    Import failed: http://i.imgur.com/iqNeXX7.jpg, http://i.imgur.com/PLhOFta.jpg
  4. In Topic: Workbench 6.2 error, while testing "server" connection

    Posted 31 Oct 2014

    View PostArtificialSoldier, on 29 October 2014 - 12:25 PM, said:

    It looks like that window is actually the utilities client, which you can read about here:

    http://dev.mysql.com...en/mysqluc.html

    It's just a client to launch other utilities, it's not the MySQL console. I haven't used the workbench much, but I'm sure there's another way to launch the console through it.


    Yes the window is actually the mysql utilities client, mysqluc. Thank you for the clarification. It was a useful read, but I'm still wondering where I'm supposed to enter mysql commands in relation to creating/configuring databases and such through a CLI interface. http://i.imgur.com/LMwpb9N.jpg


    Would the following be it?
    Posted Image

    I hoping to get an OCA associate in conjunction with Java.

    Edit: It seems the answer yes. Then I'll need to obtain database files and load it into MySQL.

    For now, I'm to load the following, MySQL Help Tables, from the official my sql site.

    I extracted and pasted the file fill_help_tables-5.7.sql, in the directory:
    C:\Program Files (x86)\MySQL\MySQL Utilities
    


    When I execute the command:
    mysql mysql < C:\Program Files (x86)\MySQL\MySQL Utilities\fill_help_tables-5.7.sql
    


    I get the message: The utility mysql is not accessible from (from the path: C:\Program Files (x86)\MySQL\MySQL Utilities).
    Image: http://i.imgur.com/WKQO3qM.jpg

    Edit 2:
    I also tried importing the world database. It asked for the password (which I know I didn't set when I created a new connection), I simply left it blank and pressed enter.

    Import failed.
    Images: http://i.imgur.com/DsEkNXG1.jpg, http://i.imgur.com/PLhOFta.jpg
  5. 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.

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?