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. MySQL
  4. allow remote connection to mysql

allow remote connection to mysql

Scheduled Pinned Locked Moved MySQL
mysqlsysadminhelptutorialworkspace
6 Posts 4 Posters 5 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.
  • S Offline
    S Offline
    saurabh20067
    wrote on last edited by
    #1

    hi, Everybody im tearing my head how to enable remote connection on a machine with a wamp server installed.i have 2 machines A and B both are on local area network with windows environment.i want to access datbase on machine A using phpmyadmin of machine B.machine A and B both have a wamp server. the datbase is on machine A.Any help wud be greatly appreciated!!! Bot machine have win XP installed sameer

    R M B 3 Replies Last reply
    0
    • S saurabh20067

      hi, Everybody im tearing my head how to enable remote connection on a machine with a wamp server installed.i have 2 machines A and B both are on local area network with windows environment.i want to access datbase on machine A using phpmyadmin of machine B.machine A and B both have a wamp server. the datbase is on machine A.Any help wud be greatly appreciated!!! Bot machine have win XP installed sameer

      R Offline
      R Offline
      Reza Raad
      wrote on last edited by
      #2

      remote connection is enable by default only you need to turn off firewall on your database server machine

      Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

      S 1 Reply Last reply
      0
      • R Reza Raad

        remote connection is enable by default only you need to turn off firewall on your database server machine

        Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

        S Offline
        S Offline
        saurabh20067
        wrote on last edited by
        #3

        Dr, Reza i have disabled firewall inspite of that i cannot connect to my database server Regards Sameer

        R 1 Reply Last reply
        0
        • S saurabh20067

          hi, Everybody im tearing my head how to enable remote connection on a machine with a wamp server installed.i have 2 machines A and B both are on local area network with windows environment.i want to access datbase on machine A using phpmyadmin of machine B.machine A and B both have a wamp server. the datbase is on machine A.Any help wud be greatly appreciated!!! Bot machine have win XP installed sameer

          M Offline
          M Offline
          mike3169
          wrote on last edited by
          #4

          Perhaps you have phpMyAdmin not setup correctly. You need to rename the file config-inc.sample.pfp to config.inc.php open in editor: Edit these lines to look $cfg['blowfish_secret'] = 'Put something here you will remember'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */ $cfg['Servers'][$i]['host'] = 'localhost'; <<leave as localhost here Save that file, then re-upload it to your phpMyAdmin directory of your webserver. Then type in your browser, http://IPADDRESS_OF_YOUR_SERVER/pathtophpMyAdmin e.g. http://192.168.0.222/phpMyAdmin You should then get a logon. The default logon will be username>root with no password for a fresh install of MySQL. Once logged in I recommend going direct to the Priviledges link and make a password for root, also, then add another MySQL default user and use it for your scripts to connect to MySQL.

          1 Reply Last reply
          0
          • S saurabh20067

            Dr, Reza i have disabled firewall inspite of that i cannot connect to my database server Regards Sameer

            R Offline
            R Offline
            Reza Raad
            wrote on last edited by
            #5

            1-put your connection string here. i think you have illegal user, 2-put your error here...

            Human knowledge belongs to the world http://www.rad.pasfu.com/index.php

            1 Reply Last reply
            0
            • S saurabh20067

              hi, Everybody im tearing my head how to enable remote connection on a machine with a wamp server installed.i have 2 machines A and B both are on local area network with windows environment.i want to access datbase on machine A using phpmyadmin of machine B.machine A and B both have a wamp server. the datbase is on machine A.Any help wud be greatly appreciated!!! Bot machine have win XP installed sameer

              B Offline
              B Offline
              briogene
              wrote on last edited by
              #6

              Make sure that the port which is running mysql is open for remote connections. This you can put off the firewall, but if you want to set the Firewall on, just except the Mysql port which is usually 3306 or 3307.

              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