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/faqs-mysql-cluster.html
MySQL NDB Cluster provides support for distributed privileges, which you can enable by following a procedure provided in the documentation; see Section 21.6.13, “Distributed Privileges Using Shared Grant Tables”, for more information. How do I ... In the following section, we answer questions that are frequently asked about NDB Cluster and the NDB storage ...
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/copying-databases.html
After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant table information. In cases where you need to transfer databases between different architectures, you can use mysqldump ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-adding-instances.html
SET SQL_LOG_BIN=0; CREATE USER rpl_user@'%' IDENTIFIED BY 'password'; GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%'; FLUSH PRIVILEGES; SET SQL_LOG_BIN=1; CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='password' \\ FOR CHANNEL ...In this ... At this point, the group has one member in it, server s1, which has some data in ...
https://dev.mysql.com/doc/refman/5.7/en/information-functions.html
One way this might occur is that there is no account listed in the grant tables for davida. It may be used to time how quickly MySQL processes the expression. The result value is 0, or NULL for inappropriate arguments such as a NULL or negative ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
It requires the INSERT privilege for the mysql.plugin system table because it adds a row to that table to register the plugin. If the server is started with the --skip-grant-tables option, plugins registered in the mysql.plugin table are not loaded ... INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server ...
https://dev.mysql.com/doc/refman/5.7/en/ipv6-support.html
MySQL account names permit IPv6 addresses to enable DBAs to specify privileges for clients that connect to the server over IPv6. IPv6 addresses can be specified in account names in statements such as CREATE USER, GRANT, and REVOKE. For example: ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. Reserved words are permitted as ...
https://dev.mysql.com/doc/refman/5.7/en/replication-encrypted-connections.html
If you want to ensure that the source only accepts replicas that connect using encrypted connections, create a replication user account on the source using the REQUIRE SSL option, then grant that user the REPLICATION SLAVE privilege. For example: ...
https://dev.mysql.com/doc/refman/5.7/en/user-resources.html
The counts also can be reset by reloading the grant tables (for example, with a FLUSH PRIVILEGES statement or a mysqladmin reload command). (See Section 6.2.3, “Grant Tables”.) Resource-use counting takes place when any account has a nonzero ...