Search Results
https://dev.mysql.com/doc/refman/9.7/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. MySQL uses security based on Access Control Lists (ACLs) for all connections, queries, and other operations that users ...In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of ...
https://dev.mysql.com/doc/refman/9.7/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/9.7/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. MySQL reserves one extra connection to be used by accounts that have the CONNECTION_ADMIN privilege (or the ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/windows-server-first-start.html
They can use TCP/IP, or they can use a named pipe if the server supports named-pipe connections. MySQL for Windows also supports shared-memory connections if the server is started with the shared_memory system variable enabled. Clients can connect ... This section gives a general overview of starting the MySQL ...
https://dev.mysql.com/doc/c-api/9.7/en/c-api-optional-metadata.html
Clients can indicate on a per-connection basis that result set metadata is optional and that the client will indicate to the server whether to return it. There are two ways for a client to indicate that result set metadata is optional for a ... When ...
https://dev.mysql.com/doc/c-api/9.7/en/mysql-ping.html
int mysql_ping(MYSQL *mysql) Description Checks whether the connection to the server is working. If the connection has gone down and auto-reconnect is enabled an attempt to reconnect is made. If the connection is down and auto-reconnect is ...
https://dev.mysql.com/doc/relnotes/mysql-router/9.7/en/news-9-2-0.html
Functionality Added or Changed Bugs Fixed Functionality Added or Changed Added a new close_connection_after_refresh metadata_cache option to control whether a connection remains open for future metadata refresh operations. If set to 0 (default), ...
https://dev.mysql.com/doc/workbench/en/wb-eer-color-key.html
Color connection lines within EER diagrams provide quick visual information about how the tables in your model relate. Existing connection lines are highlighted when you use a pointer device to hover on different database objects. Table 9.1 MySQL ...The following table defines the meaning of each color and indicates how you can open the underlying table information from your ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
Figure 9.49 Reverse Engineer Database Wizard The first step of the wizard enables you to set up a connection to the live database you intend to reverse-engineer. You can set up a new connection or select a previously created stored connection. To ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-toolbar.html
The connection to the database server is not restarted and all open transactions remain open. Commit the current transaction: All query tabs in the same connection share the same transactions. Rollback the current transaction: All query tabs in the ... The SQL query toolbar provides actions that enable you to create and manage ...