how to configure MySql Server Instance

Question

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 23-Aug-13 17:35pm

Member 9822231

Add a Solution

3 solutions

Add a Solution

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

Animesh Datta · Answer 1 · 2013-08-23T20:03:00

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

Member 9822231 · Answer 2 · 2013-09-01T20:25:00

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...

Jitendra Sabat · Answer 3 · 2013-09-01T20:31:00

Solution 4

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

Posted 1-Sep-13 20:31pm

Jitendra Sabat

how to configure MySql Server Instance

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

how to configure MySql Server Instance

3 solutions

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us