FreeBSD Manual Pages
mysql_change_user(3) MariaDB Connector/C mysql_change_user(3)
Name
mysql_change_user - changes user and default database
Synopsis
#include <mysql.h>
my_bool mysql_change_user(MYSQL * mysql,
const char * user,
const char * passwd,
const char * db);
Description
Changes the user and default database of the current connection.
In order to successfully change users a valid username and password parame-
ters must be provided and that user must have sufficient permissions to ac-
cess the desired database. If for any reason authorization fails, the cur-
rent user authentication will remain.
Parameters
* mysql is a connection identifier, which was previously allocated by
mysql_init(3) and connected by mysql_real_connect(3).
* user - the user name for server authentication
* passwd - the password for server authentication
* db - the default database. If desired, the NULL value may be passed re-
sulting in only changing the user and not selecting a database. To se-
lect a database in this case use the mysql_select_db(3) function.
Notes
* mysql_change_user will always cause the current database connection to
behave as if was a completely new database connection, regardless of if
the operation was completed successfully. This reset includes performing
a rollback on any active transactions, closing all temporary tables, and
unlocking all locked tables.
* To prevent denial of service and brute-force attacks the server will
block the connection if mysql_change_user() failed three times in a row
Return value
Returns zero on success, nonzero if an error occurred.
See also
* mysql_real_connect(3)
* mysql_select_db(3)
Version 3.4 mysql_change_user(3)
Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=mysql_change_user&sektion=3&manpath=FreeBSD+Ports+15.1.quarterly>