- 24.2.3 C API Function Descriptions
- 24.2.3.1 mysql_affected_rows()
- 24.2.3.2 mysql_autocommit()
- 24.2.3.3 mysql_change_user()
- 24.2.3.4 mysql_character_set_name()
- 24.2.3.5 mysql_close()
- 24.2.3.6 mysql_commit()
- 24.2.3.7 mysql_connect()
- 24.2.3.8 mysql_create_db()
- 24.2.3.9 mysql_data_seek()
- 24.2.3.10 mysql_debug()
- 24.2.3.11 mysql_drop_db()
- 24.2.3.12 mysql_dump_debug_info()
- 24.2.3.13 mysql_eof()
- 24.2.3.14 mysql_errno()
- 24.2.3.15 mysql_error()
- 24.2.3.16 mysql_escape_string()
- 24.2.3.17 mysql_fetch_field()
- 24.2.3.18 mysql_fetch_field_direct()
- 24.2.3.19 mysql_fetch_fields()
- 24.2.3.20 mysql_fetch_lengths()
- 24.2.3.21 mysql_fetch_row()
- 24.2.3.22 mysql_field_count()
- 24.2.3.23 mysql_field_seek()
- 24.2.3.24 mysql_field_tell()
- 24.2.3.25 mysql_free_result()
- 24.2.3.26 mysql_get_character_set_info()
- 24.2.3.27 mysql_get_client_info()
- 24.2.3.28 mysql_get_client_version()
- 24.2.3.29 mysql_get_host_info()
- 24.2.3.30 mysql_get_proto_info()
- 24.2.3.31 mysql_get_server_info()
- 24.2.3.32 mysql_get_server_version()
- 24.2.3.33 mysql_get_ssl_cipher()
- 24.2.3.34 mysql_hex_string()
- 24.2.3.35 mysql_info()
- 24.2.3.36 mysql_init()
- 24.2.3.37 mysql_insert_id()
- 24.2.3.38 mysql_kill()
- 24.2.3.39 mysql_library_end()
- 24.2.3.40 mysql_library_init()
- 24.2.3.41 mysql_list_dbs()
- 24.2.3.42 mysql_list_fields()
- 24.2.3.43 mysql_list_processes()
- 24.2.3.44 mysql_list_tables()
- 24.2.3.45 mysql_more_results()
- 24.2.3.46 mysql_next_result()
- 24.2.3.47 mysql_num_fields()
- 24.2.3.48 mysql_num_rows()
- 24.2.3.49 mysql_options()
- 24.2.3.50 mysql_ping()
- 24.2.3.51 mysql_query()
- 24.2.3.52 mysql_real_connect()
- 24.2.3.53 mysql_real_escape_string()
- 24.2.3.54 mysql_real_query()
- 24.2.3.55 mysql_refresh()
- 24.2.3.56 mysql_reload()
- 24.2.3.57 mysql_rollback()
- 24.2.3.58 mysql_row_seek()
- 24.2.3.59 mysql_row_tell()
- 24.2.3.60 mysql_select_db()
- 24.2.3.61 mysql_set_character_set()
- 24.2.3.62 mysql_set_local_infile_default()
- 24.2.3.63 mysql_set_local_infile_handler()
- 24.2.3.64 mysql_set_server_option()
- 24.2.3.65 mysql_shutdown()
- 24.2.3.66 mysql_sqlstate()
- 24.2.3.67 mysql_ssl_set()
- 24.2.3.68 mysql_stat()
- 24.2.3.69 mysql_store_result()
- 24.2.3.70 mysql_thread_id()
- 24.2.3.71 mysql_use_result()
- 24.2.3.72 mysql_warning_count()
MYSQL *mysql_connect(MYSQL *mysql, const char *host,
const char *user, const char *passwd)
Description
This function is deprecated. It is preferable to use
mysql_real_connect() instead.
mysql_connect() attempts to establish a
connection to a MySQL database engine running on
host. mysql_connect() must
complete successfully before you can execute any of the other
API functions, with the exception of
mysql_get_client_info().
The meanings of the parameters are the same as for the
corresponding parameters for
mysql_real_connect() with the difference that
the connection parameter may be NULL. In this
case, the C API allocates memory for the connection structure
automatically and frees it when you call
mysql_close(). The disadvantage of this
approach is that you can't retrieve an error message if the
connection fails. (To get error information from
mysql_errno() or
mysql_error(), you must provide a valid
MYSQL pointer.)
Return Values
Same as for mysql_real_connect().
Errors
Same as for mysql_real_connect().
User Comments
If you need to compile old programs still using this function, you might want to add the following macro definition to your programs (possibly via the compiler's command line) so you needn't change all calls to mysql_connect() :
#define mysql_connect(m,h,u,p) mysql_real_connect((m),(h),(u),(p),NULL,0,NULL,0)
You should also make sure the MYSQL pointer is never NULL in these calls, though.
In response to the mysql_connect() macro, also make sure to call mysql_init() before using it. You didn't need to (or at least it worked) with older versions of the library. You will immediately crash if you don't.
Since mysql_connect(...) can take NULL or uninitialized MYSQL structure as first parameter, it would be better to use following code to make old programs work:
MYSQL * subst_mysql_connect(MYSQL * mysql, const char *host, const char *user, const char *passwd)
{
MYSQL * mysql_handle;
mysql_handle=mysql_init(mysql);
return mysql_real_connect(mysql_handle,host,user,passwd,NULL,0,NULL,0);
}
#define mysql_connect(m,h,u,p) subst_mysql_connect((m),(h),(u),(p))
Add your own comment.