Search Results
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-workflow-server.html
It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and Backup Admin. MySQL User Accounts (Optional) Click Add User or Edit User to create or modify MySQL ...Next, enter the required account credentials: User Name: MySQL user names can be up to 32 characters ...Note ... MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
The DROP USER statement removes one or more MySQL accounts and their privileges. To use DROP USER, you must have the global CREATE USER privilege, or the DELETE privilege for the mysql system schema. DROP USER fails with an error if any account to ...It removes privilege rows for the account from all grant ...Roles named ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-parameters.html
Examples: Account-management statements such as CREATE USER and GRANT fail because the grant tables use InnoDB. innodb_default_row_format Command-Line Format --innodb-default-row-format=value System Variable innodb_default_row_format Scope Global ...
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
(That is, the statement fails if renaming an account would cause a stored object to become orphaned.) CREATE USER fails with an error if any account to be created is named as the DEFINER attribute for any stored object. Administrators can prevent ...
https://dev.mysql.com/doc/refman/8.4/en/problems-connecting.html
is not allowed to connect to this MySQL server You can fix this by setting up an account for the combination of client host name and user name that you are using when trying to connect. (The data directory normally is named data or var and is ... If ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. This section does not provide in-depth information on creating stored procedures. For example, to ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
In such a setup, applications and users would not get any access to the database tables directly, but can only execute specific stored procedures. This section does not provide in-depth information on creating stored procedures. For example, to ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/restore-use-tts.html
The following is some additional information on partial restores using TTS backups To backup and restore backups created using TTS, extra privileges are required of the user through which mysqlbackup connects to the server; see Section 4.1.2, ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-configurator-cli.html
windows-service-user N/A win-service-user, service-user string N/A NT AUTHORITY configure, reconfigure configure-as-service=true The name of a Windows User Account used to run the Windows service. windows-service-password N/A win-service-password, ...Executing MySQL Configurator requires a Windows user with administrative privileges, as otherwise the system prompts for the ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-compression-usage.html
The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed. Compressed tables can be created in file-per-table tablespaces or in general tablespaces.