Search Results
https://dev.mysql.com/doc/refman/8.4/en/macos-installation-notes.html
Users: You may need (or want) to create a specific mysql user to own the MySQL directory and data. You can do this through the Directory Utility, and the mysql user should already exist. For use in single user mode, an entry for _mysql (note the ...
https://dev.mysql.com/doc/refman/8.4/en/merge-storage-engine.html
Note The use of MERGE tables entails the following security issue: If a user has access to MyISAM table t, that user can create a MERGE table m that accesses t. However, if the user's privileges on t are subsequently revoked, the user can continue ... The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection of identical MyISAM tables that can be used as ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
When a user-created NDB table is accessed using a unique index, the hidden index table is first read to find the primary key that is then used to read the user-created table. When a row referenced by a unique index in the user-created NDB table is ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-events.html
SINGLEUSER Events These events are associated with entering and exiting single user mode. Table 25.36 Events relating to single user mode Event Priority Severity Level Description SingleUser 7 INFO Entering or exiting single user mode BACKUP Events ... An event report reported in the event logs has the following format: datetime [string] severity -- message For example: 09:19:30 2005-07-24 [NDB] INFO -- Node 4 Start phase 4 completed This section discusses all reportable events, ordered by category and severity level within each ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-waiter.html
SINGLE USER MODE: This is shown for all cluster data nodes when the cluster is in single user mode. --single-user The program waits for the cluster to enter single user mode. ndb_waiter repeatedly (each 100 milliseconds) prints out the status of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-auto-sync.html
#!/user/bin/perl -w # file: reset-replica.pl # Copyright (c) 2005, 2020, Oracle and/or its affiliates. It is possible to automate much of the process described in the previous section (see Section 25.7.9, “NDB Cluster Backups With NDB Cluster ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. This table can be updated by the user to perform filtering by database or table. Some ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server instance acting as an SQL node in both the cluster being replicated and in the ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-commands.html
Resetting a connection has effects similar to mysql_change_user() or an auto-reconnect except that the connection is not closed and reopened, and re-authentication is not done. For example: $> mysql --prompt="(\u@\h) [\d]> " (user@host) [database]> ... mysql sends each SQL statement that you issue to the server to be ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-innodb-cluster-introduction.html
Advanced users can also take advantage of a multi-primary mode, where all instances are primaries. Operations enable you to create MySQL Router users at the cluster level, to work with the MySQL Routers bootstrapped against the cluster, and so on.
https://dev.mysql.com/doc/refman/8.4/en/mysql-oci-marketplace-connecting.html
To connect to the Oracle Linux running on the Compute Instance with SSH, run the following command: ssh opc@computeIP where opc is the compute user and computeIP is the IP address of your Compute Instance. To find the temporary root password created ... This section describes the various connection methods for connecting to the deployed MySQL server on the OCI Compute ...