Search Results
https://dev.mysql.com/doc/refman/8.4/en/unix-signal-response.html
This is like executing a SHUTDOWN statement without having to connect to the server (which for shutdown requires an account that has the SHUTDOWN privilege). Client Response to Signals MySQL client programs respond to signals as follows: The mysql ... On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
You should use this format in UPDATE expressions and in the WHERE clause of SELECT statements. For example: SELECT * FROM t1 WHERE date >= '2003-05-05'; As a convenience, MySQL automatically converts a date to a number if the date is used in numeric ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. When validate_password.check_user_name is enabled, it has these effects: Checking occurs in all contexts for which ... This ...
https://dev.mysql.com/doc/refman/8.4/en/windows-installation.html
To accommodate the RESTART statement, the MySQL server forks when run as a service or standalone, to enable a monitor process to supervise the server process. MySQL is available for Microsoft Windows 64-bit operating systems only. There are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica-backup-restore.html
To backup a replica database, add the --replica-info option to your backup command. To restore the backup on a replica server, follow the same steps outlined in Section 8.1, “Setting Up a New replica”. MySQL Enterprise Backup does not include ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-install-agent-user-password.html
Execute the following statement, where newuser is the new user name, and newpass is the new password: SET PASSWORD FOR 'newuser'@'127.0.0.1' = PASSWORD('newpass'); Use mcmd for the user name if you have not changed it—that is, if mcmd-user has ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-set.html
To set an attribute on the process level, use a set statement that contains an attribute assignment having the form attribute_name:process_name=value. The set statement does not contain any additional parameters that only affect a ndb_mgmd or mysqld ...Attributes can be set on either the process level or instance ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-bind-param.html
Attributes defined with mysql_bind_param() apply to nonprepared statements executed in blocking fashion with mysql_real_query() or mysql_query(), or in nonblocking fashion with mysql_real_query_nonblocking(). For a description of the members of the ... bool mysql_bind_param(MYSQL *mysql, unsigned n_params, MYSQL_BIND *bind, const char **name) Description mysql_bind_param(), available as of MySQL 8.0.23, enables defining attributes that apply to the next query sent to the ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-escape-string.html
unsigned long mysql_real_escape_string(MYSQL *mysql, char *to, const char *from, unsigned long length) Description This function creates a legal SQL string for use in an SQL statement. If you must change the character set of the connection, use the ...Note mysql_real_escape_string() fails and produces an CR_INSECURE_API_ERR error if the NO_BACKSLASH_ESCAPES SQL mode is ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-bind-param.html
bool mysql_stmt_bind_param(MYSQL_STMT *stmt, MYSQL_BIND *bind) Description mysql_stmt_bind_param() is used to bind input data for the parameter markers in the SQL statement that was passed to mysql_stmt_prepare(). The client library expects the ...