DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) Remote connection

Info Catalog (mysql.info.gz) Without DSN (mysql.info.gz) MyODBC Configuration (mysql.info.gz) MyODBC trace
 
 23.1.9.6 Establishing a Remote Connection to System A from System B
 ...................................................................
 
 If you want to connect to system A from system B with a username and
 password of `myuser' and `mypassword', here is a simple procedure.
 
 On system A, follow these steps:
 
   1. Start the MySQL server.
 
   2. Use `GRANT' to set up an account with a username of `myuser' that
      can connect from system B using a password of `myuser':
 
           GRANT ALL ON *.* to 'myuser'@'B' IDENTIFIED BY 'mypassword';
 
   3. The `GRANT' statement grants all privileges to user `myuser' for
      connecting from system B using the password `mypassword'. To
      execute this statement, you should be either `root' on system A
      (or another user who has appropriate privileges). For more
      information about MySQL privileges, refer to  User Account
      Management.
 
 
 On system B, follow these steps:
 
   1. Configure a MyODBC DSN using the following connection parameters:
 
           DSN            = remote_test
           SERVER or HOST = A (or IP address of system A)
           DATABASE       = test (The default database or an appropriate one)
           USER           = myuser
           PASSWORD       = mypassword
 
      To set up a DSN-less connection, refer to  Without DSN.
 
   2. Check whether you are able to access system A from system B by
      using ping or other means. If you are not able to reach system A,
      check your network or Internet connections or contact your system
      administrator.
 
   3. Try to connect using `DSN=remote_test'. If it fails, trace the
      MyODBC log, and take the further steps based on the error message
      from the log. If you need further assistance, send a detailed mail
      message to <myodbc@lists.mysql.com>.
 
 
 You can also find a simple HOWTO at
 `http://www.phphelp.com/tutorial/using-myodbc-to-connect-to-a-remote-database.html'.
 
Info Catalog (mysql.info.gz) Without DSN (mysql.info.gz) MyODBC Configuration (mysql.info.gz) MyODBC trace
automatically generated byinfo2html