PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
In this case, the server uses only IP addresses and not host names to match connecting hosts to rows in the MySQL grant tables. The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and ...
https://dev.mysql.com/doc/refman/5.7/en/ignoring-user.html
If you get the following error, it means that when mysqld was started or when it reloaded the grant tables, it found an account in the user table that had an invalid password. Found wrong password for user 'some_user'@'some_host'; ignoring user As ...
https://dev.mysql.com/doc/refman/5.7/en/implicit-commit.html
ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before ...
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
Note The accounts that are listed in the MySQL grant tables initially have no passwords. To install MySQL from a standard source distribution: Verify that your system satisfies the tool requirements listed at Section 2.8.2, “Source Installation ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-local-connections.html
In addition to the CREATE USER statement, you can issue GRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure. The following procedure shows how to configure MySQL to ...
https://dev.mysql.com/doc/refman/5.7/en/linux-installation-rpm.html
Before MySQL 5.7.4, the accounts (including root) created in the MySQL grant tables for an RPM installation initially have no passwords; after starting the server, you should assign passwords to them using the instructions in Section 2.9, ... The ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
If a session issues a LOCK TABLES statement to acquire a lock while already holding locks, its existing locks are released implicitly before the new locks are granted. LOCK {TABLE | TABLES} tbl_name [[AS] alias] lock_type [, tbl_name [[AS] alias] ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
Also, if it is important that locks are granted in a certain order, be aware that result set order may differ depending on which execution plan the optimizer chooses. While held by one session, other sessions cannot obtain a lock of the same name.
https://dev.mysql.com/doc/refman/5.7/en/manual-info.html
Example: “To reload the grant tables, use the FLUSH PRIVILEGES statement.” Text in this style indicates input that you type in examples. This is the Reference Manual for the MySQL Database System, version 5.7, through release 5.7.44.
https://dev.mysql.com/doc/refman/5.7/en/memory-use.html
The server caches information in memory as a result of GRANT, CREATE USER, CREATE SERVER, and INSTALL PLUGIN statements. MySQL allocates buffers and caches to improve performance of database operations. The default configuration is designed to ...