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.

Using other MySQL databases from other accounts...

Discussion in 'General Discussion' started by $D$2, Jan 29, 2005.

  1. $D$2

    $D$2 Member

    Joined:
    Sep 24, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I have a web host using cPanel but I am limited to 1 MySQL database :( . Since I am already using the database I need another.

    However, I have another host that provides unlimited databases but I can't use it because I am running out of space :( .

    Anyway, is it possible to use my MySQL database from my "unlimited acount" to use on my "1" account?

    Sorry if this is hard to understand. :confused:

    Thank you :)
     
  2. jester.ro

    jester.ro Well-Known Member
    PartnerNOC

    Joined:
    Feb 6, 2004
    Messages:
    304
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Bucharest, Romania
    cPanel Access Level:
    DataCenter Provider
    yes you can do that.

    connect from the host with 1 mysql database to the other one.

    just change the conenct script in your files
    (fro php, check mysql_connect syntax - you need to specify the host - so instead of:

    mysql_connect("localhost","user",password");, you'd have

    mysql_connect("name.of.the.other.host","user,"pass);

    of course, if it doesn't work, ask the webhoster where you have more databases if outside access to port 3306 (default mysql port) is open.
     
  3. $D$2

    $D$2 Member

    Joined:
    Sep 24, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    How do you edit these files? Do you use phpMyAdmin? :confused:
     
  4. markhard

    markhard Well-Known Member

    Joined:
    Apr 22, 2004
    Messages:
    250
    Likes Received:
    0
    Trophy Points:
    16
    on your PHP or PERL script configuration file.
     
  5. $D$2

    $D$2 Member

    Joined:
    Sep 24, 2004
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Oh right... thanks guys! :D
     
  6. dezignguy

    dezignguy Well-Known Member

    Joined:
    Sep 26, 2004
    Messages:
    534
    Likes Received:
    0
    Trophy Points:
    16
    ehh? You can put many more tables into your 1 database... so you can use it for multiple script installs. Just make sure the table names don't conflict if you're loading an sql file.
     
Loading...

Share This Page