Search Results
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ldap-user-password.html
MySQL uses LDAP to fetch user, credential, and group information. MySQL Workbench users connect to the MySQL server by providing the MySQL user name and LDAP password. For an overview of how LDAP authentication works with MySQL, see How LDAP ...The ...
https://dev.mysql.com/doc/refman/9.7/en/account-activity-auditing.html
Specifically, do not permit User to be empty (which creates an anonymous-user account), and do not permit pattern characters or netmask notation in Host values. The User and Host column values in this row uniquely identify the account and correspond ... Applications can use the following guidelines to perform SQL-based auditing that ties database activity to MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/security-against-attack.html
This is extremely dangerous, because any user with the FILE privilege is able to cause the server to create files as root (for example, ~root/.bashrc). The CREATE USER and ALTER USER statements also support resource control options for limiting the ...It is common for client/server applications that the user can specify any user name to the client ...
https://dev.mysql.com/doc/refman/9.7/en/problems-connecting.html
(The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the mysql database directory. $> mysql -u root ERROR 1045 (28000): Access denied for user ...
https://dev.mysql.com/doc/refman/9.7/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, ...
https://dev.mysql.com/doc/refman/9.7/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 ...Note Full permissions are granted to the user executing MySQL Configurator to all generated files, such as ... MySQL Configurator ...
https://dev.mysql.com/doc/refman/9.7/en/information-schema-user-attributes-table.html
Attributes are shown exactly as set using CREATE USER and ALTER USER statements with ATTRIBUTE or COMMENT options. For additional information and examples, see CREATE USER Comment and Attribute Options. The currently authenticated account has the ...
https://dev.mysql.com/doc/refman/9.7/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ...The EVENT privilege governs the creation, modification, and deletion of ... To enable or disable the execution of scheduled events, ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-ldap-kerberos-authentication.html
To use simple LDAP authentication with MySQL Shell, the following conditions must be satisfied: A user account must be created on the MySQL server that is set up to communicate with the LDAP server. For example: CREATE USER 'admin'@'localhost' ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-configurator-cli.html
MySQL User Management The configure and reconfigure actions allow you to create and edit MySQL users as per the --add-user option: --add-user='user_name':'password'|'file_path'|'windows_security_token':host:role:authentication Only valid for the ...