Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-stored-proc.html
A stored procedure is a set of SQL statements that is stored in the server. For example, to create a stored procedure named add_emp, use the CommandText property with the default command type (SQL text commands) to execute each individual SQL ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-examples-walkthrough.html
On system ALPHA (the MySQL server) follow these steps: Start the MySQL server. On system BETA (the Connector/ODBC client), follow these steps: Configure a Connector/ODBC DSN using parameters that match the server, database and authentication ... A ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-walkthrough.html
On system ALPHA (the MySQL server) follow these steps: Start the MySQL server. On system BETA (the Connector/ODBC client), follow these steps: Configure a Connector/ODBC DSN using parameters that match the server, database and authentication ... A ...
https://dev.mysql.com/doc/refman/9.7/en/charset-database.html
If there is no default database, the variables have the same value as the corresponding server-level system variables, character_set_server and collation_server. For LOAD DATA statements that include no CHARACTER SET clause, the server uses the ...
https://dev.mysql.com/doc/refman/9.7/en/postinstallation.html
Optionally, arrange for the server to start and stop automatically when your system starts and stops. Installation on Linux using a server RPM or Debian distribution from Oracle. Installation using the native packaging system on many platforms, ...
https://dev.mysql.com/doc/refman/9.7/en/backup-and-recovery.html
Backups are also essential as a safeguard before upgrading a MySQL installation, and they can be used to transfer a MySQL installation to another system or to set up replica servers. It is important to back up your databases so that you can recover ...MySQL offers a variety of backup strategies from which you can choose the methods that best suit the requirements for your ...
https://dev.mysql.com/doc/refman/9.7/en/group-replication-fault-tolerance.html
As such if one server fails, there are still two servers to form a majority (two out of three) and allow the system to continue to make decisions automatically and progress. MySQL Group Replication builds on an implementation of the Paxos ...Group ...
https://dev.mysql.com/doc/refman/9.7/en/multiple-data-directories.html
Warning Normally, you should never have two servers that update data in the same databases. This may lead to unpleasant surprises if your operating system does not support fault-free system locking. If (despite this warning) you run multiple servers ... Each MySQL Instance on a machine should have its own data ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor.html
Each connection made to the MySQL server is represented by a separate connection tab. A server can be active or inactive when the connection tab for it is opened. The SQL query tab is a secondary tab that opens by default when you make a connection ... The visual SQL editor consists of a set of specialized editors (query, schema, table, and so on) and three panels: sidebar, secondary sidebar, and output ...
https://dev.mysql.com/doc/connectors/en/connector-j-connp-props-connection.html
connectionAttributes A comma-delimited list of user-defined "key:value" pairs, in addition to standard MySQL-defined "key:value" pairs, to be passed to MySQL Server for display as connection attributes in the 'PERFORMANCE_SCHEMA' tables ...Setting ...