MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1211 to 1220 of 1223 total results

https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html

If you start the server manually, use whatever command you normally use. Alternatively, you can log in as root, but in this case you must start mysqld with the --user=mysql option. The exact location and name of this file depend on your ... If you ...

5.1.4 Server System Variable Reference

https://dev.mysql.com/doc/refman/5.7/en/server-system-variable-reference.html

This option is dynamic, but should be set only by server. The following table lists all system variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system ...

5.1.10 Server SQL Modes

https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html

When this manual refers to “strict mode,” it means a mode with either or both STRICT_TRANS_TABLES or STRICT_ALL_TABLES enabled. This makes it easier to use MySQL in different environments and to use MySQL together with other database servers.

2.10.10 Upgrading MySQL with Directly-Downloaded RPM Packages

https://dev.mysql.com/doc/refman/5.7/en/updating-direct-rpms.html

In this case, you must restart the server manually after the upgrade. It is preferable to use the MySQL Yum repository or MySQL SLES Repository to upgrade MySQL on RPM-based platforms. For an upgrade installation using RPM packages, the MySQL ...

2.10.3 Changes in MySQL 5.7

https://dev.mysql.com/doc/refman/5.7/en/upgrading-from-previous-series.html

Before upgrading to MySQL 5.7, review the changes described in this section to identify those that apply to your current MySQL installation and applications. Sometimes this involves dumping and reloading tables, or use of a statement such as CHECK ...Changes marked as Incompatible change are incompatibilities with earlier versions of MySQL, and may require your attention before ...

23.9 Restrictions on Views

https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html

No warning results from the DROP or ALTER operation, even though this invalidates the view. The workaround to the problem is for the administrator to manually grant the SHOW VIEW privilege to users who are granted CREATE VIEW, since MySQL does not ... The maximum number of tables that can be referenced in the definition of a view is ...

1.2.1 What is MySQL?

https://dev.mysql.com/doc/refman/5.7/en/what-is-mysql.html

In this manual, “SQL-92” refers to the standard released in 1992, “SQL:1999” refers to the standard released in 1999, and “SQL:2003” refers to the current version of the standard. MySQL, the most popular Open Source SQL database ...

2.3.4.1 Extracting the Install Archive

https://dev.mysql.com/doc/refman/5.7/en/windows-extract-archive.html

To install MySQL manually, do the following: If you are upgrading from a previous version please refer to Section 2.10.8, “Upgrading MySQL on Windows”, before beginning the upgrade process. If this occurs, you can move the contents of the ...

2.3 Installing MySQL on Microsoft Windows

https://dev.mysql.com/doc/refman/5.7/en/windows-installation.html

This requirement changed over time: MySQL 5.7.37 and below requires the Microsoft Visual C++ 2013 Redistributable Package, MySQL 5.7.38 and 5.7.39 require both, and only the Microsoft Visual C++ 2019 Redistributable Package is required as of MySQL ... Important MySQL Community 5.7 Server requires the Microsoft Visual C++ 2019 Redistributable Package to run on Windows ...

2.3.4.5 Starting the Server for the First Time

https://dev.mysql.com/doc/refman/5.7/en/windows-server-first-start.html

This section gives a general overview of starting the MySQL server. The information here applies primarily if you installed MySQL using the noinstall version, or if you wish to configure and test MySQL manually rather than with the GUI tools. In ...

Displaying 1211 to 1220 of 1223 total results