Search Results
https://dev.mysql.com/doc/refman/8.4/en/permission-optimization.html
Simplifying the privileges established by GRANT statements enables MySQL to reduce permission-checking overhead when clients execute statements. For example, if you do not grant any table-level or column-level privileges, the server need not ever ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-account.html
(If events access these tables explicitly for other purposes, you must grant the appropriate privileges on the tables.) Applying a binary log Table_map_log_event, which provides table metadata but does not make any database changes. It is strongly ... The user account that is specified using the CHANGE REPLICATION SOURCE TO statement as the PRIVILEGE_CHECKS_USER account for a replication channel must have the REPLICATION_APPLIER privilege, otherwise the replication applier thread does not ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks-recover.html
If the PRIVILEGE_CHECKS_USER account should have been permitted to execute the transaction, but has been misconfigured, grant the missing privileges to the account, use a FLUSH PRIVILEGES statement or execute a mysqladmin flush-privileges or ... If ...
https://dev.mysql.com/doc/refman/8.4/en/security.html
These include choosing good passwords, not granting unnecessary privileges to users, ensuring application security by preventing SQL injections and data corruption, and others. Access control and security within the database system itself, including ... When thinking about security within a MySQL installation, you should consider a wide range of possible topics and how they affect the security of your MySQL server and related applications: General factors that affect ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
row *************************** CREATE USER for u1@localhost: CREATE USER `u1`@`localhost` IDENTIFIED WITH 'caching_sha2_password' AS ... SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. The statement ...
https://dev.mysql.com/doc/refman/8.4/en/user-names.html
For information about account representation in the user table, see Section 8.2.3, “Grant Tables”. The MySQL installation process populates the grant tables with an initial root account, as described in Section 2.9.4, “Securing the Initial ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-service.html
The command connects as the MySQL root user, which is the default administrative account in the MySQL grant system. Note Users in the MySQL grant system are wholly independent from any operating system users under Windows. On Windows, the ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-5-7.html
This section provides information about keywords and reserved words in MySQL 5.7. MySQL 5.7 Keywords and Reserved Words MySQL 5.7 New Keywords and Reserved Words MySQL 5.7 Removed Keywords and Reserved Words MySQL 5.7 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-0.html
This section provides information about keywords and reserved words in MySQL 8.0. MySQL 8.0 Keywords and Reserved Words MySQL 8.0 New Keywords and Reserved Words MySQL 8.0 Removed Keywords and Reserved Words MySQL 8.0 Keywords and Reserved Words ...
https://dev.mysql.com/doc/mysqld-version-reference/en/keywords-8-4.html
This section provides information about keywords and reserved words in MySQL 8.4. MySQL 8.4 Keywords and Reserved Words MySQL 8.4 New Keywords and Reserved Words MySQL 8.4 Removed Keywords and Reserved Words MySQL 8.4 Keywords and Reserved Words ...