Search Results
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
As an alternative to proxy users, DBAs may find that roles provide a suitable way to map users onto specific sets of named privileges. Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its ...The plugin that authenticates a given connection may request that the connecting (external) user be treated as a different user for privilege-checking ...
https://dev.mysql.com/doc/refman/8.4/en/security-guidelines.html
In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of service. When running MySQL, follow ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-create-script.html
Tables, views, routines, routine groups, indexes, keys, and constraints can be imported from an SQL script file. You will need the original script to create an ALTER script. To reverse-engineer a database using a create script, do one of the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-security-category.html
Table 7.31 Security Configuration Metrics NameDescriptionActivate All Roles On Login Enabled Whether to enable automatic activation of all granted roles when users log in to the server. Automatic Sp Privileges Enabled When this variable has a value ... Lists the Security configuration metrics and provides a brief description of ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-binarylogs-summary-category.html
Table 6.3 Binary Logs Summary Metrics NameDescriptionCount Number of binlog files. It also enables you to review all alterations made to your database. It also enables you to review all alterations made to your database. Lists the Binary Logs ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. When validate_password.check_user_name is enabled, it has these effects: Checking occurs in all contexts for which ... This ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica.html
For example: mysql> ALTER EVENT mysql.event DISABLE ON REPLICA; Remove the line skip-replica-start and event_scheduler=off entries you added to the my.cnf file of the replica in step 2. For example: mysql> ALTER EVENT mysql.event DISABLE ON REPLICA; ... MySQL Enterprise Backup allows you to set up a replica server (referred to as the “replica” below) by backing up the source server (referred to as the “source” below) and restoring the backup on a new replica, without having to stop the ...
https://dev.mysql.com/doc/workbench/en/wb-views-overview-scripts.html
If you created your project from an SQL script and plan to create an ALTER script, you may want to add the original script here, because it will be needed to create an ALTER script. Use the SQL Scripts panel to attach SQL scripts to the model for ...
https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-results.html
The import icon opens the Table Data Import dialog from which you can select a data file and other options, such as the destination table. Export or Import data directly from or into the result set. The export and import operations shown in this ...
https://dev.mysql.com/doc/workbench/en/wb-connection-properties.html
This is used, for example, when drawing MyISAM tables with a visual relationship, but with no foreign keys. To make the relationship visible again, you must expand the table object relating to the relationship in the Layers palette and select the ...