PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
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/stored-routines-privileges.html
The server manipulates the mysql.proc table in response to statements that create, alter, or drop stored routines. The ALTER ROUTINE privilege is needed to alter or drop stored routines. If the automatic_sp_privileges system variable is 0, the ...
https://dev.mysql.com/doc/refman/5.7/en/events-overview.html
Whereas a trigger is a database object whose statements are executed in response to a specific type of event that occurs on a given table, a (scheduled) event is an object whose statements are executed in response to the passage of a specified time ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/account-locking.html
MySQL supports locking and unlocking user accounts using the ACCOUNT LOCK and ACCOUNT UNLOCK clauses for the CREATE USER and ALTER USER statements: When used with CREATE USER, these clauses specify the initial locking state for a new account. When ...In the absence of either clause, the account is created in an unlocked ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-system-variables.html
These conditions apply to the following system variables: group_replication_single_primary_mode group_replication_enforce_update_everywhere_checks group_replication_gtid_assignment_block_size default_table_encryption lower_case_table_names ... This ...
https://dev.mysql.com/doc/refman/5.7/en/macos-installation-pkg.html
From the Installation Type page you can either click Install to execute the installation wizard using all defaults, click Customize to alter which components to install (MySQL server, Preference Pane, Launchd Support -- all enabled by default). The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
You may also specify these parameters on the command line when invoking the executables. You may also use a separate [mysql_cluster] section in the cluster my.cnf file for settings to be read and used by all executables: # cluster-specific settings ... To support NDB Cluster, you must to update my.cnf as shown in the following ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-install-configuration.html
Important Once you have started a mysqld process with the ndbcluster and ndb-connectstring parameters in the [mysqld] and [mysql_cluster] sections of the my.cnf file as shown previously, you cannot execute any CREATE TABLE or ALTER TABLE statements ... In this section, we discuss manual configuration of an installed NDB Cluster by creating and editing configuration ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
One alternative is to use a predetermined setup type that matches your setup requirements. An instance of MySQL server using an alternative installation path, data path, or both. For instructions on how to adjust the paths, see Section 2.3.3.2, ...
https://dev.mysql.com/doc/refman/5.7/en/proxy-users.html
Use the CREATE USER statement to associate an account with an authentication plugin, or ALTER USER to change its plugin. Alternatively, for plugins that are provided proxy mapping by the server, the proxied user is determined from the PROXY ...The ...