hi
how can access romote Mysql database from local mysql database.
like oracle dblinks will also work in mysql.
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.
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
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.