odbc连接mysql记录权限设置_MySQL 5.1具有只读访问权限的ODBC 5.1连接字符串

最新推荐文章于 2022-08-23 18:27:26 发布

哪怕是你

最新推荐文章于 2022-08-23 18:27:26 发布

阅读量225

点赞数

文章标签： odbc连接mysql记录权限设置

本文链接：https://blog.csdn.net/weixin_33436866/article/details/113239152

版权

I have read-access to a MySQL database and am trying to connect to it via the MySql ODBC 5.1 driver. I'm getting an authorization failure (401) from the server. The administrator set up my access as follows:

mysql> grant select, create temporary tables on theDatabase.* to 'adrian' identified by 'password';

I am successful in connecting to the database using tools like dbvisualizer.

The connection string I'm trying to use in C#.NET is as follows:

"Driver={MySQL ODBC 5.1 Driver};Server=theDatabaseServer;Database=theDatabase;User=adrian;Password=password;Option=3;"

Perhaps the problem is related to the inability to specify my limited authorization in the connection string? Any suggestions on how to get around this (without having to request full access to the db)?

And what is the magic in "Option=3" ... are there other options?

Thanks.

解决方案

Try for the user "uid" and for the password "pwd" in the query string. This should be a valid connection string:

string ConnectionString = @"driver={MySQL ODBC 3.51 Driver};server=localhost;database=books;uid=band;pwd=letmein;";