database,sql,query,table,mysql
The error message is :
Connection failed
Connection error 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
my program is :
#include <stdlib.h>
#include <stdio.h>
#include "mysql.h"
int main(int argc, char *argv[]) {
MYSQL my_connection;
int res;
mysql_init(&my_connection);
if (mysql_real_connect(&my_connection, "localhost","monty", "something", "nvod", 0,
NULL, 0)) {
printf("Connection success\n");
res = mysql_query(&my_connection, "insert into task_log(task_id,content)
values(111,'c programing')");
if (!res) {
printf("Inserted %lu rows\n", (unsigned long)mysql_affected_rows(&my_connection));
} else {
fprintf(stderr, "Insert error %d:
s\n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
mysql_close(&my_connection);
} else {
fprintf(stderr, "Connection failed\n");
if (mysql_errno(&my_connection)) {
fprintf(stderr, "Connection error %d:
%s\n",mysql_errno(&my_connection),mysql_error(&my_connection));
}
}
return EXIT_SUCCESS;
}
my machine is :
red hat 6.0
mysql 3.23.32
I can use "mysql -u monty -psomething" to login .
under dirctory of /var/lib/mysql/
srwxrwxrwx 1 mysql mysql 0 Jun 23 19:51 mysql.sock
under dirctory of /tmp
-rwxrwxrwx 1 wz wz 0 Jun 25 09:39 mysql.sock
Are these message is correct?
how to fix it? Have somebody know?
Thanks.
eagle
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
