关于mysql_real_connect(mysql,"192.168.1.68"

Question

这是我的代码：

1. #include <mysql.h>;
3.   #include <stdio.h>;
5. int main(){
7.    MYSQL mysql; // need a instance to init
9.    MYSQL_RES *res;
11.    MYSQL_ROW row;
13.    char *query;
15.    int t,r;
17. // connect the database
19.    mysql_init(&mysql);
21.    if (!mysql_real_connect(&mysql,"192.168.1.68", "root", "mm128133", "chen",0,NULL,0))
23.    {
25.        printf( "Error connecting to database: %s\n",mysql_error(&mysql));
27.    }
29.    else printf("Connected...\n");
33. // get the result from the executing select query
35. query = "select * from chen_table";
37.    
39. t = mysql_real_query(&mysql,query,(unsigned int) strlen(query));
41. if (t)
43. {
45.     printf("Error making query: %s\n",
47.       mysql_error(&mysql));
49. }
51. else printf("[%s] made...\n", query);
53. res = mysql_store_result(&mysql);
55. while(row = mysql_fetch_row(res))
57. {
59.   for(t=0;t<mysql_num_fields(res);t++)
61.   {
63.    printf("%s ",row[t]);
65.   }
67.   printf("\n");
69. }
73. printf("mysql_free_result...\n");
75. mysql_free_result(res);     //free result after you get the result
79. sleep(1);   
83. // execute the insert query
85. query = "insert into chen_table(id, name) values(3, 'kunp')";
87. t = mysql_real_query(&mysql,query,(unsigned int) strlen(query));
89. if (t)
91. {
93.     printf("Error making query: %s\n",
95.       mysql_error(&mysql));
97. }
99. else printf("[%s] made...\n", query);
101.    
103.     mysql_close(&mysql);
105.    
107.    return 0;
109. }
110. 用gcc编译也成功了，
111. gcc -o text mysqltest.c -I/usr/include/mysql -L/usr/include/mysql -L/usr/lib/mysql -lmysqlclient -lz
112. mysql_real_connect(&mysql,"192.168.1.68", "root", "mm128133", "chen",0,NULL,0))
113. 其中192.168.1.68是我的内网的IP地址，如果改成localhost,就可以连到数据库中，但是用这个IP的话就会出现这样的问题：
114. Error connecting to database: Access denied for user: 'root@vicp.net' (Using password: YES)
115. 不知道哪位大侠能帮帮小弟阿，好急阿。

复制代码