MySQL Differences from Standard SQL We try to make MySQL Server follow the ANSI SQL standard and the ODBC SQL standard, but MySQL Server performs operations differently in some cases: • There are several differences between the MySQL and standard SQL privilege systems. For example, in MySQL, pri...
MySQL Extensions to Standard SQL MySQL Server supports some extensions that you probably won't find in other SQL DBMSs. Be warned that if you use them, your code won't be portable to other SQL servers. In some cases, you can write code that includes MySQL extensions, but is still portable, by usi...
MySQL Installation Layout on Microsoft Windows For MySQL 5.6 on Windows, the default installation directory is C:\Program Files\MySQL\MySQL Server 5.6. Some Windows users prefer to install in C:\...
MySQL Mailing Lists This section introduces the MySQL mailing lists and provides guidelines as to how the lists should be used. When you subscribe to a mailing list, you receive all postings to the list as email messages. You can also send your own questions and answers to the list. To subscribe...
MySQL software is Open Source. Open Source means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source co...
MySQL Standards Compliance This section describes how MySQL relates to the ANSI/ISO SQL standards. MySQL Server has many extensions to the SQL standard, and here you can find out what they are and how to use them. You can also find information about functionality missing from MySQL Server, and ho...
mysqld — The MySQL Server mysqld, also known as MySQL Server, is the main program that does most of the work in a MySQL installation. MySQL Server manages access to the MySQL data directory that contains databases and tables. The data directory is also the default location for other information s...
Network Probes The network probes monitor the transfer of information from the MySQL server and clients of all types over the network. The probes are defined as follows: net-read-start() net-read-done(status, bytes) net-write-start(bytes) net-write-done(status) • net-read-start: Triggered whe...
Obtain and Unpack the Distribution Pick the directory under which you want to unpack the distribution and change location into it. Obtain a distribution file using the instructions in Section 2.1.3, “How to Get MySQL”. Unpack the distribution into the current directory: • To unpack a compressed ...
Option Defaults, Options Expecting Values, and the = Sign By convention, long forms of options that assign a value are written with an equals (=) sign, like this: shell mysql --host=tonfisk --user=jon For options that require a value (that is, no...
