Search Results
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/advanced.replica.html
MySQL Enterprise Backup allows you to set up a replica server (referred to as the “replica” below) by backing up the source server (referred to as the “source” below) and restoring the backup on a new replica, without having to stop the ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/backup-performance.html
When optimizing and tuning the backup procedure, measure both the raw performance (how long it takes the backup to complete) and the amount of overhead on the database server. Compressed Backup Compressing the backup data before transmitting it to ... This section describes the performance considerations for backing up a database with MySQL Enterprise ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-23.html
It is suitable for use with MySQL Server versions 8.0 and 5.7. (WL #14207) Functionality Added or Changed Important Change: A new mechanism has been introduced for users to configure how time zone conversions should occur when time instants are ...
https://dev.mysql.com/doc/refman/8.4/en/error-interfaces.html
Error information in MySQL is available in the server error log, at the SQL level, from within client programs, and at the command line. Other server error messages are intended to be sent to client programs and are available as described in Client ... Error messages can originate on the server side or the client side, and each error message includes an error code, SQLSTATE value, and message string, as described in Section B.1, “Error Message Sources and ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-real-connect.html
Client programs must successfully connect to a server before executing any other API functions that require a valid MYSQL connection handler structure. Its asynchronous counterpart is mysql_real_connect_nonblocking(), for use by applications that ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-unattended-installation-cmdline-options-agent.html
--mysqlport TCP/IP port for the monitored MySQL server --mysqlsocket Unix socket/Named pipe for the monitored MySQL server --mysqluser MySQL Administrative username for the monitored MySQL server --optionfile Installation option file ... To view all ...
https://dev.mysql.com/doc/refman/8.4/en/grant.html
Normally, a database administrator first uses CREATE USER to create an account and define its nonprivilege characteristics such as its password, whether it uses secure connections, and limits on access to server resources, then uses GRANT to define ...[WITH GRANT OPTION] [AS user [WITH ROLE DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ...
https://dev.mysql.com/doc/refman/8.4/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 6.5.4, “mysqldump — A Database Backup Program”). You should not ...The following instructions describe how to do this for a source and for a ...
https://dev.mysql.com/doc/workbench/en/wb-migration-database-mssql-drivers-windows.html
Microsoft Windows XP and newer includes at least one ODBC driver for Microsoft SQL Server, so additional actions are likely not required on your system. Multiple SQL Server driver options exist, as described in this section. Figure 10.39 Windows ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-ssl-wizard.html
This wizard helps create SSL certificates for both MySQL clients and MySQL servers. Start the SSL wizard from the SSL tab of a MySQL server connection. In this simple example, MySQL Workbench is installed on the same host as the MySQL Server, and ...Connections in MySQL Workbench are updated with the certificates by the ...