Search Results
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-entity-framework-winform-data-source.html
If you also created Views and Stored Routines, these items will be displayed along with any tables. This tutorial describes how to create a Windows Forms Data Source from an Entity in an Entity Data Model using Microsoft Visual Studio. Creating a ...You can also find details on how to install the database on the same ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
For example, it is possible to permit an account to modify any table except those in the mysql system schema. Using Partial Revokes Partial Revokes Versus Explicit Schema Grants Disabling Partial Revokes Partial Revokes and Replication Note For ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-groups.html
The predefined groups and associated permissions are described in the following tables. Table 20-1 Table 20-2 Table 20-3 Note: The OCI user account that registered for the MySQL HeatWave on AWS service is added to the ... Groups and Permissions 20.1 ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-bootstrap.html
For the purpose of demonstrating that the server is indeed in a group and that it is able to handle load, create a table and add some content to it. mysql> CREATE DATABASE test; mysql> USE test; mysql> CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 TEXT ...
https://dev.mysql.com/doc/refman/8.4/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. In addition, you can work in SQL with results from queries on tables in the INFORMATION_SCHEMA database, which you cannot easily ...The pattern is useful for restricting statement output to matching ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-tips.html
Alternatively, create a shortcut that only sets the console font, and set the character set in the [mysql] group of your my.ini file: [mysql] default-character-set=utf8mb4 # or utf8mb3 Displaying Query Results Vertically Some query results are much ...In cases where a console is shared, this behavior may be ... This section provides information about techniques for ...
https://dev.mysql.com/doc/refman/8.4/en/security-against-attack.html
In any case, you should be very careful about creating grant table entries using host name values that contain wildcards. This is extremely dangerous, because any user with the FILE privilege is able to cause the server to create files as root (for ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-2.html
This default value change will impact the following processes: New vector store tables will be created using multilingual-e5-small by default. Retrieval augmented generation (RAG) will search tables created using the default embedding model, ...
https://dev.mysql.com/doc/refman/8.4/en/access-control.html
You cannot specify that a user has privileges to create or drop tables in a database but not to create or drop the database itself. MySQL enables the creation of accounts that permit client users to connect to the server and access data managed by ...The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, and ...
https://dev.mysql.com/doc/refman/8.4/en/account-names.html
MySQL account names consist of a user name and a host name, which enables creation of distinct accounts for users with the same user name who connect from different hosts. Account names appear in SQL statements such as CREATE USER, GRANT, and SET ...This section describes the syntax for account names, including special values and wildcard ...