Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
CREATE USER [IF NOT EXISTS] user [auth_option] [, user [auth_option]] ... To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system schema. When the read_only system variable is enabled, CREATE ...(That is, the statement fails if creating an account would cause the account to adopt a currently orphaned stored object.) To perform the operation anyway, you must have the SET_ANY_DEFINER or ALLOW_NONEXISTENT_DEFINER privilege; in this case, the statement succeeds with a warning rather than failing with an ...
https://dev.mysql.com/doc/refman/8.4/en/create-procedure.html
If the DEFINER clause is omitted, the default definer is the user who executes the CREATE PROCEDURE or CREATE FUNCTION statement. Consider the following procedure, which displays a count of the number of MySQL accounts listed in the mysql.user ...To ...By default, a stored routine is associated with the default ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create-server.html
For reference, the format of the CONNECTION string is as follows: scheme://user_name[:password]@host_name[:port_num]/db_name/tbl_name Description CONNECTION string CREATE SERVER option mysql.servers column Connection scheme scheme wrapper_name ...If ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-files.html
For an InnoDB table created in a file-per-table tablespace or general tablespace, table data and associated indexes are stored in a .ibd file in the database directory. When an InnoDB table is created in the system tablespace, table data and ...The ...
https://dev.mysql.com/doc/mysql-errors/8.4/en/server-error-reference.html
Error number: 4044; Symbol: ER_KERBEROS_CREATE_USER; SQLSTATE: HY000 Message: Create/Alter user has failed, Configured user realm as authentication string is empty, Please make sure to configure authentication string as user realm. Error number: ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
(To associate an LDAP user DN with a MySQL account, include a BY clause that specifies an authentication string in the CREATE USER statement that creates the account.) If the MySQL account names no LDAP user DN, LDAP authentication uses the user ...
https://dev.mysql.com/doc/refman/8.4/en/alter-user.html
In most cases, ALTER USER requires the global CREATE USER privilege, or the UPDATE privilege for the mysql system schema. If an account is to be permitted to manipulate secondary passwords for all accounts, it requires the CREATE USER privilege ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/creating-user-accounts-for-admin-api.html
The user accounts used to configure and administer a member server instance in an InnoDB Cluster, InnoDB ClusterSet, or InnoDB ReplicaSet deployment must have full read and write privileges on the metadata tables, in addition to full MySQL ...You ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-creating-user-roles-tasks.html
Creating a Role Note It is not possible to save a new user without an assigned role. Creating a User This section describes how to create a user. To create a user, do the following: Select Users from the Settings menu (gear icon). To create a role, ...On the Details tab, enter a name in the Role Name field and add a description of the ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-user.html
SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. Password hash values displayed in the IDENTIFIED WITH clause of output from SHOW CREATE USER may contain unprintable characters that have adverse ...