Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-reload.html
int mysql_reload(MYSQL *mysql) Description Asks the MySQL server to reload the grant tables. Use mysql_real_query() or mysql_query() to issue an SQL FLUSH PRIVILEGES statement instead. CR_SERVER_LOST The connection to the server was lost during the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-select-db.html
In subsequent queries, this database is the default for table references that include no explicit database specifier. int mysql_select_db(MYSQL *mysql, const char *db) Description Causes the database specified by db to become the default (current) ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-sqlstate.html
For example, the mysql client program displays errors using the following format, where 1146 is the mysql_errno() value and '42S02' is the corresponding mysql_sqlstate() value: $> SELECT * FROM no_such_table; ERROR 1146 (42S02): Table ... const char ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stat.html
This includes uptime in seconds and the number of running threads, questions, reloads, and open tables. const char * mysql_stat(MYSQL *mysql) Description Returns a character string containing information similar to that provided by the mysqladmin ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-insert-id.html
Use this function after you have executed a prepared INSERT statement on a table which contains an AUTO_INCREMENT field. uint64_t mysql_stmt_insert_id(MYSQL_STMT *stmt) Description Returns the value generated for an AUTO_INCREMENT column by the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-store-result.html
After invoking mysql_real_query() or mysql_query(), you must call mysql_store_result() or mysql_use_result() for every statement that successfully produces a result set (SELECT, SHOW, DESCRIBE, EXPLAIN, CHECK TABLE, and so forth). You need not call ... MYSQL_RES * mysql_store_result(MYSQL *mysql) Description Note mysql_store_result() is a synchronous ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/mysql-threads.html
If the server is started with the --flush_time=val option, a dedicated thread is created to flush all tables every val seconds. The MySQL server creates the following threads: Connection manager threads handle client connection requests on the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-client-side.html
Declare the client-side plugin descriptor with the mysql_declare_client_plugin() and mysql_end_client_plugin macros (see Section 4.4.2.3, “Client Plugin Descriptors”). (For descriptions, see Section 4.4.2.3, “Client Plugin Descriptors”.) ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins.html
Authentication plugins enable the use of authentication methods other than the built-in method of passwords stored in the mysql.user system table. MySQL supports pluggable authentication, in which plugins are invoked to authenticate client ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-daemon-plugins.html
To verify plugin installation, examine the INFORMATION_SCHEMA.PLUGINS table or use the SHOW PLUGINS statement. A daemon plugin is a simple type of plugin used for code that should be run by the server but that does not communicate with it. This ...