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
