Search Results
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-authentication.html
Connector/ODBC supports different authentication methods, including: Standard authentication using a MySQL username and password, such as caching_sha2_password. OpenID Connect is supported with the authentication_openid_connect_client client-side ...Support added in Connector/ODBC 8.0.26 for Linux clients, and 8.0.27 for Windows ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-configuration-dsn-macos.html
For example: $> myodbc-installer -a -s -t"DSN=mydb;DRIVER=MySQL ODBC 9.3 Driver;SERVER=mysql;USER=username;PASSWORD=pass" To use ODBC Administrator: Warning For correct operation of ODBC Administrator, ensure that the /Library/ODBC/odbc.ini file ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-tools-with-wordexcel.html
You can use Microsoft Word and Microsoft Excel to access information from a MySQL database using Connector/ODBC. Within Microsoft Excel, you can execute queries on your MySQL server and import the data directly into an Excel Worksheet, presenting ...Within Microsoft Word, this facility is most useful when importing data for mailmerge, or for tables and data to be included in ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-support-community.html
You may also find help from other users in the other MySQL Forums, located at http://forums.mysql.com. Community support from experienced users is also available through the ODBC Forum.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-query.html
Syntax: cnx.cmd_query(statement) This method sends the given statement to the MySQL server and returns a result. The returned dictionary contains information depending on what kind of query was executed. If the query is a SELECT statement, the ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-quit.html
This method sends a QUIT command to the MySQL server, closing the current connection. Since there is no response from the MySQL server, the packet that was sent is returned.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-cmd-refresh.html
Example: >>> from mysql.connector import RefreshOption >>> refresh = RefreshOption.LOG | RefreshOption.THREADS >>> cnx.cmd_refresh(refresh) . This method flushes tables or caches, or resets replication server information. The options argument should ...
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-connected.html
This read-only property checks whether the connection to MySQL is available using the ping() method; but unlike ping(), connected returns True when the connection is available, and False otherwise.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-database.html
>>> cnx.database = 'test' >>> cnx.database = 'mysql' >>> cnx.database u'mysql' Returns a string. This property sets the current (default) database by executing a USE statement. The property can also be used to retrieve the current database name.
https://dev.mysql.com/doc/connectors/en/connector-python-api-mysqlconnection-is-connected.html
This method checks whether the connection to MySQL is available using the ping() method, but unlike ping(), is_connected() returns True when the connection is available, False otherwise.