Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-post-install-general.html
This section describes some of the general tasks which may be required after installation or upgrade. New Users Groups and Connections: Groups have always been used to define Event handling and Advisor scheduling policies; in this release Groups ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/repository-prereq-reference.html
MySQL Enterprise Service Manager requires a repository to store its data. The installer optionally installs a local, clean repository for this purpose. However, you can choose not to install the bundled MySQL Server and use another repository ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/schema-advisor-ref.html
Default frequency 00:10:00 Default auto-close enabled no MyISAM Indexes Found with No Statistics The MySQL optimizer needs index statistics to help make choices about whether to use indexes to satisfy SQL queries. MySQL's mechanism for doing this is ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/sql-mode-check-startup.html
On startup, the agent sets sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER on the monitored MySQL instance. The local agent of MySQL Enterprise Service Manager also sets sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION on ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-configure-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the account row from the mysql.user table. The server authenticates the client, determining from the account row which ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-firewall.html
MySQL Enterprise Firewall is an application-level firewall that enables database administrators to permit or deny SQL statement execution based on matching against allowlists of accepted statement patterns. This helps harden MySQL against attacks ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-password-validation.html
The validate_password component serves to test user-specified passwords and improve security. The component exposes a set of system variables that enable you to define a password policy. The component implements two capabilities: In statements that ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-user-accounts.html
Other resource-limiting options not used here include MAX_QUERIES_PER_HOUR, MAX_UPDATES_PER_HOUR, and MAX_CONNECTIONS_PER_HOUR. It demonstrates configuring global password policies, using security-related CREATE USER options, granting user ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/connecting-to-a-single-mysqld-node-setup.html
In this example a connection to a local MySQL Server instance running X Plugin on the default TCP/IP port 33060 is established using the MySQL user account user with its password. You are prompted to enter the user name and password in this case.
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/method-chaining.html
// New method chaining used for executing an SQL SELECT statement // Recommended way for executing queries var employees = db.getTable('employee'); var res = employees.select(['name', 'age']). X DevAPI supports a number of modern practices to make ...