Search Results
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-file-io.html
The user_summary_by_file_io and x$user_summary_by_file_io views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are ...By ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, starting MySQL using systemd, resetting the password for the MySQL root@localhost user ...By default, a user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/replication-privilege-checks.html
You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE ...MySQL then checks each transaction against the user account's privileges to verify that you have authorized the operation for that ... By default, MySQL replication (including Group Replication) does ...
https://dev.mysql.com/doc/refman/9.7/en/change-replication-source-to.html
If the user account that you create or use for replication uses this authentication plugin, and you are not using a secure connection, you must enable RSA key pair-based password exchange for a successful connection. In that case, do not specify the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin-installation.html
For this purpose, a failed connection attempt is one for which the client user and host match a known MySQL account but the provided credentials are incorrect, or do not match any known account. Failed-connection counting is based on the user/host ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-security-mysql-security-procedures.html
First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard environment (that is, not using NDB). Alternatively, you can start the MySQL server process with ...
https://dev.mysql.com/doc/x-devapi-userguide/en/working-with-sql-result-sets.html
System.out.println("Rows affected: " + res.getAffectedItemsCount()); } } print_result(mySession.sql("DELETE FROM users WHERE age < 30").execute()); print_result(mySession.sql("SELECT COUNT(*) AS forty FROM users WHERE age = 40").execute()); C++ Code ... When you execute an SQL operation on a Session using the sql() method, an SqlResult is ...
https://dev.mysql.com/doc/refman/9.7/en/show-processlist.html
If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-authentication-user-plugin.html
Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET applications. MySqlConnection con = new MySqlConnection("server=localhost; database=test; user id=myuser; password=mypass"); ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-authentication-user-plugin.html
Advanced users with special security requirements can create their own authentication plugins for MySQL Connector/NET applications. MySqlConnection con = new MySqlConnection("server=localhost; database=test; user id=myuser; password=mypass"); ...