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/permission-optimization.html
The more complex your privilege setup, the more overhead applies to all SQL statements. For example, if you do not grant any table-level or column-level privileges, the server need not ever check the contents of the tables_priv and columns_priv ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-mysqldb.html
Data modification statements made to tables in the mysql database are replicated according to the value of binlog_format; if this value is MIXED, these statements are replicated using row-based format. However, statements that would normally update ...
https://dev.mysql.com/doc/refman/5.7/en/sql-server-administration-statements.html
...
https://dev.mysql.com/doc/refman/5.7/en/what-is.html
...
https://dev.mysql.com/doc/refman/5.7/en/problems-connecting.html
$> mysql -u root ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) It means a root password has already been assigned during installation and it has to be supplied. is not allowed to connect to this MySQL server You ...(The data directory normally is named data or var and is located under your MySQL installation directory.) Make sure that you have a file named user.MYD in the mysql database ...If the server ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
For example, anyone can use the mysql program to connect as any other person simply by invoking it as mysql -u other_user db_name if other_user has no password. Make sure that the only Unix user account with read or write privileges in the database ...It is common for client/server applications that the user can specify any user name to the client ...With some ...If the connection between the client and the server goes through an untrusted network, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
If you are starting with new servers, see Section 16.1.2.2, “Creating a User for Replication” for information about adding a specific user for replication connections and Section 16.1.2.1, “Setting the Replication Source Configuration” for ...Most of the steps that follow require the use of the MySQL root account or another MySQL user account that has the SUPER ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filter-definitions.html
Table 6.26 Event Class and Subclass Combinations Event Class Event Subclass Description connection connect Connection initiation (successful or unsuccessful) connection change_user User re-authentication with different user/password during session ...An event in the connection class indicates when a connection-related activity occurs during a session, such as a user connecting to or disconnecting from the ...It is ...
https://dev.mysql.com/doc/refman/5.7/en/account-activity-auditing.html
The User and Host column values in this row uniquely identify the account and correspond to the 'user_name'@'host_name' format in which account names are written in SQL statements. Normally, the CURRENT_USER() function can be invoked to determine ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Privileges granted for the mysql system database itself can be used to change passwords and other access privilege information: Passwords are stored encrypted, so a malicious user cannot simply read them to know the plain text password. Caution ...