Click here to Skip to main content
15,896,557 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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.
Posted

you have to import this namespace

MySql.Data.MySqlClient;


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


thanks
Animesh
 
Share this answer
 
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...
 
Share this answer
 
Install .NET connector for MySql from google.Then try to connect it.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900