搭建了一个CENTOS7 +xammp的环境,可以直接用phpmyadmin完成数据库访问和改写,直接启动MYSQL也没有问题进行数据库访问。
#include <stdlib.h>
#include <stdio.h>
#include "mysql.h"
MYSQL *conn_ptr;int main(void){
conn_ptr = mysql_init(NULL);
if (!conn_ptr)
{
fprintf(stderr,"mysql_init failed!\n");
return (-1);
}
conn_ptr = mysql_real_connect(conn_ptr,"localhost","root","123456","mysql",3306,0,NULL);
if (conn_ptr)
{
printf ("connection succeed!\n");
}
else{
printf ("connection failed!\n");
return (-2);
}
mysql_close(conn_ptr);
printf ("connection close!\n");
return 0;}gcc -o mydbcon -I /opt/lammp/include -L /opt/lammp/lib/mysql -lmysqlclient mysql.c
连接数据库始终失败,是什么原因呢?是不是还要按照和配置什么呢?
#include <stdlib.h>
#include <stdio.h>
#include "mysql.h"
MYSQL *conn_ptr;int main(void){
conn_ptr = mysql_init(NULL);
if (!conn_ptr)
{
fprintf(stderr,"mysql_init failed!\n");
return (-1);
}
conn_ptr = mysql_real_connect(conn_ptr,"localhost","root","123456","mysql",3306,0,NULL);
if (conn_ptr)
{
printf ("connection succeed!\n");
}
else{
printf ("connection failed!\n");
return (-2);
}
mysql_close(conn_ptr);
printf ("connection close!\n");
return 0;}gcc -o mydbcon -I /opt/lammp/include -L /opt/lammp/lib/mysql -lmysqlclient mysql.c
连接数据库始终失败,是什么原因呢?是不是还要按照和配置什么呢?
打印下,看出什么错误,然后分析分析