Results 1 to 4 of 4
  1. #1
    dmonk
    Guest
    Smile mysql : my first table
    I'm self-learning (crash course style) about mysql and
    it looks like I have mysql running:

    //-------------------------------Terminal---------------------------------

    [D-Ms-Computer:/usr/local/mysql] mysql1# sudo ./bin/mysqld_safe
    Starting mysqld daemon with databases from /usr/local/mysql/data

    //----------------------------end Terminal--------------------------------------

    My goal now is to create my first table.
    My goal is modest, I would be happy if I can just create a
    one row- one heading table : ) for now.

    The command I entered doesn't seem to be doing the job.
    I closed my terminal window, went to take a break and then I tried this:

    //-------------------------------Terminal---------------------------------

    [D-Ms-Computer:/usr/local/mysql] mysql1# sudo ./bin/mysqld_safe
    A mysqld process already exists

    [D-Ms-Computer:/usr/local/mysql] mysql1# CREATE DATABASE accounting;
    CREATE: Command not found.

    //----------------------------end Terminal--------------------------------------

    I'm REALLY new to the command line so, I'm a bit puzzled -- any ideas?

    Thank you in advanced for your help.

    dmonk

  2. #2

    Emrys's Avatar
    Member Since
    Oct 27, 2002
    Location
    Vermont
    Posts
    1,345
    Specs:
    17" iMac G4 800MHz 1GB RAM
    That seems right to me. But you need to be in the MySQL client to work with it. You don't just enter those commands in the shell. Try running mysql, and then you should get a mysql> prompt. From there you can run your sql commands.
    Emrys
    Community Administrator / Moderator
    MAC-FORUMS.COM - The Ultimate Source For Your Mac!

  3. #3

    Emrys's Avatar
    Member Since
    Oct 27, 2002
    Location
    Vermont
    Posts
    1,345
    Specs:
    17" iMac G4 800MHz 1GB RAM
    To run mysql, just enter "mysql" into the shell prompt. Without the "'s of course. You might need to authenticate yourself before you can create databases though. From what I just looked at, it defaults to the user you created mysql with, I think. So you might be ok. But that is something you should look into.
    Emrys
    Community Administrator / Moderator
    MAC-FORUMS.COM - The Ultimate Source For Your Mac!

  4. #4
    dmonk
    Guest
    Thank You
    Thanks Emrys for the support.

    It took me a couple of days but I got mysql client running and I created a quick table. Goal acomplished (for now) Now's time for a break! : )



    Quote Originally Posted by Emrys
    To run mysql, just enter "mysql" into the shell prompt. Without the "'s of course. You might need to authenticate yourself before you can create databases though. From what I just looked at, it defaults to the user you created mysql with, I think. So you might be ok. But that is something you should look into.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Table look up help
    By Rip Vega in forum OS X - Apps and Games
    Replies: 4
    Last Post: 08-05-2015, 04:59 PM
  2. How do I copy table table as plain text?
    By craftydad in forum Switcher Hangout
    Replies: 1
    Last Post: 01-29-2015, 02:27 PM
  3. Table - Pages
    By Christopher99 in forum OS X - Apps and Games
    Replies: 1
    Last Post: 01-10-2015, 02:46 PM
  4. Pages - table within a table?
    By watfordkev in forum OS X - Apps and Games
    Replies: 0
    Last Post: 07-13-2011, 04:08 PM
  5. route table
    By boo50 in forum Internet, Networking, and Wireless
    Replies: 0
    Last Post: 06-22-2006, 05:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •