Search Results
https://dev.mysql.com/doc/refman/8.4/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. As an administrator, connect to the server and create an ... The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host ...
https://dev.mysql.com/doc/refman/8.4/en/lock-instance-for-backup.html
The BACKUP_ADMIN privilege is automatically granted to users with the RELOAD privilege when performing an in-place upgrade to MySQL 8.4 from an earlier version. LOCK INSTANCE FOR BACKUP permits DDL operations that only affect user-created temporary ... LOCK INSTANCE FOR BACKUP UNLOCK INSTANCE LOCK INSTANCE FOR BACKUP acquires an instance-level backup lock that permits DML during an online backup while preventing operations that could result in an inconsistent ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #36871927) JavaScript Programs Employing a user variable in a DML statement within a stored procedure that used the Statement handle interface sometimes led to an unplanned server exit when any statement was executed following execution of such ... C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance Schema Notes sys Schema Notes Thread Pool Notes Functionality Added or Changed Bugs Fixed C API Notes The asynchronous interface used unsafe static local variables to store state ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-issues-mysql-server.html
The --skip option modifier is supported in some but not all cases, so that commands such as set skip-innodb:mysqld=true mycluster; and set skip-grant-tables:mysqld=true mycluster; can be used with MySQL Cluster Manager, while set ... The limitations ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-using-import-cluster-procedure.html
Create a MySQL user named mcmd on each SQL node, and grant root privileges to the user. Create and configure “target” cluster under MySQL Cluster Manager control Install MySQL Cluster Manager and start mcmd on all hosts with the same system user ... The importing process consists generally of the steps listed here: Prepare the “wild” cluster for ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-write-splitting-statements.html
The following Account Management statements: GRANT, REVOKE, RENAME USER, CREATE ROLE, CREATE USER, DROP ROLE, DROP USER, SET PASSWORD, SET ROLE, SET DEFAULT ROLE. The following describes read-only statements: Statements are read-only if they start ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME ...
https://dev.mysql.com/doc/refman/8.4/en/internal-locking.html
Row-Level Locking Table-Level Locking Choosing the Type of Locking Row-Level Locking MySQL uses row-level locking for InnoDB tables to support simultaneous write access by multiple sessions, making them suitable for multi-user, highly concurrent, ...
https://dev.mysql.com/doc/workbench/en/wb-admin-server-management.html
To open the Administration - Users and Privileges secondary tab (see the previous figure), click Server and then Users and Privileges. For example, the Administration - Users and Privileges secondary tab (see the previous figure) has four subtabs: ... Manage your MySQL instances with a comprehensive view of your MySQL server ...
https://dev.mysql.com/doc/workbench/en/wb-installing-linux.html
There are binary distributions of MySQL Workbench available for several variants of Linux, including Fedora, Oracle Linux, and Ubuntu. For general requirements and specific installation instructions, see the sections that follow. Requirements for ...