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