MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1661 to 1670 of 1675 total results

15.7.7.9 SHOW CREATE PROCEDURE Statement

https://dev.mysql.com/doc/refman/8.0/en/show-create-procedure.html

To use either statement, you must be the user named as the routine DEFINER, have the SHOW_ROUTINE privilege, have the SELECT privilege at the global level, or have the CREATE ROUTINE, ALTER ROUTINE, or EXECUTE privilege granted at a scope that ...

1.6.3.3 Enforced Constraints on Invalid Data

https://dev.mysql.com/doc/refman/8.0/en/constraint-invalid-data.html

It is possible to alter this behavior to be more forgiving of invalid values, such that the server coerces them to valid ones for data entry, by disabling strict SQL mode (see Section 7.1.11, “Server SQL Modes”), but this is not recommended. By ...

15.7.1.2 CREATE ROLE Statement

https://dev.mysql.com/doc/refman/8.0/en/create-role.html

(These role attributes can be changed later with the ALTER USER statement, by users who have the global CREATE USER privilege.) CREATE ROLE either succeeds for all named roles or rolls back and has no effect if any error occurs. CREATE ROLE [IF NOT ...

13.2.8 Conversion Between Date and Time Types

https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-conversion.html

However, there may be some alteration of the value or loss of information. To some extent, you can convert a value from one temporal type to another. In all cases, conversion between temporal types is subject to the range of valid values for the ...

2.5.6.1 Basic Steps for MySQL Server Deployment with Docker

https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-getting-started.html

Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; ...

15.1.29 DROP PROCEDURE and DROP FUNCTION Statements

https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html

(DROP FUNCTION is also used to drop loadable functions; see Section 15.7.4.2, “DROP FUNCTION Statement for Loadable Functions”.) To drop a stored routine, you must have the ALTER ROUTINE privilege for it. DROP {PROCEDURE | FUNCTION} [IF EXISTS] ...

8.8 FIPS Support

https://dev.mysql.com/doc/refman/8.0/en/fips-mode.html

To be considered acceptable for such Federal use, a cryptographic module must be certified for FIPS 140-2. In particular, MD5 is restricted, so trying to establish an encrypted connection using an encryption cipher such as RC4-MD5 does not work. But ... MySQL supports FIPS mode when a supported OpenSSL library and FIPS Object Module are available on the host ...

2.5.1 Installing MySQL on Linux Using the MySQL Yum Repository

https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html

Before You Start As a popular, open-source software, MySQL, in its original or re-packaged form, is widely installed on many systems from various sources, including different software download sites, software repositories, and so on. The following ...

2.4.1 General Notes on Installing MySQL on macOS

https://dev.mysql.com/doc/refman/8.0/en/macos-installation-notes.html

Launchd: A launchd daemon is installed that alters MySQL configuration options. You need either to copy the data directory from the old version to the new version, or to specify an alternative datadir value to set location of the data directory.

25.3.1.5 Deploying NDB Cluster with Docker Containers

https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-docker.html

Downloading a MySQL NDB Cluster Docker Image Downloading the Docker image in a separate step is not strictly necessary; however, performing this step before you create your Docker containers ensures your local image is up to date. To download the ...

Displaying 1661 to 1670 of 1675 total results