Plesk Allowing Incoming mySQL database information

Discussion in 'Site & Server Administration' started by nkiegrea, Jul 16, 2007.

  1. #1
    Ugh.. my frustration keeps building with Plesk!

    Need some help!!!!

    I have a dedicated Plesk Linux server... and I just bought a cPanel Linux dedicated server.

    I want to have the Database be on the cPanel server and all the rest on the Plesk server.

    So I set up a test database on the new cPanel and run my script on a shared hosting account where I test things. It works and everything is golden.

    So I put the same configuration onto my Plesk and what do you know?? Doesn't work. I went in and changed some firewall settings on the Plesk dedicated to allow 3306 from the IP address of the cPanel server.. Outgoing and Inbound... Still doesn't work.

    I put the IP address for the Plesk dedicated into the Allowed hosts for the cPanel already, so I know its not that.

    Basically.. I have it configured to work on my shared hosting acount that runs on cPanel, so I know its not the configuration of the script or the dedicated server with the cPanel on it.

    Any help would be AMAZING. Rep plus some cash. Give me a quote.

    Thanks
    Zack B
     
    nkiegrea, Jul 16, 2007 IP
  2. powerspike

    powerspike Peon

    Messages:
    312
    Likes Received:
    10
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Have you checked the access mask in MYSQL itself ?

    it might be localhost, or the remote ip address, you should realy have one for each machine you connect from (best to be safer), the tables you'd need to check are in the mysql database, "user" and "db", if it has "%" host field, it means allow from all.

    also check your my.cnf file on the server, and see if it has "skip-networking" in the file, if it does, remove it.
     
    powerspike, Jul 16, 2007 IP
    nkiegrea likes this.
  3. nkiegrea

    nkiegrea Peon

    Messages:
    355
    Likes Received:
    43
    Best Answers:
    0
    Trophy Points:
    0
    #3
    ok, I will check those things.. Thanks for the help. Anyone else have any ideas?
     
    nkiegrea, Jul 16, 2007 IP