Search Results
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-install.html
Note To avoid typing the path name of client programs when working with MySQL, add the /usr/local/mysql/bin directory to your PATH variable: $> export PATH=/usr/local/mysql/bin:$PATH Unpacking the distribution creates the directories shown in the ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-connections-in-javascript-and-python.html
You can use functions available in JavaScript and Python mode to create multiple session objects of your chosen types and assign them to variables. These session objects let you establish and manage concurrent connections to work with multiple ...
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-data-adapter.html
The application was built using the Microsoft Visual Studio to place and create the user interface controls, but the main code that uses the key classes described previously is shown in the next code example, and is portable. It is also possible to ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-data-adapter.html
The application was built using the Microsoft Visual Studio to place and create the user interface controls, but the main code that uses the key classes described previously is shown in the next code example, and is portable. It is also possible to ... Previously, when using MySqlDataReader, the connection to the database was continually maintained unless explicitly ...
https://dev.mysql.com/doc/heatwave-aws/en/running-autopilot-index-advisor-using-heatwave-console.html
Recommendation: It is either DROP or CREATE Schema Name Table Name Indexed Columns Reason: Reason for making the recommendation. Reasons for DROP include Unused Index and Duplicate Index, and reason for CREATE is Missing Index. Performance Impact: ... Running Autopilot Index Advisor 11.1 Running Autopilot Index Advisor To run Autopilot Index Advisor, the user must connect to the DB system and have the following MySQL privileges: The EXECUTE privilege on the sys ...
https://dev.mysql.com/doc/refman/8.4/en/show-events.html
Definer The account of the user who created the event, in 'user_name'@'host_name' format. Execute At For a one-time event, this is the DATETIME value specified in the AT clause of the CREATE EVENT statement used to create the event, or of the last ... SHOW EVENTS [{FROM | IN} schema_name] [LIKE 'pattern' | WHERE expr] This statement displays information about Event Manager events, which are discussed in Section 27.4, “Using the Event ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndbd.html
The ndbd binary provides the single-threaded version of the process that is used to handle all the data in tables employing the NDBCLUSTER storage engine. Options that can be used with ndbd are shown in the following table. An initial start erases ...This data node process enables a data node to accomplish distributed transaction handling, node recovery, checkpointing to disk, online backup, and related ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-objects-examples.html
Example 11.1 Creating and Registering Extension Objects - Python This example creates a function hello_world() which is made available through the user-defined MySQL Shell global object demo. The code creates a new extension object and adds the ...
https://dev.mysql.com/doc/workbench/en/wb-reverse-engineer-live.html
You can set up a new connection or select a previously created stored connection. It has a section for each object type present in the schema that you can import (tables, views, routines, and so forth). Note Importing 250 or more objects could fail ... To reverse-engineer a live database, click Database and then Reverse Engineer from the ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-programming-vb-ado.html
The following ADO (ActiveX Data Objects) example creates a table my_ado and demonstrates the use of rs.addNew, rs.delete, and rs.update. rs.Open "SELECT * FROM my_ado" rs!Name = "update" rs!txt = "updated-second-time" rs.Update rs.Close 'rs delete ...rs.Open "SELECT * FROM my_ado", conn Debug.Print rs.RecordCount rs.MoveFirst Debug.Print String(50, "-") & "Updated my_ado Result Set " & String(50, "-") For Each fld In rs.Fields Debug.Print fld.Name, Next Debug.Print Do Until rs.EOF For Each fld In rs.Fields Debug.Print fld.Value, Next rs.MoveNext Debug.Print Loop rs.Close conn.Close End ...