PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
If set to 0 (the default), users are not permitted to create or alter stored functions unless they have the SUPER privilege in addition to the CREATE ROUTINE or ALTER ROUTINE privilege. When enabled, the variable has the following effects: Binary ...
https://dev.mysql.com/doc/refman/5.7/en/full-text-adding-collation.html
This section describes how to add a user-defined collation for full-text searches using the built-in full-text parser. The instructions here add a collation for a simple character set, which as discussed in Section 10.14, “Adding a Collation to a ...The sample collation is like latin1_swedish_ci but treats the '-' character as a letter rather than as a punctuation character so that it can be indexed as a word ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-actors-table.html
This enables instrumenting and historical event logging to be applied selectively per host, user, or account (user and host combination). For each new foreground thread, the Performance Schema matches the user and host for the thread against the ...
https://dev.mysql.com/doc/refman/5.7/en/connecting-disconnecting.html
Once you know the proper parameters, you should be able to connect like this: $> mysql -h host -u user -p Enter password: ******** host and user represent the host name where your MySQL server is running and the user name of your MySQL account. To ...If the server runs on a machine other than the one where you log in, you also need to specify a host ...
https://dev.mysql.com/doc/refman/5.7/en/replication-multi-source-configuration.html
If you create an account solely for the purposes of replication, that account needs only the REPLICATION SLAVE privilege. You can use the same account on all the sources, or a different account on each. A multi-source replication topology requires ...
https://dev.mysql.com/doc/refman/5.7/en/flush.html
Reloading the grant tables is necessary to enable updates to MySQL privileges and users only if you make such changes directly to the grant tables; it is not needed for account management statements such as GRANT or REVOKE, which take effect ...| ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
When running MySQL, follow these guidelines: Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql system database! This is critical. A passphrase containing multiple words is easy to create, remember, and ...
https://dev.mysql.com/doc/refman/5.7/en/testing-server.html
If you have assigned a password for the root account already, you'll also need to specify -p on the command line and enter the password when prompted. Verify that you can shut down the server (include a -p option if the root account has a password ... After the data directory is initialized and you have started the server, perform some simple tests to make sure that it works ...
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER Statement”. In the example, the trigger body is a simple ...Here is a simple example that associates a trigger with a table, to activate for INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-installation.html
As of MySQL 5.7.23, for new MySQL installations, the USER and HOST columns in the audit_log_user table used by MySQL Enterprise Audit have definitions that better correspond to the definitions of the User and Host columns in the mysql.user system ...