Search Results
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-mysqlscript.html
Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE TestTable (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100)); The main method of the MySqlScript class is the Execute method.
https://dev.mysql.com/doc/connectors/en/connector-net-tutorials-sql-command.html
After it has been created, there are three main methods of interest that you can call: ExecuteReader to query the database. Results are usually returned in a MySqlDataReader object, created by ExecuteReader. After the MySqlCommand object is created, ... When a connection has been established with the MySQL database, the next step enables you to perform database ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-entity-framework-databinding-linq-entities.html
In this tutorial you create an ASP.NET web page that binds LINQ queries to entities using the Entity Framework mapping with MySQL Connector/NET. Creating an ASP.NET Website In this part of the tutorial, you create an ASP.NET website. The user's ...
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-mysqlscript.html
Commands for the mysql Command-Line Client are given here: CREATE DATABASE TestDB; USE TestDB; CREATE TABLE TestTable (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(100)); The main method of the MySqlScript class is the Execute method.
https://dev.mysql.com/doc/connector-net/en/connector-net-tutorials-sql-command.html
After it has been created, there are three main methods of interest that you can call: ExecuteReader to query the database. Results are usually returned in a MySqlDataReader object, created by ExecuteReader. After the MySqlCommand object is created, ... When a connection has been established with the MySQL database, the next step enables you to perform database ...
https://dev.mysql.com/doc/refman/8.4/en/extensions-to-ansi.html
The KEY_BLOCK_SIZE clause in the following comment is executed only by servers from MySQL 5.1.10 or higher: CREATE TABLE t1(a INT, KEY (a)) /*!50110 KEY_BLOCK_SIZE=1024 */; The following descriptions list MySQL extensions, organized by category.
https://dev.mysql.com/doc/internals/en/determining-authentication-method.html
Method used for authentication is tied to the user account and stored in the plugin column of mysql.user table. Client informs about the user account it wants to log into in the Handshake Response Packet. Only then server can look-up the mysql.user ...However, to save some round-trips, server and client start authentication exchange already in the initial handshake using an optimistic guess of the authentication method to be ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-host-name-identity-verification.html
--user specifies the user name of the MySQL account to use for connecting to the server. -p specifies the password of the MySQL account used for connecting to the server. Enabling Host Name Identity Verification 5.5 Enabling Host Name Identity ...
https://dev.mysql.com/doc/refman/8.4/en/invoking-programs.html
They indicate the host where the MySQL server is running, and the user name and password of your MySQL account. $> mysql --user=root test $> mysqladmin extended-status variables $> mysqlshow --help $> mysqldump -u root personnel Arguments that begin ... To invoke a MySQL program from the command line (that is, from your shell or command prompt), enter the program name followed by any options or other arguments needed to instruct the program what you want it to ...
https://dev.mysql.com/doc/refman/8.4/en/windows-start-command-line.html
You can stop the MySQL server by executing this command: C:\> "C:\Program Files\MySQL\MySQL Server 8.4\bin\mysqladmin" -u root shutdown Note If the MySQL root user account has a password, you need to invoke mysqladmin with the -p option and supply ...Note Users in the MySQL grant system are wholly independent from any operating system users under Microsoft ...