PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-switch.html
The replica does not check whether the databases on the source are compatible with those on the replica; it simply begins reading and executing events from the specified coordinates in the new source's binary log. In a failover situation, all the ...
https://dev.mysql.com/doc/refman/5.7/en/reproducible-test-case.html
The binary log is saved in the MySQL database directory with the name hostname-bin.NNNNNN. FTP the tables and the binary log to our bugs database using the instructions given in Section 1.5, “How to Report Bugs or Problems”. For information ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-event.html
It requires the EVENT privilege for the database from which the event is to be shown. Database Collation is the collation of the database with which the event is associated. SHOW CREATE EVENT event_name This statement displays the CREATE EVENT ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-procedure.html
row *************************** Procedure: citycount sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Create Procedure: CREATE ... SHOW CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/show-privileges.html
row *************************** Privilege: Create Context: Databases,Tables,Indexes Comment: To create new databases and tables *************************** 4. row *************************** Privilege: Create routine Context: Databases Comment: To ... SHOW PRIVILEGES SHOW PRIVILEGES shows the list of system privileges that the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/5.7/en/tutorial.html
This chapter provides a tutorial introduction to MySQL by showing how to use the mysql client program to create and use a simple database. (If you are the administrator, you need to consult the relevant portions of this manual, such as Chapter 5, ...mysql (sometimes referred to as the “terminal monitor” or just “monitor”) is an interactive program that enables you to connect to a MySQL server, run queries, and view the ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-before-you-begin.html
The backup should include the mysql system database, which contains the MySQL system tables. To create a test instance, make a copy of your MySQL instance that contains the mysql database and other databases without the data. Review Section 2.10.2, ...
https://dev.mysql.com/doc/refman/5.7/en/user-names.html
MySQL stores accounts in the user table of the mysql system database. This means that anyone can attempt to connect to the server using any user name, so you cannot make a database secure in any way unless all MySQL accounts have passwords. Warning ...An account is defined in terms of a user name and the client host or hosts from which the user can connect to the ...
https://dev.mysql.com/doc/refman/5.7/en/windows-restrictions.html
DROP DATABASE You cannot drop a database that is in use by another session. Case-insensitive names File names are not case-sensitive on Windows, so MySQL database and table names are also not case-sensitive on Windows. The only restriction is that ... 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 ...