Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-connection-tables.html
When a client connects to the MySQL server, it does so under a particular user name and from a particular host. They differ in that, for grant tables, the host part of an account can be a pattern, whereas for Performance Schema tables, the host ...
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/8.4/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/refman/8.4/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/refman/8.4/en/user-resources.html
One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. In addition, setting max_user_connections does not enable management of individual accounts. An ...This ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
The operations are the same as used when setting up server s1 as the user is shared within the group. This member needs to have the same replication user configured in Section 20.2.1.3, “User Credentials For Distributed Recovery”. If you are ...
Oracle Enterprise Manager for MySQL Database User's Guide :: 6.43 Sys Schema User Statistics Metrics
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-userstatistics-category.html
Lists the Sys Schema User Statistics metrics and provides a brief description of each. Table 6.43 Sys Schema User Statistics Metrics NameDescriptionCurrent Connections The current number of connections for the user. Current Memory The current ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-mcmd.html
When specifying an agent configuration option on the command line using this method, the name of the option is prefixed with two leading dash characters (--); for example, --mcmd-user=johndoe. [DEPRECATED] --mcmd-user <username> The username used to ...Invoking this executable starts the MySQL Cluster Manager Agent, to which you can connect using the mcm client (see Section 4.3, “Starting the MySQL Cluster Manager Client” and Chapter 5, MySQL Cluster Manager Client Commands for more ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
MySQL stores credentials in the user table in the mysql system database. Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to ... Required credentials for clients that connect to the MySQL server can include a ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-key-migration.html
--keyring-migration-user, --keyring-migration-password: The account credentials to use to connect to the running server. The user who invokes a server in key-migration mode must not be the root operating system user, unless the --user option is ...