Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
Database Level Privileges On All Databases User Exclusion Regex: Privileges such as SELECT, INSERT, and ALTER, allow a user to view and change data. This advisor enables you to define a regular expression that describes those user accounts that are ... This section describes the following Security advisors: MySQL Enterprise Audit Plugin MySQL Enterprise Firewall MySQL User Account MySQL Enterprise Audit Plugin Note For more information on the MySQL Enterprise Audit Plugin, see MySQL Enterprise ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory guidelines.
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/x-devapi-userguide-shell-js/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-js/en/devapi-users-working-with-relational-tables.html
The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are similar to running INSERT and SELECT statements on a table with an SQL client. values('Laurie', mysqlx.dateValue(2000, 5, 27), ...
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']). bind('param', 'm%').execute(); // Traditional SQL ... X ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/crud-ebnf-table-crud-functions.html
TableSelectFunction Table.select() and collection.find() use different methods for sorting results. Table.select() follows the SQL language naming and calls the sort method orderBy(). Use the method sort() to sort the results returned by ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/devapi-users-working-with-relational-tables.html
The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are similar to running INSERT and SELECT statements on a table with an SQL client. The X DevAPI SQL CRUD functions allow you to work ...
https://dev.mysql.com/doc/x-devapi-userguide-shell-python/en/method-chaining.html
X DevAPI supports a number of modern practices to make working with CRUD operations easier and to fit naturally into modern development environments. This section explains how to use method chaining instead of working with SQL strings of JSON ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-encoding.html
mysql> SELECT log->>"$.sql" AS "SQL Script" FROM sys.heatwave_autopilot_report WHERE type = "sql" ORDER BY id; To concatenate generated DDL statements into a single string that can be copied and pasted for execution, issue the statements that follow. (The default group_concat_max_len setting is 1024 bytes.) mysql> SET SESSION group_concat_max_len = 1000000; mysql> SELECT GROUP_CONCAT(log->>"$.sql" SEPARATOR ' ') FROM sys.heatwave_advisor_report WHERE type = "sql" ORDER BY id; Usage Notes Auto Encoding analyzes string columns (CHAR, VARCHAR, and TEXT type columns) of tables that are loaded in MySQL ...