首页 > 数据库技术 > 详细

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

时间:2014-05-10 20:57:11      阅读:515      评论:0      收藏:0      [点我收藏+]

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)

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

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

原文:http://www.cnblogs.com/iwangzheng/p/3720761.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!