PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/windows-upgrading.html
If the server is installed as a service, stop the service with the following command from the command prompt: C:\> SC STOP mysqld_service_name Alternatively, use NET STOP mysqld_service_name. As Administrator, run mysql_upgrade to check your tables, ... 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/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 ...
https://dev.mysql.com/doc/refman/5.7/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'; ...
https://dev.mysql.com/doc/refman/5.7/en/drop-procedure.html
(DROP FUNCTION is also used to drop loadable functions; see Section 13.7.3.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] ...
https://dev.mysql.com/doc/refman/5.7/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. Steps for a ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-change-path-proc.html
After you have installed the server, the paths cannot be altered without removing and reinstalling the server instance. Click Advanced Options to open a dialog box where you can enter alternative path names. You can change the default installation ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
However, this method of entering a password is suitable only for programs that you run interactively. Passwords can be written as plain text in SQL statements such as CREATE USER and ALTER USER, so if you use these statements, they are logged in the ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/preface.html
Conversion to other formats is allowed as long as the actual content is not altered or edited in any way. This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44. Differences between minor versions of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
You must obtain (or create) a suitable security certificate that you can use on the source, and a similar certificate (from the same certificate authority) on each replica. After the source information has been updated, start the replication process ... To use an encrypted connection for the transfer of the binary log required during replication, both the source and the replica servers must support encrypted network ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-masterbaseconfig.html
To configure a source to use binary log file position based replication, you must ensure that binary logging is enabled, and establish a unique server ID. If these options already exist, but are commented out, uncomment the options and alter them ...Each server within a replication topology must be configured with a unique server ID, which you can specify using the server_id system ...