运行环境: redhat: 4
gcc: 3.4
mysql: 5.1#include <stdio.h>
#include "/usr/include/mysql/mysql.h"MYSQL_RES* res_ptr;
MYSQL_ROW sqlrow;
unsigned int num_rows = 0;
char ch_sql[200];
MYSQL my_conn;
int main(){
mysql_init(&my_conn); if (!mysql_real_connect(&my_conn, "localhost", "root", "123456","test",0,NULL,CLIENT_FOUND_ROWS)) {
printf( "ERROR: connect database error\n" );
return 0;
}
printf( "Successful!\n\n" );
return 0;
}编译:gcc sqltest.c $(mysql_config --cflags) $(mysql_config --libs) -o sqltest
运行:./sqltest错误:can't connect to localmysql server through socket '/tmp/mysql.sock'另: 1./tmp/mysql.sock确实存在,而且mysql运行正常
2.同一用户下,通过命令行:mysql -u root -p123456; 可以正常进入
3.在本地机器Ubuntu下,编译运行正常;唯一不同的就是gcc版本急!请高手指教!
gcc: 3.4
mysql: 5.1#include <stdio.h>
#include "/usr/include/mysql/mysql.h"MYSQL_RES* res_ptr;
MYSQL_ROW sqlrow;
unsigned int num_rows = 0;
char ch_sql[200];
MYSQL my_conn;
int main(){
mysql_init(&my_conn); if (!mysql_real_connect(&my_conn, "localhost", "root", "123456","test",0,NULL,CLIENT_FOUND_ROWS)) {
printf( "ERROR: connect database error\n" );
return 0;
}
printf( "Successful!\n\n" );
return 0;
}编译:gcc sqltest.c $(mysql_config --cflags) $(mysql_config --libs) -o sqltest
运行:./sqltest错误:can't connect to localmysql server through socket '/tmp/mysql.sock'另: 1./tmp/mysql.sock确实存在,而且mysql运行正常
2.同一用户下,通过命令行:mysql -u root -p123456; 可以正常进入
3.在本地机器Ubuntu下,编译运行正常;唯一不同的就是gcc版本急!请高手指教!
解决方案 »
- Hibernate+Oracle转Hibernate+MySql
- 请问mysql怎么关闭查询缓存
- 数据库连接问题
- mysql 合并两张表的数据-视图
- mysql5.0与4.0在windows下连接有何不同?
- 请问MM.MySQL和MySQL-Connector的区别?
- Mysql服务启动不起来,何解(很急很急)
- 从mysql导出数据库.sql文件时,报1146 - Table ‘mysql.event’ doesn`t exist 错误
- 做一个打包程序去安装MYSQL,并且做想配置,建表操作,大家有思路吗
- MySQL Migration Toolkit出问题
- mysql数据库备份成功,再还原却失败,什么原因?
- 2个mysql问题请教
ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock 试试
程序连接Mysql 时,通过 /var/lib/mysql/mysql.sock 因为/var/lib/mysql/mysql.sock无效,导致了程序连接失败! ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock