MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 101 to 109 of 109 total results

« Previous
9
10
11
Next »

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

Start the MySQL server with the init_file system variable set to name the file (notice that the backslash in the option value is doubled): C:\> cd "C:\Program Files\MySQL\MySQL Server 8.0\bin" C:\> mysqld --init-file=C:\\mysql-init.txt If you ... If ...

8.1.7 Client Programming Security Guidelines

https://dev.mysql.com/doc/refman/8.0/en/secure-client-programming.html

Try to enter single and double quotation marks (' and ") in all of your Web forms. Client applications that access MySQL should use the following guidelines to avoid interpreting external data incorrectly or exposing sensitive information. Handle ...

7.1.10 Server Status Variables

https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html

If the CRL file is large, the server allocates a large chunk of memory (ten times the file size), which is doubled while the new instance is being loaded and the old one has not yet been released. Innodb_dblwr_pages_written The number of pages that ... The MySQL server maintains many status variables that provide information about its ...

14.16.13 Spatial Convenience Functions

https://dev.mysql.com/doc/refman/8.0/en/spatial-convenience-functions.html

If the distance exceeds the range of a double-precision number, an ER_STD_OVERFLOW_ERROR error occurs. The functions in this section provide convenience operations on geometry values. Unless otherwise specified, functions in this section handle ...

14.8.1 String Comparison Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html

If you want a LIKE string to contain a literal \, you must double it. Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a ...

14.8 String Functions and Operators

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html

For functions that operate on string positions, the first position is numbered 1. For functions that take length arguments, noninteger arguments are rounded to the nearest integer. ASCII(str) Returns the numeric value of the leftmost character of ...

2.3.4.2 Creating an Option File

https://dev.mysql.com/doc/refman/8.0/en/windows-create-option-file.html

If you do use backslashes, double them: [mysqld] # set basedir to your installation path basedir=E:\\mysql # set datadir to the location of your data directory datadir=E:\\mydata\\data The rules for use of backslash in option file values are given ... If you need to specify startup options when you run the server, you can indicate them on the command line or place them in an option ...

2.3.7 Windows Platform Restrictions

https://dev.mysql.com/doc/refman/8.0/en/windows-restrictions.html

The following restrictions apply to use of MySQL on the Windows platform: Process memory On Windows 32-bit platforms, it is not possible by default to use more than 2GB of RAM within a single process, including MySQL. This is because the physical ...

2.3.5 Troubleshooting a Microsoft Windows MySQL Server Installation

https://dev.mysql.com/doc/refman/8.0/en/windows-troubleshooting.html

If you do use backslashes, double them: [mysqld] # set basedir to your installation path basedir=C:\\Program Files\\MySQL\\MySQL Server 8.0 # set datadir to the location of your data directory datadir=D:\\MySQLdata The rules for use of backslash in ... When installing and running MySQL for the first time, you may encounter certain errors that prevent the MySQL server from ...