Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/ui-security-advisor-ref.html
This advisor enables you to define a regular expression that describes those user accounts that are allowed to have database level privileges on all databases in the mysql.user table (ALTER, CREATE, DELETE, DROP, INDEX, INSERT, SELECT, UPDATE).
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
For example, if a view is defined as SELECT * on a table, new columns added to the table later do not become part of the view, and columns dropped from the table result in an error when selecting from the view. If the OR REPLACE clause is present, ...If the view does not exist, CREATE OR REPLACE VIEW is the same as CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/stored-routines-privileges.html
The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped. However, this privilege is granted ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
(This is another reason you might wish to force MySQL to use the temptable algorithm by specifying ALGORITHM = TEMPTABLE in the view definition.) You can use DROP TABLE or ALTER TABLE to drop or alter a table that is used in a view definition. No ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Table creation and drop operations for any storage engine modify data dictionary tables in the mysql system database, but those tables use the InnoDB storage engine and cannot be modified when innodb_read_only is enabled. Use of a data ...As of ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME can also be used to move a table to a different database. Regardless of the statement used, if the rename operation would move ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/doc/refman/8.4/en/create-temporary-table.html
Dropping a database does not automatically drop any TEMPORARY tables created within that database. A TEMPORARY table is visible only within the current session, and is dropped automatically when the session is closed. (The existing table is hidden ... You can use the TEMPORARY keyword when creating a ...
https://dev.mysql.com/doc/refman/8.4/en/point-in-time-recovery-positions.html
Your database has now been restored to the point-in-time of interest, tp, right before the table pets.cats was dropped. Find the precise binary log event position corresponding to the point in time up to which you want to restore your database. The ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
To revoke all privileges from a user, use one of the following statements; either of these statements drops all global, database, table, column, and routine privileges for the named users or roles: REVOKE ALL PRIVILEGES, GRANT OPTION FROM ...[IGNORE ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-genai-summarize-content.html
If you created a new database for testing the steps in this section, delete the database to free up space: mysql> DROP DATABASE demo_db; To learn more about the available routine options, see ML_GENERATE_TABLE Syntax. This makes it easier to manage ... The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...