Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2010
    Posts
    1

    Question Unanswered: Connection MySQL from Remote mechine help

    Hi all

    I have sudo user to connect mySQL Server,that means

    Connection Example:

    login as: xxxxxxx

    xxxxxxx@100.10.1.0's password:

    Last login: Tue Dec 11 17:01:16 2009 from aaaaaa-aaa.bbbbb.cccc.com

    Could not chdir to home directory /nethomes/xxxxxxx: No such file or directory

    [xxxxxxx@preproduction/preproduction001 /]$ sudo -s

    Password:

    bash-3.2# mysql -uroot -p

    Enter password:

    Welcome to the MySQL monitor. Commands end with ; or \g.

    Your MySQL connection id is 19990

    Server version: 5.0.82sp1-enterprise-gpl-log MySQL Enterprise Server (GPL)

    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

    MY-MASTER>

    If I want connect to mysql from remote mechine MySQL workbench.... what is the procedure ?
    Please guide me /help me how to connect..Appreciate your help

    Note: I am able to connect using "PUTTY"

  2. #2
    Join Date
    Jun 2007
    Posts
    197

    Smile

    Please contect to sysadmin member He will provide you an external Ip and new port(that will be redirect port that connect to mysql port 3306)

  3. #3
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Hi,

    I have put together a screencast explaining the basics of client server technology in particular for MySQL. Check this link: Client Server – The basics IT Integrated Business Solutions.

    To access remotely a MySQL server you will need both the host and the port number to uniquely identify the service you need. By default the port is set to 3306 for MySQL servers. The host or host IP address I think you know from the information you provided below.

    Using the mysql command line application what you need to do is

    Code:
    mysql -h hostname -P portnumber -u username -p
    Where hostname is either a name or an IP address and portnumber is the port on which the server resides (by default 3306).
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

Posting Permissions

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