SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)

    Connecting to remote database using MySQL-Front?

    I am trying to connect to a database on another server but I keep getting an error and I can't figure out how to fix it.

    It is telling me the username and password are wrong but they are right. For some reason it is making my username look like this:

    Code:
    username@myip
    which I think is screwing it up.

    Any suggestions?

  2. #2
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you sure the server allows you to connect via a remote host? How do you know it's concatating it?

    Aaron
    Aaron Brazell
    Technosailor



  3. #3
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    It doesn't even connect... it finds the IP but doesn't connect because of the username and password.

    BTW, this is the ratearaider.org site

  4. #4
    SitePoint Wizard silver trophy redemption's Avatar
    Join Date
    Sep 2001
    Location
    Singapore
    Posts
    5,269
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    It's doing that because it has to. The MySQL server checks where requests are coming from by host.

    If your permissions table doesn't have a columns like these:
    Code:
    host   user
    ----   ----
    %      hartmann
    yourip hartmann
    it won't allow you to login remotely. GRANT yourself permission to connect from your IP (or use the '%' wildcard)

  5. #5
    chown linux:users\ /world Hartmann's Avatar
    Join Date
    Aug 2000
    Location
    Houston, TX, USA
    Posts
    6,455
    Mentioned
    11 Post(s)
    Tagged
    0 Thread(s)
    yep that worked. Thanks


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •