mysql 创建数据链路_创建oracle访问mysql的数据链路步骤

(1)登陆到mysql

C:\Documents and Settings\Administrator>mysql -h localhost -u root -p

Enter password: *****

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 69

Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

(2)创建数据库

mysql> create database oracle;

Query OK, 1 row affected (0.00 sec)

(3)创建被访问的mysql用户

mysql> grant all privileges on oracle.* to 'orauser'@'%' identified by 'orauser'

with grant option;

Query OK, 0 rows affected (0.00 sec)

mysql> exit

Bye

(4)登陆该用户，并测试

C:\Documents and Settings\Administrator>mysql -h localhost -u orauser -p

Enter password: *******

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 70

Server version: 5.0.51a-community-nt MySQL Community Edition (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use oracle;

Database changed

mysql> create table test(tid integer,tname varchar(20));

Query OK, 0 rows affected (0.06 sec)

mysql> insert into test(tid,tname)values(1,'byf');

Query OK, 1 row affected (0.03 sec)

mysql> insert into test(tid,tname)values(2,'others');

Query OK, 1 row affected (0.02 sec)

mysql> select * from test;

+------+--------+

| tid | tname |

+------+--------+

|    1 | byf    |

|    2 | others |

+------+--------+

2 rows in set (0.00 sec)

mysql>

(5)安装mysql odbc driver 3.51并设置odbc数据源

data source name:mysqlora

server:localhost

user: orauser

password:orauser

database:oracle

(6)配置初始化参数%ORACLE_HOME%/admin/initmysqlora.ora

HS_FDS_CONNECT_INFO =mysqlora

HS_FDS_TRACE_LEVEL = on

(7)配置%ORACLE_HOME%/newtwork/admin/tnsname.ora

mysqlora=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

&nb