MySQL Manual
9 MySQL APIs
- 9.1 MySQL C API
- 9.1.3 C API Function Descriptions
- 9.1.3.1
mysql_affected_rows() - 9.1.3.2
mysql_change_user() - 9.1.3.3
mysql_character_set_name() - 9.1.3.4
mysql_close() - 9.1.3.5
mysql_connect() - 9.1.3.6
mysql_create_db() - 9.1.3.7
mysql_data_seek() - 9.1.3.8
mysql_debug() - 9.1.3.9
mysql_drop_db() - 9.1.3.10
mysql_dump_debug_info() - 9.1.3.11
mysql_eof() - 9.1.3.12
mysql_errno() - 9.1.3.13
mysql_error() - 9.1.3.14
mysql_escape_string() - 9.1.3.15
mysql_fetch_field() - 9.1.3.16
mysql_fetch_fields() - 9.1.3.17
mysql_fetch_field_direct() - 9.1.3.18
mysql_fetch_lengths() - 9.1.3.19
mysql_fetch_row() - 9.1.3.20
mysql_field_count() - 9.1.3.21
mysql_field_seek() - 9.1.3.22
mysql_field_tell() - 9.1.3.23
mysql_free_result() - 9.1.3.24
mysql_get_client_info() - 9.1.3.25
mysql_get_server_version() - 9.1.3.26
mysql_get_host_info() - 9.1.3.27
mysql_get_proto_info() - 9.1.3.28
mysql_get_server_info() - 9.1.3.29
mysql_info() - 9.1.3.30
mysql_init() - 9.1.3.31
mysql_insert_id() - 9.1.3.32
mysql_kill() - 9.1.3.33
mysql_list_dbs() - 9.1.3.34
mysql_list_fields() - 9.1.3.35
mysql_list_processes() - 9.1.3.36
mysql_list_tables() - 9.1.3.37
mysql_num_fields() - 9.1.3.38
mysql_num_rows() - 9.1.3.39
mysql_options() - 9.1.3.40
mysql_ping() - 9.1.3.41
mysql_query() - 9.1.3.42
mysql_real_connect() - 9.1.3.43
mysql_real_escape_string() - 9.1.3.44
mysql_real_query() - 9.1.3.45
mysql_reload() - 9.1.3.46
mysql_row_seek() - 9.1.3.47
mysql_row_tell() - 9.1.3.48
mysql_select_db() - 9.1.3.49
mysql_sqlstate() - 9.1.3.50
mysql_shutdown() - 9.1.3.51
mysql_stat() - 9.1.3.52
mysql_store_result() - 9.1.3.53
mysql_thread_id() - 9.1.3.54
mysql_use_result() - 9.1.3.55
mysql_commit() - 9.1.3.56
mysql_rollback() - 9.1.3.57
mysql_autocommit() - 9.1.3.58
mysql_more_results() - 9.1.3.59
mysql_next_result()
- 9.1.3.1
9.1.3.2 mysql_change_user()
my_bool mysql_change_user(MYSQL *mysql, const char *user, const
char *password, const char *db)
Description
Changes the user and causes the database specified by db to
become the default (current) database on the connection specified by
mysql. In subsequent queries, this database is the default for
table references that do not include an explicit database specifier.
This function was introduced in MySQL Version 3.23.3.
mysql_change_user() fails unless the connected user can be
authenticated or if he doesn't have permission to use the database. In
this case the user and database are not changed
The db parameter may be set to NULL if you don't want to have a
default database.
Starting from MySQL 4.0.6 this command will always ROLLBACK any
active transactions, close all temporary tables, unlock all locked
tables and reset the state as if one had done a new connect.
This will happen even if the user didn't change.
Return Values
Zero for success. Non-zero if an error occurred.
Errors
The same that you can get from mysql_real_connect().
CR_COMMANDS_OUT_OF_SYNC- Commands were executed in an improper order.
CR_SERVER_GONE_ERROR- The MySQL server has gone away.
CR_SERVER_LOST- The connection to the server was lost during the query.
CR_UNKNOWN_ERROR- An unknown error occurred.
ER_UNKNOWN_COM_ERROR- The MySQL server doesn't implement this command (probably an old server).
ER_ACCESS_DENIED_ERROR- The user or password was wrong.
ER_BAD_DB_ERROR- The database didn't exist.
ER_DBACCESS_DENIED_ERROR- The user did not have access rights to the database.
ER_WRONG_DB_NAME- The database name was too long.
Example
if (mysql_change_user(&mysql, "user", "password", "new_database"))
{
fprintf(stderr, "Failed to change user. Error: %s\n",
mysql_error(&mysql));
}
