I am running MYSQL 3.23.36 on windows NT. I am not
able to connect to the server through a ‘C’ program
using mysql_real_connect() from another computer. The
other computer is running on Windows 98. My
permissions are alright and I am able to connect to
the server interactively through the command line
program ‘mysql’.
Interestingly, the ‘C’ program works alright when I
run it on the WINDOWS NT computer itself (i.e., the
computer on which the server is running) using NULL or
“localhost” as the hostname.
Relevant Portion of My ‘C’ program is reproduced
below:
////////////////////////////////////////////////
void print_error(MYSQL *conn, char *message)
{
char string[500];
char string1[250];
wsprintf(string, "%s\n", message);
if (conn != NULL)
{
wsprintf(string1, "Error %u (%s)\n",
mysql_errno(conn), mysql_error(conn));
strcat(string, string1);
}
MessageBox(NULL, string, NULL, MB_OK | MB_ICONERROR);
}
////////////////////////////////////////////////
MYSQL *do_connect()
{
MYSQL *conn;
conn = mysql_init(NULL);
if (conn == NULL)
{
print_error(NULL, "MySql could not be initialized");
return NULL;
}
if (mysql_real_connect(conn, "191.254.20.103", "JKA",
"jka", "ABT", 0, NULL, 0) == NULL)
{
print_error(conn, "Could not connect to server");
return NULL;
}
/*if (mysql_real_connect(conn, NULL, "JKA", "jka", 0,
NULL, 0) == NULL)
{
print_error(conn, "Could not connect to server");
return NULL;
}
if (mysql_select_db(conn, "ABT") != 0)
{
print_error(conn, "ABT database could not be
selected");
mysql_close(conn);
return NULL;
}*/
return (conn);
}
I always get the following error message:
Error 1044 (Access denied to user:
‘[EMAIL PROTECTED]’ to database ‘ABT’)
I have given Select, Insert, and delete grants to
[EMAIL PROTECTED] on all tables of the database ABT.
Kindly help.
____________________________________________________________
Do You Yahoo!?
Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk
or your free @yahoo.ie address at http://mail.yahoo.ie
---------------------------------------------------------------------
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
