How to use a remote MYSQL server?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kode
    Member
    • Aug 2000
    • 54
    • 3.8.x

    How to use a remote MYSQL server?

    I am getting ready for a move of sites and would like to use the MYSQL from the new dedicate server we got before I actually move the site over. So can I setup in the config file for it to connect to an IP instead of localhost and if so what ports do I need opened for in and out to make this happen? Anything else I need to know? Running mysql-3.23.55-1ct if that matters. TIA.
    joor.com | rcfiles.com
    VBB: 3.8.1 | PHP: 5.1.6 | MySQL: 5.0.45
    Host: ThePlanet Dedicated Xeon 3210
  • Steve Machol
    Former Customer Support Manager
    • Jul 2000
    • 154488

    #2
    You can try setting thwe IP but for this to work the remote server will need to be configured to allow connections from your server.
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    • Kode
      Member
      • Aug 2000
      • 54
      • 3.8.x

      #3
      Originally posted by Steve Machol
      You can try setting thwe IP but for this to work the remote server will need to be configured to allow connections from your server.
      Thank you, I tried the IP already and it didn't work. Could you give me a pointer in what to read to set up the acceptance?
      joor.com | rcfiles.com
      VBB: 3.8.1 | PHP: 5.1.6 | MySQL: 5.0.45
      Host: ThePlanet Dedicated Xeon 3210

      Comment

      • Steve Machol
        Former Customer Support Manager
        • Jul 2000
        • 154488

        #4
        No sorry I don't have the first clue on how to do this.
        Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
        Change CKEditor Colors to Match Style (for 4.1.4 and above)

        Steve Machol Photography


        Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


        Comment

        • Kode
          Member
          • Aug 2000
          • 54
          • 3.8.x

          #5
          Originally posted by Steve Machol
          No sorry I don't have the first clue on how to do this.
          Thank you for the help. If anyone knows how to do this, am I on the right track that this is how to setup permission?

          GRANT ALL ON *.* to "myuser"@"A" IDENTIFIED BY "mypassword"
          joor.com | rcfiles.com
          VBB: 3.8.1 | PHP: 5.1.6 | MySQL: 5.0.45
          Host: ThePlanet Dedicated Xeon 3210

          Comment

          • TimPYN
            New Member
            • Feb 2003
            • 2

            #6
            I may be talking in the wrong direction but

            my vbulletin connects to a host which is not my server
            of course, my tech guy had to make that possible

            anyway,

            I am new to mysql, and I just wanted to say this much in hopes
            that the guy asking the question, or others may be able to use my weak tidbit of info in possibly coming to understand the possiblity


            thanks


            Tim

            Comment

            widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
            Working...