Search Results
https://dev.mysql.com/doc/refman/8.4/en/network-namespace-support.html
A connection may produce a result like this: $> mysql --user=admin --host=203.0.113.10 --protocol=tcp mysql> SELECT USER(); +--------------------+ | USER() | +--------------------+ | admin@198.51.100.2 | +--------------------+ In this case, the ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/plugin-types.html
INFORMATION_SCHEMA Plugins INFORMATION_SCHEMA plugins enable the creation of tables containing server metadata that are exposed to users through the INFORMATION_SCHEMA database. Such a plugin implements two capabilities: Rejection of too-weak ...
https://dev.mysql.com/doc/refman/8.4/en/nonpersistible-system-variables.html
For example, put these lines in your server my.cnf file: [mysqld] persist_only_admin_x509_subject="subject-value" The format of the Subject value is the same as used for CREATE USER ... A global system variable might involve sensitive data such that ... SET PERSIST and SET PERSIST_ONLY enable global system variables to be persisted to the mysqld-auto.cnf option file in the data directory (see Section 15.7.6.1, “SET Syntax for Variable ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.usage.html
--backup_innodb_undo_directory The relative or absolute directory path where InnoDB creates separate tablespaces for the undo logs. --cloud-tempauth-url The URL of the identity service for authenticating user credentials with Swift's TempAuth ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html
MYSQL * mysql_real_connect(MYSQL *mysql, const char *host, const char *user, const char *passwd, const char *db, unsigned int port, const char *unix_socket, unsigned long client_flag) Description Note mysql_real_connect() is a synchronous function.
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
Can I run NDB Cluster nodes inside virtual machines (such as those created by VMWare, VirtualBox, Parallels, or Xen)? A.10.13. How do I handle MySQL users in an NDB Cluster having multiple MySQL servers? A.10.39. Users of NDB Cluster 7.3 or 7.4 ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/mysqlbackup.privileges.html
You can either create a new user with a limited set of privileges, or use an administrative account such as root. For backing up and restoring user-created non-InnoDB tables: LOCK TABLES on all schemas containing user-created non-InnoDB tables For ... The mysqlbackup command connects to the MySQL server using the credentials supplied with the --user and --password ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-secure-installation.html
You can remove the test database (which by default can be accessed by all users, even anonymous users), and privileges that permit anyone to access databases with names that start with test_. If the plugin is not installed, mysql_secure_installation ... This program enables you to improve the security of your MySQL installation in the following ways: You can set a password for root ...
https://dev.mysql.com/doc/refman/8.4/en/mysqlslap.html
Invoke mysqlslap like this: mysqlslap [options] Some options such as --create or --query enable you to specify a string containing an SQL statement or a file containing statements. mysqlslap runs in three stages: Create schema, table, and optionally ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-connection-parameters.html
Table 5.1 Connector/ODBC DSN Configuration Options Parameter GUI Option Default Value Comment user User ODBC The user name used to connect to MySQL. password Password - The password for the user account on server. Example usage: DRIVER={MySQL ODBC ...On Unix and macOS, use the parameter name and value as the keyword/value pair in the DSN ...