Search Results
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-authentication.html
If none is specified, it is authentication plugin dependent what user name is used. Since Version all versions password The password to use when authenticating the user. It is a synonym of the connection property 'password' and can also be set with ...Since Version all versions password1 The password to use in the first phase of a Multi-Factor Authentication ...
https://dev.mysql.com/doc/refman/8.4/en/role-names.html
Specifying a role with a non-'%' host part can be useful if you intend to create a name that works both as a role an as a user account that is permitted to connect from the given host. Role names differ from account names in these respects: The user ...Role names have syntax and semantics similar to account names; see Section 8.2.4, “Specifying Account ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-windows-5-2.html
You should see a window similar to the following when you open the ODBC Data Source Administrator: Figure 5.2 ODBC Data Source Administrator Dialog To create a System DSN (which will be available to all users), select the System DSN tab. To create a ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-dsn-windows-5-2.html
You should see a window similar to the following when you open the ODBC Data Source Administrator: Figure 5.1 ODBC Data Source Administrator Dialog To create a System DSN (which will be available to all users), select the System DSN tab. To create a ... The ODBC Data Source Administrator on Windows lets you create DSNs, check driver installation, and configure ODBC functions such as tracing (used for debugging) and connection ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
The user accounts created previously are used to connect to the server. Using the mysql client program, establish a connection for the user1@203.0.113.11 account that you created previously. The user1@203.0.113.11 account was created with the ...$> ...The first method uses the TLS (Transport Layer Security) protocol to establish an encrypted ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/myai-installation-clean.html
User & password: Define a user name and password for the MySQL root user. You can choose to Only allow local connections for this user (see the Warning near the beginning of Chapter 2, Installing MySQL AI). If you do not enter one, a random secret ... Installing MySQL AI requires the following steps: Install the MySQL AI ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/refman/8.4/en/sha256-pluggable-authentication.html
MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like sha256_password), but uses caching on the server side for better performance and has ...MySQL accounts that authenticate using sha256_password should be migrated to use caching_sha2_password ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-connecting-mysql-workbench.html
You can use the MySQL Administrator user that you specified when creating the DB System or a MySQL user account created on the DB System using CREATE USER . A MySQL user account on the MySQL DB System to connect with. Username: The user name of the ... Connecting with MySQL Workbench 5.2.3 Connecting with MySQL Workbench This topic describes how to connect to a MySQL DB System with MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/alter-database.html
A stored routine that uses the database defaults when the routine is created includes those defaults as part of its definition. See Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or ...alter_option: { [DEFAULT] CHARACTER SET [=] charset_name | [DEFAULT] COLLATE [=] collation_name | [DEFAULT] ENCRYPTION [=] {'Y' | 'N'} | READ ONLY [=] {DEFAULT | 0 | 1} } ALTER DATABASE enables you to change the overall characteristics of a ...