Search Results
https://dev.mysql.com/doc/heatwave-aws/en/mysql-server-default-privileges.html
Default MySQL Privileges 3.1.2.9 Default MySQL Privileges This section lists the MySQL privileges granted to the MySQL Administrator user on the DB System and those explicitly revoked on the mysql and sys schemas.
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
For example, if you try to select rows from a table in a database or drop a table from the database, the server verifies that you have the SELECT privilege for the table or the DROP privilege for the database. You cannot specify that a user has ...
https://dev.mysql.com/doc/refman/8.4/en/account-categories.html
Without the system user concept, a user who has the CREATE USER privilege can modify or drop any existing account, including the root account. Regular users with the CREATE USER privilege can still modify or drop existing accounts, but only regular ... MySQL incorporates the concept of user account categories, based on the SYSTEM_USER ...
https://dev.mysql.com/doc/refman/8.4/en/alter-table-examples.html
If you drop an AUTO_INCREMENT column and then add another AUTO_INCREMENT column, the numbers are resequenced beginning with 1. Regardless of the method used to create and populate the copy having the AUTO_INCREMENT column, the final step is to drop ...For NDB tables, it is also possible to change the storage type used for a table or ...
https://dev.mysql.com/doc/refman/8.4/en/delete.html
Partitioned Table Support DELETE supports explicit partition selection using the PARTITION clause, which takes a list of the comma-separated names of one or more partitions or subpartitions (or both) from which to select rows to be dropped. Given a ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.4/en/locking-service.html
To remove them, use the DROP FUNCTION statement: DROP FUNCTION service_get_read_locks; DROP FUNCTION service_get_write_locks; DROP FUNCTION service_release_locks; Using the Locking Service Function Interface Before using the locking service ...
https://dev.mysql.com/doc/refman/8.4/en/merge-table-problems.html
You should not use ANALYZE TABLE, REPAIR TABLE, OPTIMIZE TABLE, ALTER TABLE, DROP TABLE, DELETE without a WHERE clause, or TRUNCATE TABLE on any of the tables that are mapped into an open MERGE table. DROP TABLE on a table that is in use by a MERGE ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-privilege-synchronization.html
For example, if a DROP DATABASE statement follows a DROP USER of a distributed user, the drop of the database cannot take place until the drop of the user has completed on all SQL nodes. Privilege synchronization is the mechanism used by NDB ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlbinlog.html
There is an exception for CREATE DATABASE, ALTER DATABASE, and DROP DATABASE. The database being created, altered, or dropped is considered to be the default database when determining whether to output the statement. When you specify this option, ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops. Too much ... Different settings work best for servers with light, predictable loads, versus servers that are running near full capacity all the time, or that experience spikes of high ...