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/installing.html
This section describes how to secure the initial MySQL root user account, which has no password until you assign one. Also refer to the information provided in Section 2.9.4, “Securing the Initial MySQL Account”. A summary of the procedure ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-routines-table.html
DEFINER The account named in the DEFINER clause (often the user who created the routine), in 'user_name'@'host_name' format. If the routine has not been modified since its creation, this value is the same as the CREATED value. SQL_MODE The SQL mode ... The ROUTINES table provides information about stored routines (stored procedures and stored ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary tablespace. Issue a query similar to this one to view temporary tablespace metadata: mysql> SELECT * FROM INFORMATION_SCHEMA.FILES ...If no value is specified for innodb_temp_data_file_path, the default behavior is to create an auto-extending data file named ibtmp1 in the innodb_data_home_dir directory that is slightly larger than ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning.html
In addition to user data, the page format includes some internal system data that is not compressed. For example: USE test; SET GLOBAL innodb_file_per_table=1; SET GLOBAL innodb_file_format=Barracuda; SET GLOBAL autocommit=0; -- Create an ... Most ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-logging-configuration.html
The audit log plugin can also control which audited events are written to the audit log file, based on event content or the account from which events originate. For best security, write the audit log to a directory accessible only to the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
Values such as user name and host names in MySQL account names are strings rather than identifiers. The following table describes the maximum length for each type of identifier. For constraint definitions that include no constraint name, the server ...
https://dev.mysql.com/doc/refman/5.7/en/my-print-defaults.html
To see what options are present in those groups in the standard option files, invoke my_print_defaults like this: $> my_print_defaults mysqlcheck client --user=myusername --password=password --host=localhost The output consists of options, one per ... my_print_defaults displays the options that are present in option groups of option ...
https://dev.mysql.com/doc/refman/5.7/en/perl-installation.html
These tests attempt to connect to the local MySQL server using the default user name and password. (The default user name is your login name on Unix, and ODBC on Windows. The default password is “no password.”) If you cannot connect to the ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
For example, on Windows, you can set the USER variable to specify your MySQL account name. To do so, use this syntax: SET USER=your_name The syntax on Unix depends on your shell. If your shell is tcsh, add the following line to your .tcshrc file: ...
https://dev.mysql.com/doc/refman/5.7/en/windows-install-archive.html
Users who are installing from the noinstall package can use the instructions in this section to manually install MySQL.