Search Results
https://dev.mysql.com/doc/refman/9.7/en/option-files.html
Many option files are plain text files, created using any text editor. A “login path” is an option group that permits only certain options: host, user, password, port and socket. It is created by the server upon execution of SET PERSIST or SET ... Most MySQL programs can read startup options from option files (sometimes called configuration ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-connecting-client.html
You can use the MySQL Administrator user that you specified when creating the DB System (see Creating a DB System) or a MySQL user account created on the DB System using CREATE USER . If you are not the MySQL Administrator and you do not have a ...
https://dev.mysql.com/doc/refman/9.7/en/alter-event.html
(See Section 15.1.15, “CREATE EVENT Statement”.) Any user can alter an event defined on a database for which that user has the EVENT privilege. The syntax for each of the DEFINER, ON SCHEDULE, ON COMPLETION, COMMENT, ENABLE / DISABLE, and DO ...
https://dev.mysql.com/doc/refman/9.7/en/environment-variables.html
USER The default user name on Windows when connecting to mysqld. On some systems, if you set MYSQL_PWD, your password is exposed to any other user who runs ps. Even on systems without such a version of ps, it is unwise to assume that there are no ...
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-5-0.html
(Bug #38068619) Microsoft Windows: It was not possible to create usernames with escaped characters, using single or double quotes, during new server configuration. Note These release notes were created with the assistance of MySQL HeatWave GenAI.
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-connections.html
These methods of connecting to a MySQL server instance create the global session, which is a connection that can be used in all of the MySQL Shell execution modes: SQL mode, JavaScript mode, and Python mode. You can also create multiple additional ... MySQL Shell can connect to MySQL Server using both X Protocol and classic MySQL ...
https://dev.mysql.com/doc/mysql-ai/9.7/en/myai-installation-clean.html
User & password: Define a user name and password for the MySQL root user. You can choose to Only allow local connections for this user (see the Warning near the beginning of Chapter 2, Installing MySQL AI). If you do not enter one, a random secret ... Installing MySQL AI requires the following steps: Install the MySQL AI ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-connecting-mysql-workbench.html
You can use the MySQL Administrator user that you specified when creating the DB System or a MySQL user account created on the DB System using CREATE USER . A MySQL user account on the MySQL DB System to connect with. Username: The user name of the ... Connecting with MySQL Workbench 5.2.3 Connecting with MySQL Workbench This topic describes how to connect to a MySQL DB System with MySQL ...
https://dev.mysql.com/doc/refman/9.7/en/implicit-commit.html
This means that a ROLLBACK from the user does not undo CREATE TABLE statements the user made during that transaction. ALTER USER, CREATE USER, DROP USER, GRANT, RENAME USER, REVOKE, SET PASSWORD. CREATE TABLE and DROP TABLE statements do not commit ... The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the current session, as if you had done a COMMIT before executing the ...
https://dev.mysql.com/doc/refman/9.7/en/mysql-cluster-limitations-syntax.html
CREATE TABLE and ALTER TABLE statements that would cause a user-partitioned NDBCLUSTER table not to meet either or both of the following two requirements are not permitted, and fail with an error: The table must have an explicit primary key. If a ...