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 pa-
rameters must be provided and that user must have sufficient permis-
sions to access the desired database. If for any reason authorization
fails, the current 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
resulting in only changing the user and not selecting a database. To
select 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 tempo-
rary 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+14.3.quarterly>