MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 301 to 310 of 316 total results

https://dev.mysql.com/doc/refman/5.7/en/set-password.html

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 ... SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user ...

6.4.1.5 SHA-256 Pluggable Authentication

https://dev.mysql.com/doc/refman/5.7/en/sha256-pluggable-authentication.html

Important To connect to the server using an account that authenticates with the sha256_password plugin, you must use either a TLS connection or an unencrypted connection that supports password exchange using an RSA key pair, as described later in ...

2.7.1 Installing MySQL on Solaris Using a Solaris PKG

https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html

Important The installation package has a dependency on the Oracle Developer Studio 12.5 Runtime Libraries, which must be installed before you run the MySQL installation package. You can install MySQL on Solaris using a binary package of the native ...

2.7 Installing MySQL on Solaris

https://dev.mysql.com/doc/refman/5.7/en/solaris-installation.html

Important The installation packages have a dependency on the Oracle Developer Studio 12.5 Runtime Libraries, which must be installed before you run the MySQL installation package. Note MySQL 5.7 supports Solaris 11 (Update 3 and later). MySQL on ...

12.16.10 Spatial Geohash Functions

https://dev.mysql.com/doc/refman/5.7/en/spatial-geohash-functions.html

The functions in this section enable manipulation of geohash values, which provides applications the capabilities of importing and exporting geohash data, and of indexing and searching geohash values. Geohash is a system for encoding latitude and ...

2.9.2 Starting the Server

https://dev.mysql.com/doc/refman/5.7/en/starting-server.html

It is important that the MySQL server be run using an unprivileged (non-root) login account. This section describes how start the server on Unix and Unix-like systems. (For Windows, see Section 2.3.4.5, “Starting the Server for the First ...

23.7 Stored Program Binary Logging

https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html

(Binary log events differ from scheduled event stored objects.) The binary log has two important purposes: For replication, the binary log is used on source replication servers as a record of the statements to be sent to replica servers. The binary ...

12.8 String Functions and Operators

https://dev.mysql.com/doc/refman/5.7/en/string-functions.html

Important When using SOUNDEX(), you should be aware of the following limitations: This function, as currently implemented, is intended to work well with strings that are in the English language only. For functions that operate on string positions, ...

5.3 The mysql System Database

https://dev.mysql.com/doc/refman/5.7/en/system-schema.html

If you are planning an upgrade from a NDB Cluster previous release to NDB 7.5.2 or later, see Section 21.3.7, “Upgrading and Downgrading NDB Cluster”, for important information relating to this change. It contains tables that store information ...

8.11.2 Table Locking Issues

https://dev.mysql.com/doc/refman/5.7/en/table-locking.html

The automatic row-level locking makes these tables suitable for your busiest databases with your most important data, while also simplifying application logic since you do not need to lock and unlock tables. InnoDB tables use row-level locking so ...

Displaying 301 to 310 of 316 total results