Server System Variables This variable defines the global automatic password expiration policy. The default default_password_lifetime  value is 0, which disables automatic password expiration. If the value of  default_password_lifetime  is a positive integer  N , it indicates the permitted password lifetime; passwords must be changed every  N  days. The global password expiration policy can be overridden as desired for individual accounts using the password expiration option of the  CREATE USER  and  ALTER USER  statements. See Section 6.2.15, “Password Management” . The default storage engine for tables. See Chapter 16,  Alternative Storage Engines . This variable sets the storage engine for permanent tables only. To set the storage engine for  TEMPORARY  tables, set the default_tmp_storage_engine  system variable. To see which storage engines are available and enabled, use the  SHOW ENGINES  statement or query the  INFORMATION_SCHEMA ENGINES  table. If you disable the default storage engine at server startup, you must set the default engine for both permanent and  TEMPORARY  tables to a different engine, or else the server does not start. • default_table_encryption • default_storage_engine • default_password_lifetime •Any statement containing a string literal of the form  _utf8mb4’ some text ’  without a  COLLATE clause. Command-Line Format --default-password-lifetime=# System Variable default_password_lifetime Scope Global Dynamic Yes SET_VAR  Hint Applies No Type Integer Default Value 0 Minimum Value 0 Maximum Value 65535 Command-Line Format --default-storage-engine=name System Variable default_storage_engine Scope Global, Session Dynamic Yes SET_VAR  Hint Applies No Type Enumeration Default Value InnoDB Command-Line Format --default-table-encryption[={OFF|ON}] Introduced 8.0.16 789