- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
- 24.2.3 Descripción de funciones de la API C
- 24.2.3.1 mysql_affected_rows()
- 24.2.3.2 mysql_change_user()
- 24.2.3.3 mysql_character_set_name()
- 24.2.3.4 mysql_close()
- 24.2.3.5 mysql_connect()
- 24.2.3.6 mysql_create_db()
- 24.2.3.7 mysql_data_seek()
- 24.2.3.8 mysql_debug()
- 24.2.3.9 mysql_drop_db()
- 24.2.3.10 mysql_dump_debug_info()
- 24.2.3.11 mysql_eof()
- 24.2.3.12 mysql_errno()
- 24.2.3.13 mysql_error()
- 24.2.3.14 mysql_escape_string()
- 24.2.3.15 mysql_fetch_field()
- 24.2.3.16 mysql_fetch_fields()
- 24.2.3.17 mysql_fetch_field_direct()
- 24.2.3.18 mysql_fetch_lengths()
- 24.2.3.19 mysql_fetch_row()
- 24.2.3.20 mysql_field_count()
- 24.2.3.21 mysql_field_seek()
- 24.2.3.22 mysql_field_tell()
- 24.2.3.23 mysql_free_result()
- 24.2.3.24 mysql_get_character_set_info()
- 24.2.3.25 mysql_get_client_info()
- 24.2.3.26 mysql_get_client_version()
- 24.2.3.27 mysql_get_host_info()
- 24.2.3.28 mysql_get_proto_info()
- 24.2.3.29 mysql_get_server_info()
- 24.2.3.30 mysql_get_server_version()
- 24.2.3.31 mysql_hex_string()
- 24.2.3.32 mysql_info()
- 24.2.3.33 mysql_init()
- 24.2.3.34 mysql_insert_id()
- 24.2.3.35 mysql_kill()
- 24.2.3.36 mysql_library_init()
- 24.2.3.37 mysql_library_end()
- 24.2.3.38 mysql_list_dbs()
- 24.2.3.39 mysql_list_fields()
- 24.2.3.40 mysql_list_processes()
- 24.2.3.41 mysql_list_tables()
- 24.2.3.42 mysql_num_fields()
- 24.2.3.43 mysql_num_rows()
- 24.2.3.44 mysql_options()
- 24.2.3.45 mysql_ping()
- 24.2.3.46 mysql_query()
- 24.2.3.47 mysql_real_connect()
- 24.2.3.48 mysql_real_escape_string()
- 24.2.3.49 mysql_real_query()
- 24.2.3.50 mysql_reload()
- 24.2.3.51 mysql_row_seek()
- 24.2.3.52 mysql_row_tell()
- 24.2.3.53 mysql_select_db()
- 24.2.3.54 mysql_set_character_set()
- 24.2.3.55 mysql_set_server_option()
- 24.2.3.56 mysql_shutdown()
- 24.2.3.57 mysql_sqlstate()
- 24.2.3.58 mysql_ssl_set()
- 24.2.3.59 mysql_stat()
- 24.2.3.60 mysql_store_result()
- 24.2.3.61 mysql_thread_id()
- 24.2.3.62 mysql_use_result()
- 24.2.3.63 mysql_warning_count()
- 24.2.3.64 mysql_commit()
- 24.2.3.65 mysql_rollback()
- 24.2.3.66 mysql_autocommit()
- 24.2.3.67 mysql_more_results()
- 24.2.3.68 mysql_next_result()
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 3.23.3.
mysql_change_user() fails if the connected
user cannot be authenticated or 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 always performs a
ROLLBACK of any active transactions, closes
all temporary tables, unlocks all locked tables and resets the
state as if one had done a new connect. This happens 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_SYNCCommands were executed in an improper order.
-
CR_SERVER_GONE_ERRORThe MySQL server has gone away.
-
CR_SERVER_LOSTThe connection to the server was lost during the query.
-
CR_UNKNOWN_ERRORAn unknown error occurred.
-
ER_UNKNOWN_COM_ERRORThe MySQL server doesn't implement this command (probably an old server).
-
ER_ACCESS_DENIED_ERRORThe user or password was wrong.
-
ER_BAD_DB_ERRORThe database didn't exist.
-
ER_DBACCESS_DENIED_ERRORThe user did not have access rights to the database.
-
ER_WRONG_DB_NAMEThe 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));
}
Ésta es una traducción del manual de referencia de MySQL, que puede encontrarse en dev.mysql.com. El manual de referencia original de MySQL está escrito en inglés, y esta traducción no necesariamente está tan actualizada como la versión original. Para cualquier sugerencia sobre la traducción y para señalar errores de cualquier tipo, no dude en dirigirse a mysql-es@vespito.com.
