使用DSN ODBC连接到ONLINE MySQL数据库 [英] Connect to ONLINE MySQL database using DSN ODBC

问题描述

我正在连接一个在线MySQL数据库。

I am connecting an online MySQL database.

我已经下载MySQL ODBC Connector 5.1。现在我想设置DSN。但是得到的错误：

I have downloaded MySQL ODBC Connector 5.1. Now am trying to setup the DSN. But am getting the error:

Connection Failed : [HY000] [MySQL] [ODBC 5.1 Driver]Access Denied for user 'user123'@'myweb.com' 

我已经托管了一些托管服务提供商。我需要一些来自提供者的详细信息????

I have hosted this site with some hosting provider. Do i need some details from the provider????

我这样做>控制面板--->管理工具--->数据源（ODBC） - >然后我选择MySQL ODBC Driver 5.1 ----->然后在DIALOG中输入以下内容：

I am doing this > Control Panel--->Administrative Tools--->Data Sources (ODBC)--->Then i chose MySQL ODBC Driver 5.1-----> then i enter the following in the DIALOG which pops-up:

TCP / IP

userid = user123和密码 strong>，我输入这些userid = user123&

userid=user123 and password , I enter those userid=user123 & password which i enter when i open www.myweb.com/cpanel.

推荐答案

Cpanel默认情况下不允许远程连接。
请转到您的cPanel中的数据库区域，并添加您的公共IP地址，以便它可以接受来自您的IP地址的连接请求。

Cpanel by default does not allow remote connections. Please go to database area in your cPanel and add there your public IP address so that it can accept connection requests from your IP address.

这篇关于使用DSN ODBC连接到ONLINE MySQL数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！