PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
Passwords can be written as plain text in SQL statements such as CREATE USER and ALTER USER, so if you use these statements, they are logged in the history file. MySQL users should use the following guidelines to keep passwords secure. When you run ...The methods you can use to specify your password when you run client programs are listed here, along with an assessment of the risks of each ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
connection-start(connectionid, user, host) connection-done(status, connectionid) connection-start: Triggered after a connection and successful login/authentication have been completed by a client. Commands include operations such as the ... MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
User-Defined Variable Assignment Parameter and Local Variable Assignment System Variable Assignment SET Error Handling Multiple Variable Assignment System Variable References in Expressions User-Defined Variable Assignment User-defined variables are ...variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user account. = 'auth_string' syntax is not deprecated, but ALTER USER is the preferred ...For example: ALTER USER user IDENTIFIED BY 'auth_string'; Important Under some circumstances, SET PASSWORD may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be read by anyone having read access to that ...
https://dev.mysql.com/doc/refman/5.7/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. The default user name is ODBC on ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-privilege-distribution.html
Normally, each MySQL server's user privilege tables in the mysql database must use the MyISAM storage engine, which means that a user account and its associated privileges created on one SQL node are not available on the cluster's other SQL nodes.
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
disconnect_on_expired_password: Whether server disconnects clients with expired passwords if clients cannot handle such accounts. innodb_background_drop_list_empty: Delays table creation until background drop list is empty (debug). innodb_tmpdir: ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password.html
Note For statements that assign, modify, or generate account passwords (ALTER USER, CREATE USER, GRANT, and SET PASSWORD; statements that use PASSWORD(), the validate_password capabilities described here apply only to accounts that use an ...This ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
--keyring-migration-user, --keyring-migration-password: The account credentials to use to connect to the running server. If you invoke the migration server from a system account different from that normally used to run MySQL, it might create keyring ...The account used to connect to the running server must have the SUPER privilege required to modify ... A keyring migration copies ...
https://dev.mysql.com/doc/refman/5.7/en/mysqld-safe.html
--core-file-size=size Command-Line Format --core-file-size=size Type String Command-Line Format --core-file-size=size Type String The size of the core file that mysqld should be able to create. Linux users can use the libtcmalloc_minimal.so included ... mysqld_safe is the recommended way to start a mysqld server on ...