PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/old-native-pluggable-authentication.html
This section describes mysql_old_password, which implements authentication against the mysql.user system table using the older (pre-4.1) native password hashing method. For account upgrade instructions, see Section 6.4.1.3, “Migrating Away from ...
https://dev.mysql.com/doc/refman/5.7/en/reset-slave.html
RESET SLAVE does not change any replication connection parameters such as the source's host name and port, or the replication user account name and its password. Issuing a RESET SLAVE ALL statement without a FOR CHANNEL channel clause when multiple ... RESET SLAVE [ALL] [channel_option] channel_option: FOR CHANNEL channel RESET SLAVE makes the replica forget its replication position in the source's binary ...
https://dev.mysql.com/doc/refman/5.7/en/set-sql-log-bin.html
The session user must have privileges sufficient to set restricted session variables. 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 ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Master_User The user name of the account used to connect to the source. SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential parameters of the replica threads. If you issue this statement using the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/sys-io-by-thread-by-latency.html
The io_by_thread_by_latency and x$io_by_thread_by_latency views have these columns: user For foreground threads, the account associated with the thread. These views summarize I/O consumers to display time waiting for I/O, grouped by thread.
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
The extra connection is reserved for use by accounts that have the SUPER privilege. By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the ... If clients encounter Too many connections errors when attempting to connect to the mysqld server, all available connections are in use by other ...
https://dev.mysql.com/doc/refman/5.7/en/upgrading.html
Note In the following discussion, MySQL commands that must be run using a MySQL account with administrative privileges include -u root on the command line to specify the MySQL root user. This section describes the steps to upgrade a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
For example, before upgrading from MySQL 5.6 to 5.7, use mysqladmin from MySQL 5.6 as follows: C:\> "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, invoke mysqladmin with ... There are two approaches for upgrading MySQL on Windows: Using MySQL Installer Using the Windows ZIP archive distribution The approach you select depends on how the existing installation was ...
https://dev.mysql.com/doc/refman/5.7/en/activestate-perl.html
If you cannot get the procedure to work, you should install the ODBC driver instead and connect to the MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn",$user,$password) || die "Got error $DBI::errstr when connecting to $dsn\n"; ... On Windows, you should do the following to install the MySQL DBD module with ActiveState Perl: Get ActiveState Perl from http://www.activestate.com/Products/ActivePerl/ and install ...
https://dev.mysql.com/doc/refman/5.7/en/adding-collation-choosing-id.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. To add a collation, you must choose an ID value that is not currently used. The collation ID that you choose appears in these contexts: The ID column of the Information ...