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/creating-ssl-rsa-files.html
The following discussion describes how to create the files required for SSL and RSA support in MySQL. File creation can be performed using facilities provided by MySQL itself, or by invoking the openssl command directly. RSA key files enable MySQL ...SSL certificate and key files enable MySQL to support encrypted connections using ...
https://dev.mysql.com/doc/refman/5.7/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-create-alter-drop-server.html
The statements CREATE SERVER, ALTER SERVER, and DROP SERVER are not written to the binary log, regardless of the binary logging format that is in use.
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-workflow.html
It can optionally create MySQL server user accounts with configurable permissions based on general roles, such as DB Administrator, DB Designer, and Backup Admin. The MySQL user accounts that you create in the next step will use the authentication ...It optionally creates a Windows user named MysqlSys with limited privileges, which would then run the MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-authentication.html
When a client connects to the MySQL server, the server uses the user name provided by the client and the client host to select the appropriate account row from the mysql.user system table. Use cases for this plugin include proxied accounts that ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
CREATE USER Enables use of the ALTER USER, CREATE USER, DROP USER, RENAME USER, and REVOKE ALL PRIVILEGES statements. (This implies the user can read any file in any database directory, because the server can access any of those files.) Enables ...
https://dev.mysql.com/doc/refman/5.7/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replication metadata repositories (see Section 16.2.4.2, “Replication ...
https://dev.mysql.com/doc/refman/5.7/en/xml-functions.html
You may discuss these, ask questions about them, and obtain help from other users with them in the MySQL XML User Forum. XPath expressions used with these functions support user variables and local stored program variables. User variables are weakly ... Table 12.16 XML Functions Name Description ExtractValue() Extract a value from an XML string using XPath notation UpdateXML() Return replaced XML fragment This section discusses XML and related functionality in ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
The CREATE USER and ALTER USER statements also support resource control options for limiting the extent of server use permitted to an account. If all accounts have a password, connecting using another user's account becomes much more difficult. Make ...To make a MySQL system secure, you should strongly consider the following suggestions: Require all MySQL accounts to have a ...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
is not allowed to connect to this MySQL server You can fix this by setting up an account for the combination of client host name and user name that you are using when trying to connect. (The data directory normally is named data or var and is ... If ...