unable to connect to other machine's mysql server using C#?

Question

i need to connect to the other machine's mysql server using C# coding,below is my coding:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using MySql.Data.MySqlClient;

namespace c_mysql
{
    class Program
    {
        static void Main(string[] args)
        {
            string connection = "SERVER=192.168.1.5; Database=b2b; Uid=root;";
            MySqlConnection con = new MySqlConnection(connection);
            con.Open();
            MySqlCommand cmd = new MySqlCommand("select * from area",con);
            MySqlDataReader dr = cmd.ExecuteReader();
            if (dr.Read())
            {
                Console.WriteLine("connection successfull");
            }
            else
            {
                Console.WriteLine("not connected...");
            }
        }
    }
}

the ip address 192.168.1.5 is the ip address of other computer which is in LAN,I am able to connect through 192.168.1.5/phpmyadmin in url bar but when connecting through C# coding it says,

Host 'pc1' is not allowed to connect to this MySQL server

Pc 1 is my pc on which i am coding.

please help me.

check this out : http://stackoverflow.com/questions/1878458/1130-host-localhost-is-not-allowed-to-connect-to-this-mysql-server — Manoj Purohit, Dec 26 '14 at 07:44
would you please tell me what to do to the point rather referencing to other solutions..? — Dinesh Suthar, Dec 26 '14 at 07:47
It has to do with your mysql server not permitting `root` user to connect from other ips other than local.. solution is to provide access to your ip for this user on mysql server...and I just provided you link for how to do that... and btw `tell me what to do` is not a developer's attitude ! — Manoj Purohit, Dec 26 '14 at 07:54

score 0 · Answer 1 · answered Dec 26 '14 at 09:10

Enable Remote Root Access to MySql. click here for more details

Snippet taken from above:

create a new HOST for root and allow root to login from anywhere.

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
mysql> exit

unable to connect to other machine's mysql server using C#?

1 Answers1

Enable Remote Root Access to MySql. click here for more details