Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-privileges.html
row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row *************************** Privilege: Create routine Context: Databases Comment: To ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance Schema instead; see Section 29.19.1, “Query Profiling Using Performance Schema”. To control profiling, ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...
https://dev.mysql.com/doc/refman/8.4/en/using-systemd.html
This script assists in creating the error log file only if the log location matches a pattern (/var/log/mysql*.log for RPM platforms, /var/log/mysql/*.log for Debian platforms). In other cases, the error log directory must be writable or the error ...If you install MySQL from a source distribution on a platform that uses systemd, obtain systemd support for MySQL by configuring the distribution using the -DWITH_SYSTEMD=1 CMake ...
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-deploying-bootstrapping.html
This example creates a standalone MySQL Router instance using the --directory option, enables sockets, uses --account to customize Router's MySQL username, and sets --account-create to always to only bootstrap if the account does not already exist.
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-utilities-dump-binlogs.html
If the location specified exists and contains a dump created by this utility, the snapshot information in that dump is used as the starting point for the binary log dump. The dump was created for an instance different from the current source ...This ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-generate-content.html
OutputTableName: the name of the table where you want to create a new column to store the generated outputs. If the specified table doesn't exist, a new table is created. row *************************** id: 1 Output: {"text": "\nMySQL is an ... The ...
https://dev.mysql.com/doc/workbench/en/wb-audit-inspector.html
Note MySQL Workbench will prompt for sudo access if the MySQL Workbench user is unable to read the audit log file. Each record includes a record ID, timestamp, type, connection ID, user, host/IP, status, command class, and information. MySQL ...
https://dev.mysql.com/doc/workbench/en/wb-installing-windows.html
Important Installing MySQL Workbench using a Windows MSI Installer package requires either Administrator or Power User privileges. To install MySQL Workbench: From an account with Administrator or Power User privileges, right-click the MSI file and ... MySQL Workbench for Windows can be installed using the MySQL Installer that installs and updates all MySQL products on Windows or the standalone Windows MSI Installer ...
https://dev.mysql.com/doc/workbench/en/wb-model-editor.html
Figure 9.3 The MySQL Model Page The Description Editor and User Types List (with the User Types and History secondary tabs) are contained within the sidebar. When the Model Editor is executed from the home screen, MySQL Workbench displays the MySQL ...