Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Database & SysAdmin
  3. Database
  4. remote mysql server connection problem?

remote mysql server connection problem?

Scheduled Pinned Locked Moved Database
helpdatabasemysqlsysadminquestion
6 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • H Offline
    H Offline
    hande54
    wrote on last edited by
    #1

    Hi! I need to connect remote mysql server and get the data. But I could not succeed it. I use reel IP address as serverIpAddress MySqlConnection CN = new MySqlConnection("server=serverIPaddress;Port=3306; user=root; password=test; database=dbtest;"); Also I update my nat table to forward connections. But I get this error A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll Could you help me on this issue?

    B 1 Reply Last reply
    0
    • H hande54

      Hi! I need to connect remote mysql server and get the data. But I could not succeed it. I use reel IP address as serverIpAddress MySqlConnection CN = new MySqlConnection("server=serverIPaddress;Port=3306; user=root; password=test; database=dbtest;"); Also I update my nat table to forward connections. But I get this error A first chance exception of type 'MySql.Data.MySqlClient.MySqlException' occurred in MySql.Data.dll Could you help me on this issue?

      B Offline
      B Offline
      Blue_Boy
      wrote on last edited by
      #2

      Have you search on google for that error?[^] http://www.connectionstrings.com/[^]


      I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

      H 1 Reply Last reply
      0
      • B Blue_Boy

        Have you search on google for that error?[^] http://www.connectionstrings.com/[^]


        I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com

        H Offline
        H Offline
        hande54
        wrote on last edited by
        #3

        Yes. I have searched but I could not overcome this problem. It is not related with the string that I use. It is totaly about configuration settings on mysql.

        L 1 Reply Last reply
        0
        • H hande54

          Yes. I have searched but I could not overcome this problem. It is not related with the string that I use. It is totaly about configuration settings on mysql.

          L Offline
          L Offline
          Lost User
          wrote on last edited by
          #4

          Is that a database on your LAN, or is it located somewhere else? (e.g., a database from a webhosting company?)

          I are Troll :suss:

          H 1 Reply Last reply
          0
          • L Lost User

            Is that a database on your LAN, or is it located somewhere else? (e.g., a database from a webhosting company?)

            I are Troll :suss:

            H Offline
            H Offline
            hande54
            wrote on last edited by
            #5

            Database is on another machine that is not in my LAN.

            L 1 Reply Last reply
            0
            • H hande54

              Database is on another machine that is not in my LAN.

              L Offline
              L Offline
              Lost User
              wrote on last edited by
              #6

              Then chances are that there's a firewall. Second thing to check would be if MySQL accepts remote connections - those are disabled by default[^], for security reasons.

              I are Troll :suss:

              1 Reply Last reply
              0
              Reply
              • Reply as topic
              Log in to reply
              • Oldest to Newest
              • Newest to Oldest
              • Most Votes


              • Login

              • Don't have an account? Register

              • Login or register to search.
              • First post
                Last post
              0
              • Categories
              • Recent
              • Tags
              • Popular
              • World
              • Users
              • Groups