UC知道一个linux下c连接mysql的的问题
来源：百度知道 编辑：UC知道 时间：2024/09/23 08:39:30
msyql_real_connect()放在main函数下执行没什么问题，将它放在自己定义的函数下，mian函数调用该函数执行就出现了问题。错误代码是：Can't create UNIX socket (24)。请各位朋友帮忙看看。
#include "/usr/mysql/include/mysql.h"
#include<stdio.h>
#include<stdlib.h>
int main(){
MYSQL mysql,*ptr;
char sql[5000];
FILE *p;
mysql_init(&mysql);
if((ptr=mysql_real_connect(&mysql,"localhost","psx","psx","psx",0,NULL,0))!=0)
printf("connected..\n");
else{
printf("Error connecting to database: %s\n" ,mysql_error(&mysql));
exit(1);
}
if((p=fopen("show.sql","r"))==NULL){
printf("can not open.\n");
exit(1);
}
else
fread(sql,2000,1,p);
if(!mysql_query(ptr,"show tables")){
printf("ok&#
#include "/usr/mysql/include/mysql.h"
#include<stdio.h>
#include<stdlib.h>
int main(){
MYSQL mysql,*ptr;
char sql[5000];
FILE *p;
mysql_init(&mysql);
if((ptr=mysql_real_connect(&mysql,"localhost","psx","psx","psx",0,NULL,0))!=0)
printf("connected..\n");
else{
printf("Error connecting to database: %s\n" ,mysql_error(&mysql));
exit(1);
}
if((p=fopen("show.sql","r"))==NULL){
printf("can not open.\n");
exit(1);
}
else
fread(sql,2000,1,p);
if(!mysql_query(ptr,"show tables")){
printf("ok&#
按理说放在函数里也一样，你connect()没有参数？那你函数里有下面的语句没？只要把在main函数里的句子全放在connect()函数里就么有问题了
MYSQL mysql,*ptr;
mysql_init(&mysql);