Search Results
https://dev.mysql.com/doc/refman/8.4/en/multifactor-authentication.html
When a client attempts a connection to the MySQL server using a single-factor account, the server invokes the authentication plugin indicated by the account definition and accepts or rejects the connection depending on whether the plugin reports ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-command-line-servers.html
To shut down the servers, connect to each using the appropriate port number: C:\> C:\mysql\bin\mysqladmin --port=3307 --host=127.0.0.1 --user=root --password shutdown C:\> C:\mysql\bin\mysqladmin --port=3308 --host=127.0.0.1 --user=root --password ... The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.3.6, “Starting MySQL from the Windows Command ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-membership.html
The membership table describes the view that each data node has of all the others in the cluster, including node group membership, president node, arbitrator, arbitrator successor, arbitrator connection states, and other information. If the ...We ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-quick.html
Connect to the server and verify that the NDBCLUSTER storage engine is enabled: $> mysql Welcome to the MySQL monitor. Your MySQL connection id is 1 to server version: 8.4.6 Type 'help;' or '\h' for help. To familiarize you with the basics, we ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-multi.html
mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix socket files and TCP/IP ports. --tcp-ip Command-Line Format --tcp-ip Type Boolean Default Value false Connect to each MySQL server through the ...It can start or stop servers, or report their current ...
https://dev.mysql.com/doc/refman/8.4/en/no-login-pluggable-authentication.html
The mysql_no_login server-side authentication plugin prevents all client connections to any account that uses it. To uninstall it, use UNINSTALL PLUGIN: UNINSTALL PLUGIN mysql_no_login; Using No-Login Pluggable Authentication This section describes ...Use cases for this plugin include: Accounts that must be able to execute stored programs and views with elevated privileges without exposing those privileges to ordinary ...
https://dev.mysql.com/doc/refman/8.4/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Your MySQL connection id is 3 Server version: 8.4.6 Source ...Due to ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-hosts-table.html
The hosts table contains a row for each host from which clients have connected to the MySQL server. For each host name, the table counts the current and total number of connections. For a description of how the Performance Schema maintains rows in ...To set the table size explicitly, set the performance_schema_hosts_size system variable at server ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-users-table.html
The users table contains a row for each user who has connected to the MySQL server. For each user name, the table counts the current and total number of connections. For a description of how the Performance Schema maintains rows in this table, ...
https://dev.mysql.com/doc/refman/8.4/en/start-replica.html
START REPLICA [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...uuid: ...