如何配置MySql Server实例 [英] how to configure MySql Server Instance

问题描述

我正在安装Mysql5.0，但在配置MySql Server Instance时遇到错误： -

用户'root @ localhost'拒绝访问（使用密码YES）



plz providem帮助如何解决这个问题。需要通过dotnet win apps连接mysql数据库。

i am installling Mysql5.0 but while configuring MySql Server Instance getting an error :-
Access denied for user 'root@localhost'(using password YES)

plz providem help how to solve this problem. need to connect mysql database through a dotnet win apps.

推荐答案

你必须导入这个命名空间

you have to import this namespace

MySql.Data.MySqlClient;

如果找不到这个（MySql.Data.dll）在你的机器上然后从.net下载它。



然后像这样连接到mysql ..

and if you don't find this (MySql.Data.dll) in your machine then download it from .net.

then connect to mysql like this..

MySqlConnection con = new MySqlConnection("server=server_ip;User Id=username;database=databasename;password=password");//if password is there

< br $> b $ b

谢谢

Animesh

thanks
Animesh

转到控制面板单击Windows防火墙，在左侧选项卡中单击高级设置，在另一个窗口中单击左侧选项卡中的入站规则，现在在右侧选项卡中单击新规则，选择端口单选按钮，然后单击下一步，现在选择TCP和特定本地端口。键入Here 3306，Next选择Alow Connections。，next，next提供任何名称完成。去运行dailog box ...按（ctrl + R），键入services.msc并在列表中找到windows防火墙。如果防火墙打开，请停止它。

现在配置您的MYSQL配置。 wizard ...

Go to Control panel click Windows Firewall, in the left tab click advanced setting, in another window click Inbound Rules in left tab, now in right side tab click New rules, select port radio button, then Next, now select TCP and Specific Local Ports. Type Here 3306, Next select Alow Connections., next, next Provide any name finish . go to run dailog box... by pressing (ctrl + R),type services.msc and find windows firewall in the list. stop it if firewall is on.
Now configure Your MYSQL Config. wizard...

从谷歌安装MySql的.NET连接器。然后尝试连接它。

Install .NET connector for MySql from google.Then try to connect it.

这篇关于如何配置MySql Server实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！