Search Results
https://dev.mysql.com/doc/refman/8.4/en/create-table-check-constraints.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ... CREATE ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-generated-columns.html
A function is deterministic if, given the same data in tables, multiple invocations produce the same result, independently of the connected user. Examples of functions that are nondeterministic and fail this definition: CONNECTION_ID(), ...Values of ...
https://dev.mysql.com/doc/refman/8.4/en/creating-database.html
Just specify its name after any connection parameters that you might need to provide. If the administrator creates your database for you when setting up your permissions, you can begin using it. Otherwise, you need to create it yourself: mysql> ...
https://dev.mysql.com/doc/refman/8.4/en/creating-rsa-files-using-openssl.html
This section describes how to use the openssl command to set up the RSA key files that enable MySQL to support secure password exchange over unencrypted connections for accounts authenticated by the sha256_password (deprecated) and ...Note An ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-client.html
If you have problems with your own client code, you should attempt to connect to the server and run your query using a client that is known to work. To be able to debug a MySQL client with the integrated debug package, you should configure MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/debugging-server.html
It may be a good idea to run mysqladmin -i10 processlist status in some window if you are experiencing performance problems or problems when new clients cannot connect. If you are using some functionality that is very new in MySQL, you can try to ...
https://dev.mysql.com/doc/refman/8.4/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...
https://dev.mysql.com/doc/refman/8.4/en/entering-queries.html
Make sure that you are connected to the server, as discussed in the previous section. Doing so does not in itself select any database to work with, but that is okay. At this point, it is more important to find out a little about how to issue ...
https://dev.mysql.com/doc/refman/8.4/en/error-interfaces.html
For example, (using the mysql client), a failure to connect to the server might result in this message: $> mysql -h no-such-host ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (-2) Command-Line Error Message Interface The perror ...