dblinks equilent function in Mysql

[ashalalaxmi2002]

hi

how can access romote Mysql database from local mysql database.
like oracle dblinks will also work in mysql.

[mwasif]

I believe MySQL does not support dblink.

[mwasif]

This post on MySQL Forum might help you.

[bhanu1225]

We can't go with dblink.
But, with db connection through IP address, we can connect it.

cxn = MySQLdb.connect(host='192.168.1.13',user='root',passwd='',db='navicat')

its the process.

[ririe]

does mysql and mysqli both can use dblink??

[bhanu1225]

here, both are similar in connection statement.
example...

if ($GLOBALS["db_persistent"]) {
  $c = @mysqli_connect ( $host, $login, $password, $database);
} else {
  $c = @mysqli_connect ( $host, $login, $password, $database);
}

in php.

example....

cxn = MySQLdb.connect(host='192.168.1.13',user='root',passwd='',db='navicat')

in python