This parameter controls the password hashing method used by the PASSWORD function.
Init_connect = 'set autocommit=case current_user() when then 0 else 1 end’. You can also use this parameter to disable autocommit for specific user accounts, as in the following example. If you do, every time a client connects the parameter triggers the connection details to be written to the audit table. Then you set init_connect value to the trigger name. To do so, first you create an audit table and trigger. The string consists of one or more SQL statements, separated by semicolons.įor example, you can use this parameter to create a simple audit of which database users have successfully connected to the database.
There is no default value for this parameter. This parameter defines a string for the server to run for each client that connects. Parameters related to securityįollowing, I list parameters related to security, with best practice suggestions for configuring each. In addition, I discuss some useful parameters related to collation and character sets. I also discuss some of the parameters that help in managing an RDS DB instance’s operation and troubleshooting issues. In today’s post, I discuss the most important and commonly used MySQL parameters for implementing various security features in the RDS MySQL environment. In the previous blog post of this series, I discuss MySQL parameters used to optimize replication in Amazon RDS for MySQL and best practices related to them.
0 kommentar(er)
