Search Results
https://dev.mysql.com/doc/c-api/8.4/en/c-api-multiple-queries.html
This capability is enabled by special options that are specified either when you connect to the server with mysql_real_connect() or after connecting by calling mysql_set_server_option(). Failure to process the result this way may result in a dropped ... By default, mysql_real_query() and mysql_query() interpret their statement string argument as a single statement to be executed, and you process the result according to whether the statement produces a result set (a set of rows, as for SELECT) or an affected-rows count (as for INSERT, UPDATE, and so ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-change-user.html
bool mysql_change_user(MYSQL *mysql, const char *user, const char *password, const char *db) Description Changes the user and causes the database specified by db to become the default (current) database on the connection specified by mysql. In ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-1-0.html
Version 8.1.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 8.1.0 supersedes the 8.0 series and is recommended for use on production systems. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. (WL ...This release can be used against MySQL Server version 5.7 and ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-2-0.html
Version 9.2.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 9.2.0 supersedes 9.1 and is recommended for use on production systems. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. Installation ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-read-replicas.html
Failure Handling MySQL Router does not route connections to Read Replicas in the following situations: If there is no quorum in the Cluster. MySQL Router routing policy is affected by configuration in the following ways: If the Cluster state is ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-rejoin.html
Follow this procedure to rejoin an InnoDB Cluster to the InnoDB ClusterSet: Using MySQL Shell, connect to any member server in the primary cluster or in one of the replica clusters, using an InnoDB Cluster administrator account (created with ... If ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-innodb-cluster-limitations.html
For AdminAPI operations, you can only connect to server instances in an InnoDB Cluster using TCP/IP connections and classic MySQL protocol. The same limitations apply to connections between the server instances themselves. Note Client applications ...As InnoDB Cluster uses Group Replication, you should also be aware of its limitations, see Group Replication ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-features.html
X DevAPI enables developers to work with both relational and document data when MySQL Shell is connected to a MySQL server using the X Protocol. MySQL Shell can also connect to MySQL Servers that do not support the X Protocol using the classic MySQL ... Important MySQL Shell is updated frequently with fixes and new ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/upgrade-mysql-clusterset.html
Stop and quit MySQL Shell by issuing: \q Restart MySQL Shell from the command line, by issuing: mysqlsh Upgrade the InnoDB ClusterSet Metadata: To upgrade a ClusterSet, connect MySQL Shell's global session to your ClusterSet and use the ... To ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/myai-installation-clean-cmdline.html
--mysql-root-allow-remote-connection: The root user is allowed to connect from hosts other than localhost. --mysql-studio-port=port#: Replace the default port number (8000) with another one for MySQL Studio's server to listen for connections. The ...