- 21.9.3 C API Function Descriptions
- 21.9.3.1 mysql_affected_rows()
- 21.9.3.2 mysql_autocommit()
- 21.9.3.3 mysql_change_user()
- 21.9.3.4 mysql_character_set_name()
- 21.9.3.5 mysql_close()
- 21.9.3.6 mysql_commit()
- 21.9.3.7 mysql_connect()
- 21.9.3.8 mysql_create_db()
- 21.9.3.9 mysql_data_seek()
- 21.9.3.10 mysql_debug()
- 21.9.3.11 mysql_drop_db()
- 21.9.3.12 mysql_dump_debug_info()
- 21.9.3.13 mysql_eof()
- 21.9.3.14 mysql_errno()
- 21.9.3.15 mysql_error()
- 21.9.3.16 mysql_escape_string()
- 21.9.3.17 mysql_fetch_field()
- 21.9.3.18 mysql_fetch_field_direct()
- 21.9.3.19 mysql_fetch_fields()
- 21.9.3.20 mysql_fetch_lengths()
- 21.9.3.21 mysql_fetch_row()
- 21.9.3.22 mysql_field_count()
- 21.9.3.23 mysql_field_seek()
- 21.9.3.24 mysql_field_tell()
- 21.9.3.25 mysql_free_result()
- 21.9.3.26 mysql_get_character_set_info()
- 21.9.3.27 mysql_get_client_info()
- 21.9.3.28 mysql_get_client_version()
- 21.9.3.29 mysql_get_host_info()
- 21.9.3.30 mysql_get_proto_info()
- 21.9.3.31 mysql_get_server_info()
- 21.9.3.32 mysql_get_server_version()
- 21.9.3.33 mysql_get_ssl_cipher()
- 21.9.3.34 mysql_hex_string()
- 21.9.3.35 mysql_info()
- 21.9.3.36 mysql_init()
- 21.9.3.37 mysql_insert_id()
- 21.9.3.38 mysql_kill()
- 21.9.3.39 mysql_library_end()
- 21.9.3.40 mysql_library_init()
- 21.9.3.41 mysql_list_dbs()
- 21.9.3.42 mysql_list_fields()
- 21.9.3.43 mysql_list_processes()
- 21.9.3.44 mysql_list_tables()
- 21.9.3.45 mysql_more_results()
- 21.9.3.46 mysql_next_result()
- 21.9.3.47 mysql_num_fields()
- 21.9.3.48 mysql_num_rows()
- 21.9.3.49 mysql_options()
- 21.9.3.50 mysql_ping()
- 21.9.3.51 mysql_query()
- 21.9.3.52 mysql_real_connect()
- 21.9.3.53 mysql_real_escape_string()
- 21.9.3.54 mysql_real_query()
- 21.9.3.55 mysql_refresh()
- 21.9.3.56 mysql_reload()
- 21.9.3.57 mysql_rollback()
- 21.9.3.58 mysql_row_seek()
- 21.9.3.59 mysql_row_tell()
- 21.9.3.60 mysql_select_db()
- 21.9.3.61 mysql_set_character_set()
- 21.9.3.62 mysql_set_local_infile_default()
- 21.9.3.63 mysql_set_local_infile_handler()
- 21.9.3.64 mysql_set_server_option()
- 21.9.3.65 mysql_shutdown()
- 21.9.3.66 mysql_sqlstate()
- 21.9.3.67 mysql_ssl_set()
- 21.9.3.68 mysql_stat()
- 21.9.3.69 mysql_store_result()
- 21.9.3.70 mysql_thread_id()
- 21.9.3.71 mysql_use_result()
- 21.9.3.72 mysql_warning_count()
MYSQL *mysql_connect(MYSQL *mysql, const char *host,
const char *user, const char *passwd)
Description
This function is deprecated. 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.