Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Urgent: HOw to connect to MYSQL DB on another machine

lobojasonlobojason Member Posts: 8
[b][red]This message was edited by lobojason at 2004-9-22 2:43:47[/red][/b][hr]
I have the bugs database installed on so called server.

How can I access that bugs database from my machine...what are the configuration settings.


PLease it is urgent,

Jason


Comments

  • ITAITA Member Posts: 463
    : [b][red]This message was edited by lobojason at 2004-9-22 2:43:47[/red][/b][hr]
    : I have the bugs database installed on so called server.
    :
    : How can I access that bugs database from my machine...what are the configuration settings.
    :
    :
    : PLease it is urgent,
    :
    : Jason

    Connect to the server from the command line MySQL for example
    mysql -h [other computer] -u [your user name] -p

    The important part here is the -h option. Find out the IP address of the computer your accessing and stick it in there. If this fails you could connect to the other computer with SSH (Secure shell) or telnet and use the version of mysql on the other machine. Please bear in mind though that if you were to do that then because the mysql version is on the OTHER machine then it would have a server of localhost.

    For example

    execute
    mysql -h localhost -u [user] -p

    while logged into the server via SSH or telnet.

    Hope this helps.

    ITA
  • lobojasonlobojason Member Posts: 8
    Thank you ITA..it helped and it is working...

    Also to Mention.. I got hold of a GUI which helps to connect...MYSQL Control centre...its pretty neat as well..

    Many Thanks once again...


Sign In or Register to comment.