Hello everyone.

I already know the C code required to use SQL statements within C++. Using mysql_real_connect, I was able to establish a connection to a remote MySQL server. The problem is, even though mysql_real_connect did not RETURN NULL, (meaning that a connection to the mysql server was established) I am unable to create databases, OR new tables using the MySQL handle obtained (via the mysql_real_connect function).

int errorcheck;
errorcheck = mysql_real_connect(conn, "myipaddress", "myusername", "mypassword", NULL, 0, NULL, 0);
if (errorcheck != NULL)
{MessageBox(hWnd, "Connection to server successful!", "Connection Status", MB_OK};

-Is it possible for mysql_real_connect to not be null, but still be unsuccessful?
-What are the exact return values for: mysql_query, mysql_select_db, and mysql_real_connect?

-I have already ensured that "remote" access to the mySQL database was permitted.
-I already know that mysql_real_connect returns NULL if a connection was not established to the MySQL server. However, I do not know if any other return values can be returned other than NULL or success.

Edited by PixelExchange: n/a

8 Years
Discussion Span
Last Post by PixelExchange

may be this bellow code snippet help you to print out what is the error goes on

MYSQL mysql;

if (!mysql_real_connect(&mysql,"host","user","passwd","database",0,NULL,0))
    fprintf(stderr, "Failed to connect to database: Error: %s\n",

please note I caught that code from there.http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html where the MySql API documentation for C language interface.


Thank you for your reply. I've found the problem.. Rather simple really.. I was using the wrong mysql connector as the first arguement. I created two MYSQL variables. One was initiated, and the other was not. I used the one that was not initiated inside of my sql statements.

Also, I was aware of that site, as well as the code required to display the conflicting error.. but that was not sufficient information to figure out why I could not create any tables on a valid connection.

Edited by PixelExchange: n/a

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.