全球主机交流论坛

标题: Direct Database Access [打印本页]

作者: 宋兵乙 时间: 2009-5-9 17:12
标题: Direct Database Access

Direct Database Access
Direct Database Access is a less secure way to manage your hosted databases which most users do not require. If you do not need to access your database remotely, then you should not enable Direct Database Access. For more information, see Why Connect Remotely to Shared Hosting Databases.

#
Allow Direct Database Access
[Help]
No Yes
# Note: Databases with External access are located on a separate server than databases without External Access.

不知道直接数据库访问到底是什么意思，与一般的有什么区别

作者: cpuer 时间: 2009-5-9 17:13
数据库远程连接？

作者: 宋兵乙 时间: 2009-5-9 17:23
难道是可以通过某个命令台操作mysql命令吗？

作者: 宋兵乙 时间: 2009-5-9 17:36
对于使用godaddy这款美国空间商的产品的国内客户，可能会兴奋下喽!Godaddy也支持数据库远程连接啦！

这个消息的确不错，同时也证实了godaddy这个美国主机商也在向其他美国空间商们靠齐，毕竟大家支持的功能，它不支持，这样会无形损失好多的客户的，这里也祝福godaddy在新的一年里能够提供更多的服务！

Godaddy现在终于支持远程连接数据库了，紧接而来的就是如何使用？这个也是天城下面要对这个海外空间的远程连接数据库功能，经过参考godaddy官网帮助栏和网上朋友们的努力测试，提供以下方法仅供参考，这里也谢谢同行们的贡献！！

要使用远程连接数据库，你需要下载以下软件
常见的数据库管理软件是:

MySQL Query Browser
Microsoft SQL Server Management Studio Express
下载安装后可以连接到你的数据库了. 下面是连接设置:

Host Name or Server
你自己设置的（The name of the server your database is stored on.)可以参考这个方法：
http://bbs.searchidc.com/viewthr ... &extra=page%3D1

端口
如果要求端口，输入下面的:
MySQL: 3306
MSSQL: 1433
User Name
数据库用户名.
Password
数据库密码。（自己设置的可以修改）
Database
你要连接的数据库.
注意: 你可以登陆主机帐户找到你数据库的 hostname, user name, 和password 。

常见问题：
为什我在建数据库的时候没有“Specify whether you want to allow Direct Database Access.”这个选项？
解答如下：

引用:

Thank you for contacting Online Support. In order to gain remote access to your database, we will need to manually migrate your account to a new server. In order to migrate your account, you will need to backup and delete the current databases. After you have completed this, please resopnd to this email with the following information:

- Permission for GoDaddy to manually migrate your account to a new server(Including domain name)
- Last 6 digits of a credit card on file

Using the Hosting Control Center, you can backup and restore SQL Server databases as often as you would like. However, you can only initiate a backup after any previous backup or restore request has completed.

When you create a back-up file using the Hosting Control Center, our system names the file using the name of the existing database. However, while you cannot define a filename during the back-up process, you can rename a file once the process is complete.

Note: You must use the .bak filename extension when renaming any SQL Server back-up file.

相关内容参考：
Setting up a MySQL Database for Your Web Site
Setting up a SQL Server Database on Your Hosting Account
Why Connect Remotely to Shared Hosting Databases

补充：

官网08年12月份更新的这个功能，不一定限制一定用上面的软件，其他的能用也行；

另：godaddy以前的数据库不支持外部链接的

希望大家能用到这个功能了，帮忙测试下哦！和大家分享下！！！

作者: 宋兵乙 时间: 2009-5-9 17:36

作者: cpuer 时间: 2009-5-9 17:38
不错呵，好像出来有些日子了

欢迎光临全球主机交流论坛 (https://hostloc.gdisk.cf/)