win mysql server remote access question

test_tube_tonytest_tube_tony Dallas TX Member
edited September 2007 in Science & Tech
i'm running a mysql server on a win2k3 box. kinda would like to know how to remotely access the server from another computer on the lan via command prompt. been looking online, but its all linux info. anyone care to point me in the right direction?

Comments

  • kryystkryyst Ontario, Canada
    edited September 2007
    You need a windows mysql client for any machine that you want to access it with if you need command prompt access. If you just need to link into it for database applications then you can link to it through the ODBC setup in Control Panel>Administrative Tools>Data Sources. The other option is to use a web based tool to manipulate it, which really is the easiest.
  • test_tube_tonytest_tube_tony Dallas TX Member
    edited September 2007
    kryyst wrote:
    You need a windows mysql client for any machine that you want to access it with if you need command prompt access. If you just need to link into it for database applications then you can link to it through the ODBC setup in Control Panel>Administrative Tools>Data Sources. The other option is to use a web based tool to manipulate it, which really is the easiest.

    yea. where do i find the client. isnt there some way to use the cmd prompt to do this? what exactly does ODBC do anyway? i know if i had installed this on linux i could just ssh into it, but im the idiot that uses windows for this sort of stuff lol
  • primesuspectprimesuspect Beepin n' Boopin Detroit, MI Icrontian
    edited September 2007
    No, you can't use the cmd prompt (unless they have a command line mysql client for windows - they probably do but I've never looked for one). ODBC creates a "DSN" which you can call in applications - you set up the connector through the ODBC control panel, and you have to make sure the windows mysql driver is installed on the server. It should come with ODBC drivers out of the box. Basically ODBC is sort of like DNS for databases -it's a clearinghouse for db connections. Your application can say "Hey, I need info from the database called 'poop' and I need this table from it". It doesn't care if it's mysql, mssql, oracle, whatever. ODBC takes that call and says "the database called poop is mysql and it can be found here".
  • ThraxThrax 🐌 Austin, TX Icrontian
    edited September 2007
    In WIN32, MySQL registers as an environment variable and can be called by typing "MySQL" at a command prompt. You can do anything you want with the MySQL install from MYSQL> prompt.
  • kryystkryyst Ontario, Canada
    edited September 2007
    Thrax wrote:
    In WIN32, MySQL registers as an environment variable and can be called by typing "MySQL" at a command prompt. You can do anything you want with the MySQL install from MYSQL> prompt.

    This is absolutely correct - if you are physically on the machine. It doesn't work remotely.

    Now I guess you could install mysql on the remote machine but target the server that exists on the target machine. No reason that won't work.

    ODBC stands for something (can't remember to lazy to look) but basically it's a pluggin for windows that allows you to attach various databases and use them universally in windows programs like excel, access, IIS, OpenOffice etc... You map the database in the ODBC mapper then the various programs talk to the ODBC mapper. This however still won't help you at the cmd prompt.

    Is there a real need to access it through the cmd prompt or do you just need remote access to it. There are programs to administer mysql remotely through a windows machine, they are free just go to the main mysql website all the tools are there.
  • test_tube_tonytest_tube_tony Dallas TX Member
    edited September 2007
    i mostly just wanted to force myself to learn mysql the hard way. ill see what i can find as far as clients go. does odbc allow ms access to connect directly with mysql?
  • ShortyShorty Manchester, UK Icrontian
    edited September 2007
    Easy peasy.

    Download and run a freeware SSH daemon on your server:

    http://www.freesshd.com/?ctt=overview

    Connect to said server using popular freeware command line SSH client "putty"

    http://www.chiark.greenend.org.uk/~sgtatham/putty/

    Log in and voila. Remote command line securely to your server, and then you can just type your MySQL commands like you would if you were sitting at it.
  • test_tube_tonytest_tube_tony Dallas TX Member
    edited September 2007
    Shorty wrote:
    Easy peasy.

    Download and run a freeware SSH daemon on your server:

    http://www.freesshd.com/?ctt=overview

    Connect to said server using popular freeware command line SSH client "putty"

    http://www.chiark.greenend.org.uk/~sgtatham/putty/

    Log in and voila. Remote command line securely to your server, and then you can just type your MySQL commands like you would if you were sitting at it.

    well, that sorta worked for a while. i cant log in to it anymore lol. only thing i didnt like was the fact that i couldnt scroll back. is there some adjustment for that?
  • ShortyShorty Manchester, UK Icrontian
    edited September 2007
    Don't make a mistake and you won't have to rollback ;D

    It probably won't let you login because someone has kicked your user session off. Just log back onto Windows and restart the daemon :)
Sign In or Register to comment.