Search Results
https://dev.mysql.com/doc/refman/8.4/en/creating-accounts.html
To manage MySQL accounts, use the SQL statements intended for that purpose: CREATE USER and DROP USER create and remove accounts. These examples assume that the MySQL root account has the CREATE USER privilege and all privileges that it grants to ...Another option for creating accounts is to use the GUI tool MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-howto-repuser.html
Although you do not have to create an account specifically for replication, you should be aware that the replication user name and password are stored in plain text in the replica's connection metadata repository mysql.slave_master_info (see Section ... Each replica connects to the source using a MySQL user name and password, so there must be a user account on the source that the replica can use to ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-extension-objects-register.html
The name must be unique in your MySQL Shell installation, so it must not be the name of a built-in MySQL Shell global object (for example, db, dba, cluster, session, shell, util) and it must not be a name you have already used for a user-defined ...
https://dev.mysql.com/doc/refman/8.4/en/create-table-foreign-keys.html
A duplicate symbol results in an error similar to: ERROR 1005 (HY000): Can't create table 'test.fk1' (errno: 121). NDB Cluster stores foreign key names using the same lettercase with which they are created. Creating a foreign key constraint requires ... MySQL supports foreign keys, which permit cross-referencing related data across tables, and foreign key constraints, which help keep the related data ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-backup-using-management-client.html
START BACKUP supports the creation of encrypted backups using ENCRYPT PASSWORD=password. Note NDB Cluster never saves the user-furnished password or generated encryption key. In this case, the management client prompts the user for a password.
https://dev.mysql.com/doc/workbench/en/wb-tutorial-plugins-php-pdo.html
$e->getMessage(); } """ % params mforms.Utilities.set_clipboard_text(text) mforms.App.get().set_status_text("Copied PHP code to clipboard") return 0 This simple plugin generates PHP code to create a MySQL connection using PHP's PDO_MySQL extension.
https://dev.mysql.com/doc/connectors/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. You might typically work with tables that are already set up, rather than creating them within your own application. The exception is temporary tables, which can ... All DDL (Data Definition Language) statements are executed using a handle structure known as a ...
https://dev.mysql.com/doc/connector-python/en/connector-python-example-ddl.html
The following examples show how to create the tables of the Employee Sample Database. You might typically work with tables that are already set up, rather than creating them within your own application. The exception is temporary tables, which can ... All DDL (Data Definition Language) statements are executed using a handle structure known as a ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sessions-after.html
For example: mysql-js> \connect --mysqlx user@localhost:33060 The shell.connect() method can be used in MySQL Shell as an alternative to the \connect command to create the session global object. If you started MySQL Shell without connecting to a ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/mysql-shell-sessions-startup.html
When you start MySQL Shell from the command line, you can specify connection parameters using separate command options for each value, such as the user name, host, and port. When you use this connection method, you can add one of these options to ...For instructions and examples to start MySQL Shell and connect to a MySQL Server instance in this way, see Section 4.3.1, “Connecting using Individual ...