hi

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

I believe MySQL does not support dblink.

This post on MySQL Forum might help you.

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.

does mysql and mysqli both can use dblink??

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.