Results 1 to 3 of 3
  1. #1

    weird mysql remote connection problem

    I have VPS and more sites.

    I want to connect to MySQL from a remote host for 2 sites.

    I have added ip to CPanel -> MySQL -> IP access and I manage to
    connect but it only works for a site.

    I have checked user/password and it's ok.
    While connecting from MySQL console, it works for both,
    but when connecting from web/php/mysql it is not working.

    Has anybody encountered this issue? I have no idea what problem
    could be, since practically the both sites are similar, on the same
    VSP .
    Promovare Online - I do AdWords with API

  2. #2
    If it works connecting remotely from console, I would check the config file for the web apps you are running that hit the DB.

    EDITED: misread original question.
    Slicehost - Xen VPS hosting
    Community - Forums, wiki, chat and technical articles

  3. #3
    I found problem: mysql server was set to use new passwords and my client
    was using different authentication protocol.

    problem was that no error was displaying, it simply did not connect.
    here is a link that shows solution:
    Promovare Online - I do AdWords with API

Posting Permissions

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