Simple MySql question...

Discussion in 'Web Design and Development' started by tektonnic, Jun 6, 2006.

  1. tektonnic macrumors 6502

    tektonnic

    Joined:
    Mar 6, 2006
    Location:
    Bucks, UK
    #1
    Hi All,

    I set up an Apache and MySQL on a Windows 2000 server in my house, now i want to use OS X to edit MYSQL through terminal - command do i make to remotly connect to the machine, the server ip is 192.168.2.2.

    surely this is easy and im a donut?
     
  2. orkle macrumors member

    Joined:
    Aug 8, 2004
    Location:
    Manchester, England
    #2
    You might be better to use something like phpMyAdmin and it's web interface:

    http://www.phpmyadmin.net/

    This is what I've used for ages... :)
     
  3. angelneo macrumors 68000

    Joined:
    Jun 13, 2004
    Location:
    afk
    #3
  4. tektonnic thread starter macrumors 6502

    tektonnic

    Joined:
    Mar 6, 2006
    Location:
    Bucks, UK
    #4
    i know how to create and edit dbs and tables from command, i just want to connect using terminal - is this impossible?
     
  5. jeremy.king macrumors 603

    jeremy.king

    Joined:
    Jul 23, 2002
    Location:
    Fuquay Varina, NC
    #5
  6. realityisterror macrumors 65816

    realityisterror

    Joined:
    Aug 30, 2003
    Location:
    Snellville, GA
    #6
    From what I understand, he wants to and knows how to use MySQL from the command line, but wants to do it remotely.

    The best way to connect to the other machine is through SSH. I'm not sure how to setup an SSH server on your Windows machine, but this link should help you in getting started.
    After you have the SSH server working, presuming your username on the Windows machine is bob, you would use this command in your OS X terminal:

    ssh bob@192.168.2.2

    You would then be asked for bob's password, and you'll be at Window's command line. I'm sure you know where to go from there.

    (If you're using this as an actual server, you might consider not using Windows if possible. I found this great guide for setting up a server under Ubuntu yesterday.)
     
  7. jeremy.king macrumors 603

    jeremy.king

    Joined:
    Jul 23, 2002
    Location:
    Fuquay Varina, NC
    #7
    I read it that he wants to use the mysql command line client on his OS X machine to connect to his MySQL server instance running on his windows box....How about a clarification, tek...
     
  8. realityisterror macrumors 65816

    realityisterror

    Joined:
    Aug 30, 2003
    Location:
    Snellville, GA
    #8
    In that case, it would be easier to use your solution, methinks.

    Just use 192.168.2.2 as the hostname instead of localhost

    mysql -h 192.168.2.2 -u bob -p
    Prompt for password
    USE DATABASE db1;
     
  9. tektonnic thread starter macrumors 6502

    tektonnic

    Joined:
    Mar 6, 2006
    Location:
    Bucks, UK
    #9
    Thats right, thanks for that guys, the ubuntu idea is interesting because as I've started doing this I've started realising that windows is a pain...oh thats why I switched...!
     

Share This Page