diff options
Diffstat (limited to 'libmariadb/man/mysql_change_user.3')
-rw-r--r-- | libmariadb/man/mysql_change_user.3 | 62 |
1 files changed, 62 insertions, 0 deletions
diff --git a/libmariadb/man/mysql_change_user.3 b/libmariadb/man/mysql_change_user.3 new file mode 100644 index 00000000..8f9939b8 --- /dev/null +++ b/libmariadb/man/mysql_change_user.3 @@ -0,0 +1,62 @@ +.\" Automatically generated by Pandoc 2.5 +.\" +.TH "mysql_change_user" "3" "" "Version 3.3.1" "MariaDB Connector/C" +.hy +.SS Name +.PP +mysql_change_user \- changes user and default database +.SS Synopsis +.IP +.nf +\f[C] +#include <mysql.h> + +my_bool mysql_change_user(MYSQL * mysql, + const char * user, + const char * passwd, + const char * db); +\f[R] +.fi +.SS Description +.PP +Changes the user and default database of the current connection. +.PP +In order to successfully change users a valid username and password +parameters must be provided and that user must have sufficient +permissions to access the desired database. +If for any reason authorization fails, the current user authentication +will remain. +.SS Parameters +.IP \[bu] 2 +\f[C]mysql\f[R] is a connection identifier, which was previously +allocated by \f[B]mysql_init(3)\f[R] and connected by +\f[B]mysql_real_connect(3)\f[R]. +.IP \[bu] 2 +\f[C]user\f[R] \- the user name for server authentication +.IP \[bu] 2 +\f[C]passwd\f[R] \- the password for server authentication +.IP \[bu] 2 +\f[C]db\f[R] \- 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 \f[B]mysql_select_db(3)\f[R] +function. +.SS Notes +.IP \[bu] 2 +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. +.IP \[bu] 2 +To prevent denial of service and brute\-force attacks the server will +block the connection if \f[C]mysql_change_user()\f[R] failed three times +in a row +.SS Return value +.PP +Returns zero on success, nonzero if an error occurred. +.SS See also +.IP \[bu] 2 +\f[B]mysql_real_connect(3)\f[R] +.IP \[bu] 2 +\f[B]mysql_select_db(3)\f[R] |