首页 > 代码库 > 在服务器上远程链接另一台服务器的数据库的方法how to connet the database from the other host

在服务器上远程链接另一台服务器的数据库的方法how to connet the database from the other host

iwangzheng.com

 

16:57 [root@a02.cmsapi]$ mysql -u<username>
-p<password> -h10.103.xx.xx
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 571
Server version: 5.0.77 Source distribution

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

(username@10.103.xx.xx) [(none)]> show databases;
+--------------------------+
| Database |
+--------------------------+
| information_schema |
| mvf_for_ykew_development |
| test |
+--------------------------+
3 rows in set (0.00 sec)

(username@10.103.xx.xx) [(none)]> Ctrl-C -- exit!
Aborted
tty:[0] jobs:[0] cwd:[/tmp]
16:57 [root@a02.cmsapi]$ mysql -u<username>
-p<password> -h10.103.28.25  mvf_for_ykew_development <
/tmp/db_bak.20140509.sql
tty:[0] jobs:[0] cwd:[/tmp]
16:58 [root@a02.cmsapi]$ mysql -u<username>
-py<password> -h10.103.XX.XX  mvf_for_ykew_development <
/tmp/db_bak.20140509.sql




so,how to connet the database from the other host,just try this:
mysql -u<username>  -p<password> -h10.103.xx.xx

how to import the data to the database ,try this:
mysql -u<username>
-p<password> -h10.103.xx.xx  databasename <
/tmp/db_bak.20140509.sql(the local source)