PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/server-status-variables.html
Flush_commands The number of times the server flushes tables, whether because a user executed a FLUSH TABLES statement or due to internal server operation. Locked_connects The number of attempts to connect to locked user accounts. The MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ...Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp | +----------+ The mysql database describes user access ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that follows. row *************************** Id: 1 User: root Host: ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-enterprise-backup.html
The following instructions assume that you are already familiar with how to use MySQL Enterprise Backup to perform a backup; if that is not the case, please review the MySQL Enterprise Backup 4.1 User's Guide, especially Backing Up a Database Server. Also note the requirements described in Grant MySQL Privileges to Backup Administrator and Using MySQL Enterprise Backup with Group ...
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. As an administrator, connect to the server and create an ... The following procedure shows how to configure MySQL to permit IPv6 connections by clients that connect to the local server using the ::1 local host ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
For example: $> mysql -h host -u user -p menagerie Enter password: ******** Important menagerie in the command just shown is not your password. However, putting your password on the command line is not recommended, because doing so exposes it to ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-getting-started.html
Other platforms are not supported, and users using these MySQL Docker images on them are doing so at their own risk. Log in to the OCR with your Docker client (the docker command) using the docker login command: # docker login ... Warning The MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
MySQL performs encryption on a per-connection basis, and use of encryption for a given user can be optional or mandatory. For information on how to require users to use encrypted connections, see the discussion of the REQUIRE clause of the CREATE ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-cjk.html
Many Windows users find that a Microsoft character set, such as cp932 for Japanese Windows, is suitable. Sometimes adding or changing a <meta> tag suffices to correct the problem: for example, to insure that the user agent interprets page content as ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and Development groups in handling many inquiries about CJK (Chinese-Japanese-Korean) ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
This instance of GET DIAGNOSTICS assigns the number of available conditions and the rows-affected count to the user variables @p1 and @p2: GET DIAGNOSTICS @p1 = NUMBER, @p2 = ROW_COUNT; To obtain condition information, specify the condition number ... GET [CURRENT | STACKED] DIAGNOSTICS { statement_information_item [, statement_information_item] ...