The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Connecting to MySQL on seperate server

Discussion in 'General Discussion' started by namehog, Aug 8, 2003.

  1. namehog

    namehog Active Member

    Joined:
    Aug 7, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Northampton UK
    Hi,

    Ill explain my set up so you can get it in one.

    I have two seperate servers, one for databases to go on, this is purely a dedicated MySQL server,

    and the other server being a web server and running CPanel on it.

    I am having trouble connecting CPanel to the database server, its got to be a permissions problem i think.

    At the moment, i can connect to a mysql database on the database server from the webserver using a normal script for example, i am using ModernBill, so that all works ok.

    I cant however get CPanel to connect, in the "Setup Remote MySQL server" i have put the correct IP address in and also the Root server Password, and it says now using that server, but if i then try and see what processes are running or doing any MySQL stuff it comes back with the following error.

    /usr/bin/mysqladmin: connect to server at '217.199.xxx.xxx' failed error: 'Access denied for user: 'root@ns.MYWEBSERVER.com' (Using password: YES)'

    Does anyone have any pointers as to what is wrong?

    I am completely puzzeled by this and need a little help!

    cPanel.net Support Ticket Number:
     
  2. namehog

    namehog Active Member

    Joined:
    Aug 7, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Northampton UK
    has anyone got a clue about this?

    cPanel.net Support Ticket Number:
     
  3. namehog

    namehog Active Member

    Joined:
    Aug 7, 2003
    Messages:
    32
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Northampton UK
    Hi,

    thanks very much for the reply,

    you say change the

    [client]
    server=IPHERE
    pass=PASSHERE
    user=root

    Which IP do you put in? the Ip of the Database server?

    the password, is that the Root password for the mysql, or the server?

    cPanel.net Support Ticket Number:
     
  4. torwill

    torwill Well-Known Member

    Joined:
    Jun 25, 2002
    Messages:
    141
    Likes Received:
    0
    Trophy Points:
    16
    I am trying to setup 2 servers to share 1 dedicated mysql server, and having problem configuring eximstats and horde databases. Could you please share how you did this? Thank you.




     
  5. richenou

    richenou Well-Known Member
    PartnerNOC

    Joined:
    Feb 17, 2004
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    Hi,
    I want to test the conection mysql from serverr1 via ssh or
    http? what is the comamand line to type?


    ex: http://serveur2.com:3306

    how to display the tables?
     
  6. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    When connecting to MySQL from a remote server, you must have access privileges setup on the remote MySQL server to connect to MySQL. So if your connecting from Server1 to Server2 you must have access configured to connect TO MySQL2 FORM MySQL1

    Mickalo
     
  7. richenou

    richenou Well-Known Member
    PartnerNOC

    Joined:
    Feb 17, 2004
    Messages:
    86
    Likes Received:
    0
    Trophy Points:
    6
    I got an error when I run :
    root@serveur17 [~]# mysqladmin processlist
    mysqladmin: ERROR: unknown variable 'server=67.19.107.144'
     
  8. mickalo

    mickalo Well-Known Member

    Joined:
    Apr 16, 2002
    Messages:
    765
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    N.W. Iowa
    if this is from an error in the your my.conf file it should be host=67.19.107.144 not server=67.19.107.144.

    Mickalo
     
Loading...

Share This Page