Connecting the mysql database in lan

Question

4.00/5 (1 vote)

See more:

hi

iam suffering a lot with connecting the mysql database to my windows application which was developed in C#.net , and i am trying to connect through the mysql dotnetconnector,

i had tried a lot ,i am getting the differtent types of errors so please try to help he, i had asked the same question before also but .....

i need some help that where i am going worng, please let me know

this is my sample code

<pre lang="cs"> 
MySqlConnection con = new MySqlConnection("server=192.168.0.89;database=test;uid=root;Pwd=dafd17512;");
           if (con.State.ToString() != "Open")
           {
               con.Open();
           }

when iam pinging i am getting the good result and more over in my browser i am opening and also creating the database from my browser only,
so i think i am going in the fine way but when i tried through the program line
i am getting the errors like
Host '22NDSTRE-F72BB9' is not allowed to connect to this MySQL server

here 22NDSTRE-F72BB9 is my system name , iam tring to communicate beetween the windows xp and windows7 and i also tried between windows xp- windowsxp
but no use so please give me a valiable suggestion

when i am trying to connect to localhost , its working perfectly
that sample code is

<pre lang="cs">
 MySqlConnection con = new MySqlConnection("database=test1;server=localhost;uid=root;");
              if (con.State.ToString() != "Open")
              {
                  con.Open();
              }

please give suggestion

Posted 29-Mar-11 0:55am

sivakumarmr10

Add a Solution

5 solutions

Solution 1

Please check the following link for different options for connecting to MySQL database:

http://www.connectionstrings.com/mysql[^]

Posted 29-Mar-11 0:57am

Om Prakash Pant

Comments

[no name] 29-Mar-11 6:58am

i had tried a lot with this connecting strings

Solution 2

I guess this is a MySQL configuration issue. Per default MySQL only listens to 127.0.0.1 so you can connect only via localhost. Have a look at the my.cnf file and comment out the line stating 'bind 127.0.0.1'

Posted 29-Mar-11 1:00am

Michel [mjbohn]

Solution 3

You can try this[^]. Its a tutorial on how to bind your database server and your application server.

If it doesnt still solve your problem, you may try this[^]. Its a statement you will use to grant the user access to the database. Its questionable if your root account doesnt have access to your DB, but, it may be worth trying this as well. :)

Posted 29-Mar-11 1:11am

walterhevedeich

Comments

Michel [mjbohn] 29-Mar-11 7:20am

Even root may only connect from localhost if there isn't an entry in usertable to allow any host.
You can check this with "select User,Host from mysql.user where User='root';" If there no entry like '%' in the host column you can't do a remote login

walterhevedeich 29-Mar-11 7:34am

I understand. That is why my statement was it is questionable if the root account does not have access to the DB. Anyway, I have provided another link for the configuration of his my.cnf, which was also similar to the solution you first posted. I should have read your post before giving mine. :)

Solution 5

Hi To all,

If you have mysql-workbench then login into it and go to admin panel and add the access entry over there.

For eg : root user from 192.168.1.1 is trying to access the database of 192.168.1.2

Posted 14-Jul-13 23:21pm

nitin-aem

Comments

CHill60 15-Jul-13 14:32pm

See the solutions that were added 2 years ago

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

sivakumarmr10 · Accepted Answer · 2011-07-11T03:58:00

hi i found the error after a lot of struggling

that is the changes in the MySQL server. just like giving the all privileges to the using user-id,and trying to keep the host as the "ANY" this is the particular you need to change

sample code:

MySqlConnection con = new MySqlConnection("server=192.168.0.89;database=test;uid=root;Pwd=dafd17512;");
           if (con.State.ToString() != "Open")
           {
               con.Open();
           }

and thanks for the support

Connecting the mysql database in lan

5 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0

Existing Members

...or Join us