Search Results
https://dev.mysql.com/doc/refman/8.4/en/server-side-help-support.html
Change location into that directory and process the file with the mysql client as follows: mysql -u root -p mysql < fill_help_tables.sql The command shown here assumes that you connect to the server using an account such as root that has privileges ... MySQL Server supports a HELP statement that returns information from the MySQL Reference Manual (see Section 15.8.3, “HELP ...
https://dev.mysql.com/doc/refman/8.4/en/set-password.html
(The plugin is given the opportunity to hash the value into the encryption format it expects. SET PASSWORD [FOR user] auth_option [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] auth_option: { = 'auth_string' | TO RANDOM } The SET ...
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
If you are using GTIDs for replication, this means that even when binary logging is later enabled again, the GTIDs written into the log from this point do not account for any transactions that occurred in the meantime, so in effect those ... SET ...
https://dev.mysql.com/doc/refman/8.4/en/setting-environment-variables.html
After modifying your PATH setting, open a new console window on Windows or log in again on Unix so that the setting goes into effect. Environment variables can be set at the command prompt to affect the current invocation of your command processor, ...
https://dev.mysql.com/doc/refman/8.4/en/show-collation.html
SHOW COLLATION [LIKE 'pattern' | WHERE expr] This statement lists collations supported by the server. By default, the output from SHOW COLLATION includes all available collations. The LIKE clause, if present, indicates which collation names to ...
https://dev.mysql.com/doc/refman/8.4/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_ENGINE_SUBSTITUTION Create Procedure: CREATE DEFINER=`me`@`localhost` PROCEDURE ...
https://dev.mysql.com/doc/refman/8.4/en/show-index.html
Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. SHOW [EXTENDED] {INDEX | INDEXES | KEYS} {FROM | IN} tbl_name [{FROM | IN} db_name] [WHERE expr] SHOW INDEX returns table ...
https://dev.mysql.com/doc/refman/8.4/en/show-profile.html
If LIMIT is given, OFFSET offset may be added to begin the output offset rows into the full set of rows. Note The SHOW PROFILE and SHOW PROFILES statements are deprecated; expect them to be removed in a future MySQL release. Use the Performance ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation-pkg.html
The pkg installer copies a suitable startup script for MySQL into /etc/init.d/mysql. You can install MySQL on Solaris using a binary package of the native Solaris PKG format instead of the binary tarball distribution. To use this package, download ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation.html
We put a great deal of effort into ensuring that our binaries are built with the best possible options for optimal performance. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation ...