Results 1 to 9 of 9

Thread: Konektovanje na MySQL na drugom serveru?

  1. #1
    Join Date
    Jan 2004
    Posts
    1,549
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default Konektovanje na MySQL na drugom serveru?

    Da li mogu da podesim skriptu koja je na jednom server da se konektuje na MySQL bazu na drugom serveru, user i pass naravno imam.

    Ja sam krenuo ovako:

    $veza = @mysql_connect("http://www.xxx.com","xxx","xxx");

    $sql = "SELECT * FROM tabela ";
    $pitanje = mysql_db_query("baza",$sql,$veza);

    ... i skripta se konektuje ali izgleda da ne izvlachi podatke sa te baze. Evo errora.

    "Warning: mysql_db_query(): supplied argument is not a valid MySQL-Link resource in /home/virtual/sitexxx/fst/var/www/html/spr/index.php on line 16"

    Skripta je ok, osim shto mozda treba josh neshto dodati kad radish ovaj remote connection baze. Da li treba nedje da dodam komandu "select_db" iako mi ovako na local radi bez problema?

    Mislim ovo je specificna situacija jer chojek nije znao da u paketu nema mysql bazu pa sad moram sa drugog sajta da koristim bazu.
    It's not who we are and where are we, it's about in what we believe and what we choose...

  2. #2
    Join Date
    Jan 2004
    Location
    Herceg Novi
    Posts
    3,365
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Stoji pitanje da li ti imaš pravo da se remote konektuješ na taj MySQL Server. Kod Internet CG-a recimo, jedino u lokalu možeš da se povezuješ na MySQL server.

  3. #3
    Join Date
    Jan 2004
    Posts
    1,549
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    ja sam se konektovao na taj server ali kad krenem da vuchem podatke, greshka. Skripta koja se konektuje je na ICG server a baza je na serveru u Frankfurt. :P
    It's not who we are and where are we, it's about in what we believe and what we choose...

  4. #4
    Join Date
    Jan 2004
    Location
    Podgorica
    Posts
    2,671
    Thanks Thanks Given 
    2
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    mozes li se preko SSH povezati na taj sever? Ako mozes onda tako otvori mysql i vidi kakav pristup imas.

  5. #5
    Join Date
    Jan 2004
    Posts
    1,549
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Mogu preko phpmyadmina da logujem, ali neznam za taj ssh, ima li to na win il moram da palim linux? Da li se ssh bash tako zove na Mandrake linux 9.1?
    It's not who we are and where are we, it's about in what we believe and what we choose...

  6. #6
    Join Date
    Jan 2004
    Location
    Podgorica
    Posts
    2,671
    Thanks Thanks Given 
    2
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Quote Originally Posted by eskim
    Mogu preko phpmyadmina da logujem, ali neznam za taj ssh, ima li to na win il moram da palim linux? Da li se ssh bash tako zove na Mandrake linux 9.1?
    evo ovako ja bi ti provo preporucio da odes na www.mysql.com i malo pogledas njihovu dokumentaciju i uputis se kako mysql radi. Pogledaj malo u permission tabele i slicne stvari sto imaju u dokumentaciji.

    sto se ssh tice, trebao da mozes uraditi samo:

    Code:
    ssh [email protected]
    i to bi ti bilo to onda se tamo bakci po njihovom systemu ukucaj:

    Code:
    mysql
    da dobijes mysql prompt i tako te stvari.

  7. #7
    Join Date
    Jan 2004
    Posts
    1,549
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    Znam kako funkcionishu privilegije kod mysql nisam znao kako da im pristupim tj preko ssh, hvala.
    It's not who we are and where are we, it's about in what we believe and what we choose...

  8. #8
    Join Date
    Apr 2004
    Location
    Podgorica
    Posts
    603
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default Re: Konektovanje na MySQL na drugom serveru?

    Quote Originally Posted by eskim
    Ja sam krenuo ovako:

    $veza = @mysql_connect("http://www.xxx.com","xxx","xxx");

    $sql = "SELECT * FROM tabela ";
    $pitanje = mysql_db_query("baza",$sql,$veza);
    Mozda ja negdje grijeshim, ali zar ne bi trebalo sve to da glasi ovako:
    Code:
    $veza = mysql_connect("http://www.xxx.com","xxx","xxx");
    mysql_select_db("baza", $veza);
    $sql = "SELECT * FROM tabela  ";
    $pitanje = mysql_query($sql,$veza);
    Ili ipak grijeshim?

  9. #9
    Join Date
    Jan 2004
    Posts
    1,549
    Thanks Thanks Given 
    0
    Thanks Thanks Received 
    0
    Thanked in
    0 Posts

    Default

    meni radi bez select_db kad je skripta na localhostu ali izgleda da kad se radi remote konekcija treba select_db.
    Nisam imao vremena da testiram pa sam rijeshio sa iFrame-om.
    It's not who we are and where are we, it's about in what we believe and what we choose...

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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
  •