blocks|key|4552685|text|检查您的MySQL用户设置，确保允许admin帐户从localhost以外的计算机登录。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|4552686|您可以像这样验证允许用户从哪些主机进行连接：|4552687|select+user,+host+from+mysql.user|code-block|syntax|javascript|4552688|如果admin用户只能从本地主机连接，那么您要么希望为正在连接的新主机设置权限，要么希望为使用%25的所有主机设置权限。|4552689|您可以像这样查看admin在本地主机上拥有哪些权限：|4552690|show+grants+for+'admin'@'localhost'|4552691|然后，您可以复制/粘贴这些授权，将主机部分更改为在另一个主机上授予相同的权限。|4552692|entityMap^0|I|5|Q|9|0|0|0|2|5|1B|1|0|8|5|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@$9|X|A|Y|B|C]|$9|Z|A|10|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|11|8|@]|D|@]|E|$]]|$1|H|3|I|5|J|7|12|8|@]|D|@]|E|$K|L]]|$1|M|3|N|5|6|7|13|8|@$9|14|A|15|B|C]|$9|16|A|17|B|C]]|D|@]|E|$]]|$1|O|3|P|5|6|7|18|8|@$9|19|A|1A|B|C]]|D|@]|E|$]]|$1|Q|3|R|5|J|7|1B|8|@]|D|@]|E|$K|L]]|$1|S|3|T|5|6|7|1C|8|@]|D|@]|E|$]]|$1|U|3|-4|5|6|7|1D|8|@]|D|@]|E|$]]]|V|$]]

Check your MySQL user settings to make sure the <code>admin</code> account is allowed to log in from machines other than <code>localhost</code>.

You can verify which hosts users are allowed to connect from like this:

<pre><code>select user, host from mysql.user
</code></pre>

if the <code>admin</code> user can only connect from localhost, then you'll either want to set up permissions for the new host you are connecting from or for all hosts using <code>%</code>.

You can see what permissions <code>admin</code> has on localhost like this:

<pre><code>show grants for 'admin'@'localhost'
</code></pre>

Then you can copy/paste those grants changing the host part to grant the same permissions on another host.

blocks|key|3085268|text|您必须授予admin+@cpc访问权限.......|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3085269|登录mysql并执行以下操作：|3085270|mysql>+GRANT+ALL+PRIVILEGES+ON+*.*+TO+'admin'@'%25'
->+++++WITH+GRANT+OPTION;|code-block|syntax|javascript|3085271|或者首先使用此命令检查，以首先查看priv。|3085272|SHOW+GRANTS+FOR+'admin'@'localhost';|3085273|再试一次。|3085274|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|S|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|T|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|U|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

You have to grant access for admin @ cpc....... 

Login to mysql and do the following:

<pre><code>mysql&gt; GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%'
-&gt; WITH GRANT OPTION;
</code></pre>

Or first check with this command to see the priv first.

<pre><code>SHOW GRANTS FOR 'admin'@'localhost';
</code></pre>

And try again...

blocks|key|4552757|text|确保您的MySql服务器允许远程连接。也许你的连接字符串并不完全正确。在此处检查连接字符串：http://connectionstrings.com/mysql|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|4552758|entityMap|0|LINK|mutability|MUTABLE|url|http://connectionstrings.com/mysql^0|1A|Y|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Make sure that your MySql server allows remote connections.
And maybe your connection string is just not the exact one. Check connection strings here: <a href="http://connectionstrings.com/mysql" rel="nofollow">http://connectionstrings.com/mysql</a>

blocks|key|979779|text|您将想要转到：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|979780|Security+>+Logins+>+Click+your+account+>+Properties+>+User+Mappings|offset|length|style|CODE|979781|并确保您拥有正确的权限|979782|entityMap^0|0|0|1V|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

You'll want to go to:

<code>Security &gt; Logins &gt; Click your account &gt; Properties &gt; User Mappings</code>

And ensure you have the correct permissions

blocks|key|769199|text|在服务器上的http://dev.mysql.com/downloads/connector/odbc/3.51.html.|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|769200|Using+IP地址而不是www.*.com|unordered-list-item|769201|
|769202|Require开放端口3306上，|769203|下载并安装"MySQL+ODBC+3.51驱动程序“|769204|769205|769206|string+MyConString+=+"DRIVER={MySQL+ODBC+3.51驱动程序}；“%2B+"SERVER=112.***.**.***;”%2B+"DATABASE=dbname;“%2B+"UID=u_name;”%2B+"PASSWORD=u_pass;port=3306;“%2B+"OPTION=3"；OdbcConnection+MyConnection+=新的OdbcConnection(MyConString)；OdbcConnection|769207|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/connector/odbc/3.51.html^0|6|1J|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|C|$]]|$1|G|3|H|5|6|7|13|8|@]|9|@]|C|$]]|$1|I|3|J|5|F|7|14|8|@]|9|@]|C|$]]|$1|K|3|L|5|F|7|15|8|@]|9|@]|C|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|C|$]]|$1|N|3|-4|5|6|7|17|8|@]|9|@]|C|$]]|$1|O|3|P|5|6|7|18|8|@]|9|@]|C|$]]|$1|Q|3|-4|5|6|7|19|8|@]|9|@]|C|$]]]|R|$S|$5|T|U|V|C|$W|X]]]]

<ul>
<li>Download and install "MySQL ODBC 3.51 Driver" at <a href="http://dev.mysql.com/downloads/connector/odbc/3.51.html" rel="nofollow">http://dev.mysql.com/downloads/connector/odbc/3.51.html</a>.</li>
<li>Using IP addresses instead of www.*.com</li>
<li>Require open port 3306 on server

<pre><code> string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
 "SERVER=112.***.**.***;" +
 "DATABASE=dbname;" +
 "UID=u_name;" +
 "PASSWORD=u_pass;port=3306;" +
 "OPTION=3";
 OdbcConnection MyConnection = new OdbcConnection(MyConString);
 MyConnection.Open();
</code></pre></li>
</ul>

I have a c# web service running on a different webspace to my MySQL database. i want to link them together so have the following c# code.

<pre><code> server = "www.***.com";
 database = "MyDataBase";
 uid = "admin";
 password = "Password";
 string connectionString;
 connectionString = "SERVER=" + server + ";" + "DATABASE=" +
 database + ";" + "UID=" + uid + ";" + "PASSWORD=" + password + ";";

 connection = new MySqlConnection(connectionString);
 try
 {
 connection.Open();
 }
 catch (MySql.Data.MySqlClient.MySqlException ex)
 {
 Console.WriteLine(ex.Message);
 }
</code></pre>

on the catch exception im getting the following error 

"Access denied for user 'admin'@'cpc13-ches4-2-0-cust195.9-1.cable.virginmedia.com' (using password: YES)"

im only running it locally at the moment so i dont know if that is helping or hindering.

c# connecting to mysql on different server

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我有一个c# web服务运行在与我的MySQL数据库不同的web空间上。我想要将它们链接在一起，所以有以下c#代码。            server = "www.***.com";        database = "MyDataBase";        uid = "admin";        passw...

问连接到不同服务器上的mysql的c#
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问连接到不同服务器上的mysql的c#EN