Search Results
https://dev.mysql.com/doc/refman/8.4/en/privilege-changes.html
Any user can connect and perform any operation, which is insecure. If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become ...
https://dev.mysql.com/doc/refman/8.4/en/program-options.html
There are several ways to specify options for MySQL programs: List the options on the command line following the program name. This is common for options that apply to a specific invocation of the program. List the options in an option file that ...
https://dev.mysql.com/doc/refman/8.4/en/replication-bugs.html
When you have determined that there is no user error involved, and replication still either does not work at all or is unstable, it is time to send us a bug report. If you have a “phantom” problem (one that you cannot duplicate at will), use ...
https://dev.mysql.com/doc/refman/8.4/en/replication-delayed.html
Delayed replication can be used for several purposes: To protect against user mistakes on the source. The output of mysqlbinlog displays these timestamps in two formats, microseconds from epoch and also TIMESTAMP format, which is based on the user ... MySQL supports delayed replication such that a replica server deliberately executes transactions later than the source by at least a specified amount of ...
https://dev.mysql.com/doc/refman/8.4/en/replication-problems.html
Many users have lost time by not doing this soon enough after encountering problems. If the receiver thread state says Connecting to master, check the following: Verify the privileges for the replication user on the source. If you have followed the ...
https://dev.mysql.com/doc/refman/8.4/en/selinux.html
An SELinux context (the label applied to a system object) has the following fields: user, role, type, and security level. Security-Enhanced Linux (SELinux) is a mandatory access control (MAC) system that implements access rights by applying a ...
https://dev.mysql.com/doc/refman/8.4/en/set-resource-group.html
For attempts to assign a system thread to a user resource group or a user thread to a system resource group, a warning occurs. SET RESOURCE GROUP group_name [FOR thread_id [, thread_id] ...] SET RESOURCE GROUP is used for resource group management ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines.html
In such a setup, applications and users would have no access to the database tables directly, but can only execute specific stored routines. Additional Resources You may find the Stored Procedures User Forum of use when working with stored ...A ...
https://dev.mysql.com/doc/refman/8.4/en/sys-execute-prepared-stmt.html
Configuration Options execute_prepared_stmt() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 30.4.2.1, “The sys_config Table”): debug, @sys.debug If this option is ... Given an SQL statement as a string, executes it as a prepared ...
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-by-thread-by-current-bytes.html
By default, rows are sorted by descending amount of memory used. The memory_by_thread_by_current_bytes and x$memory_by_thread_by_current_bytes views have these columns: thread_id The thread ID. current_count_used The current number of allocated ...