(mysql.info.gz) mysql_change_user

Info Catalog

(mysql.info.gz) mysql_affected_rows

(mysql.info.gz) C API functions

(mysql.info.gz) mysql_character_set_name

 
 22.2.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 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 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));
      }
 

Info Catalog

(mysql.info.gz) mysql_affected_rows

(mysql.info.gz) C API functions

(mysql.info.gz) mysql_character_set_name