windows连接linux的mysql怎么联？

ap

如题？大哥，大姐帮帮忙！

yttlovezxx

mysql服务器是linux吗？。

webstroller

应该是啵，“连接linux的mysql”

bachelor2000

mysql administrator

2000king

你是要怎么连阿，说得不清楚，用mysql客户端还是自己写程序？

okchina

ODBC,JDBC都可以试试

xxjoyjn

原帖由 okchina 于 2006-5-28 09:36 发表
ODBC,JDBC都可以试试

异地连接吗?

okchina

对!

xxjoyjn

原帖由 okchina 于 2006-5-29 09:13 发表
对!

如果是用程序连接：
1 在目标数据库里设置账户和密码：username,password
2 如果是用JAVA程序连接，这样写
url="jdbc:mysql://目的主机IP:3306/dbanme?useUnicode=ture&characterEncoding=gbk"
DriverManager.getConnection(url,username,password);
如果是通过客户端软件连接就在客户端界面工具里设置就OK了

[ 本帖最后由 xxjoyjn 于 2006-5-29 10:12 编辑 ]

sunable

我也遇到了这个问题。
我在windows下的PHP服务器放置php文件用于连接另一台FreeBSD下的MySQL数据库。但是提示如下：

1. 
   
2. Could not connect: Can't connect to MySQL server on 'mail.kinca.cn' (10061)
   

复制代码

这个错误是由于我在my.cnf中增加了bind_address=127.0.0.1的字段引起的，但是我注释掉这个字段后，依旧出现其他的错误

1. 
   
2. Could not connect: Host '220.191.161.67' is not allowed to connect to this MySQL server
   
3. 其中220.191.161.67是windows机器的IP．
   

复制代码

请问我要修改什么属性，才能成功连接FreeBSD下的MySQL数据库？

1. 
   
2. 
   
3. 连接代码：
   
4. $link = mysql_connect('mail.kinca.cn', 'xxx', 'yyyyyyyyy')
   
5.     or die('Could not connect: ' . mysql_error());
   

复制代码

1. 
   
2. #my.cnf
   
3. # Example MySQL config file for small systems.
   
4. #
   
5. # This is for a system with little memory (<= 64M) where MySQL is only used
   
6. # from time to time and it's important that the mysqld daemon
   
7. # doesn't use much resources.
   
8. #
   
9. # You can copy this file to
   
10. # /etc/my.cnf to set global options,
    
11. # mysql-data-dir/my.cnf to set server-specific options (in this
    
12. # installation this directory is /var/db/mysql) or
    
13. # ~/.my.cnf to set user-specific options.
    
14. #
    
15. # In this file, you can use all long options that a program supports.
    
16. # If you want to know which options a program supports, run the program
    
17. # with the "--help" option.
    
18. 
    
19. # The following options will be passed to all MySQL clients
    
20. [client]
    
21. #password        = your_password
    
22. port                = 3306
    
23. socket                = /tmp/mysql.sock
    
24. 
    
25. # Here follows entries for some specific programs
    
26. 
    
27. # The MySQL server
    
28. [mysqld]
    
29. port                = 3306
    
30. socket                = /tmp/mysql.sock
    
31. skip-locking
    
32. key_buffer = 16K
    
33. max_allowed_packet = 1M
    
34. table_cache = 4
    
35. sort_buffer_size = 64K
    
36. read_buffer_size = 256K
    
37. read_rnd_buffer_size = 256K
    
38. net_buffer_length = 2K
    
39. thread_stack = 64K
    
40. bind_address=127.0.0.1
    
41. log=/var/log/sql.log
    
42. 
    
43. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
    
44. # if all processes that need to connect to mysqld run on the same host.
    
45. # All interaction with mysqld must be made via Unix sockets or named pipes.
    
46. # Note that using this option without enabling named pipes on Windows
    
47. # (using the "enable-named-pipe" option) will render mysqld useless!
    
48. #
    
49. #skip-networking
    
50. server-id        = 1
    
51. 
    
52. # Uncomment the following if you want to log updates
    
53. #log-bin=mysql-bin
    
54. 
    
55. # Uncomment the following if you are NOT using BDB tables
    
56. #skip-bdb
    
57. 
    
58. # Uncomment the following if you are using InnoDB tables
    
59. #innodb_data_home_dir = /var/db/mysql/
    
60. #innodb_data_file_path = ibdata1:10M:autoextend
    
61. #innodb_log_group_home_dir = /var/db/mysql/
    
62. #innodb_log_arch_dir = /var/db/mysql/
    
63. # You can set .._buffer_pool_size up to 50 - 80 %
    
64. # of RAM but beware of setting memory usage too high
    
65. #innodb_buffer_pool_size = 16M
    
66. #innodb_additional_mem_pool_size = 2M
    
67. # Set .._log_file_size to 25 % of buffer pool size
    
68. #innodb_log_file_size = 5M
    
69. #innodb_log_buffer_size = 8M
    
70. #innodb_flush_log_at_trx_commit = 1
    
71. #innodb_lock_wait_timeout = 50
    
72. 
    
73. [mysqldump]
    
74. quick
    
75. max_allowed_packet = 16M
    
76. 
    
77. [mysql]
    
78. no-auto-rehash
    
79. # Remove the next comment character if you are not familiar with SQL
    
80. #safe-updates
    
81. 
    
82. [isamchk]
    
83. key_buffer = 8M
    
84. sort_buffer_size = 8M
    
85. 
    
86. [myisamchk]
    
87. key_buffer = 8M
    
88. sort_buffer_size = 8M
    
89. 
    
90. [mysqlhotcopy]
    
91. interactive-timeout
    
92. 
    
93. [maxconnections]
    
94. max_connections=1024
    
95. 
    

复制代码

已经解决：进入MYSQL的用户表，为要使用的用户添加权限。
grant all privileges on *.* to root@"%";
flush privileges;

[ 本帖最后由 sunable 于 2006-6-28 11:28 编辑 ]