Search Results
https://dev.mysql.com/doc/refman/8.4/en/native-pluggable-authentication.html
Installing Native Pluggable Authentication The mysql_native_password plugin exists in server and client forms: The server-side plugin is built into the server, but is disabled by default. To enable it, start the MySQL Server with ... MySQL includes ...When the plugin is disabled, all of the operations that depend on the plugin are ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup-os-user.html
To ensure no file permission issues prevent a server to be backed up, restored, and restarted successfully, it is highly recommended that you run mysqlbackup with the same OS user who runs the MySQL server (typically mysql). Note For Linux and other ... For Linux and other Unix-like platforms: mysqlbackup does not record file ownership or permissions of the files that are backed ...For an offline restore, you might need to, for example, set a umask to the user before the restore and adjust the permissions of the restored files and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-19.html
It is suitable for use with MySQL Server versions 8.0, 5.7, and 5.6. This patch adjusts Connector/J to those recent changes of MySQL Server and, as a result, DatabaseMetaData, ParameterMetaData, and ResultSetMetaData now report identical results for ... Version 8.0.19 is the latest General Availability release of the 8.0 series of MySQL ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-general-features-connection-routing.html
Connection routing means redirecting MySQL connections to an available MySQL server. Applications connect to MySQL Router and not directly to MySQL Server, and if the connection fails then applications are designed to retry the connection because ...Routed servers and routing strategies are defined in a configuration ...For an example deployment using ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-setup-instruments-table.html
row *************************** NAME: statement/abstract/Query ENABLED: YES TIMED: YES PROPERTIES: mutable FLAGS: NULL VOLATILITY: 0 DOCUMENTATION: SQL query just received from the network. For example, the wait/synch/mutex/sql/THD::LOCK_query_plan ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G *************************** ...row ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-stored-procedures.html
A MySqlCommand object is created, but rather than taking an SQL query as a parameter, it takes the name of the stored procedure to call. This technique avoids duplicating database code, saving time and effort when you make updates due to schema ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-stored-procedures.html
A MySqlCommand object is created, but rather than taking an SQL query as a parameter, it takes the name of the stored procedure to call. This technique avoids duplicating database code, saving time and effort when you make updates due to schema ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-introduction-server.html
Analyzing the SQL queries performed on the monitored instance, in real-time, using the Query Analyzer. MySQL Enterprise Service Manager is a web application which runs on the Apache Tomcat server. Memory Usage: Indicate how efficiently you are using ... MySQL Enterprise Service Manager is the central hub of the MySQL Enterprise Monitor installation and is responsible for the following: Receiving and storing information from the ...
https://dev.mysql.com/doc/connectors/en/connector-j-client-side-failover-xdevapi.html
This is a sample X DevAPI URL for configuring client-side failover: mysqlx://sandy:mypassword@[host1:33060,host2:33061]/test With the client-side failover configured, when there is a failure to establish a connection, Connector/J keeps attempting to ... When using the X Protocol, Connector/J supports a client-side failover feature for establishing a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-client-side-failover-xdevapi.html
This is a sample X DevAPI URL for configuring client-side failover: mysqlx://sandy:mypassword@[host1:33060,host2:33061]/test With the client-side failover configured, when there is a failure to establish a connection, Connector/J keeps attempting to ... When using the X Protocol, Connector/J supports a client-side failover feature for establishing a ...