PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
You can do so by creating tables to hold your data and loading them with the desired information. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/5.7/en/connection-control-plugin-installation.html
For this purpose, a failed connection attempt is one for which the client user and host match a known MySQL account but the provided credentials are incorrect, or do not match any known account. Determination of the applicable user name and host ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
(The server writes the random password to the error log.) Installation creates no anonymous-user accounts. Instead, establish such properties at account-creation time with CREATE USER or modify them afterward with ALTER USER. The server now requires ...To enable MySQL 5.7 clients to connect to 8.0 servers using accounts that authenticate using caching_sha2_password, the MySQL 5.7 client library and client programs support the caching_sha2_password client-side authentication plugin as of MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/changing-mysql-user.html
On Windows, you can run the server as a Windows service using a normal user account. For example: [mysqld] user=user_name If your Unix machine itself is not secured, you should assign passwords to the MySQL root account in the grant tables. On ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-ndb-comment-options.html
NDB_COLUMN Options In NDB Cluster, a column comment in a CREATE TABLE or ALTER TABLE statement can also be used to specify an NDB_COLUMN option. NDB_TABLE Options For an NDB Cluster table, the table comment in a CREATE TABLE or ALTER TABLE statement ... NDB_COLUMN Options NDB_TABLE Options It is possible to set a number of options specific to NDB Cluster in the table comment or column comments of an NDB ...
https://dev.mysql.com/doc/refman/5.7/en/using-innodb-tables.html
InnoDB tables are created using the CREATE TABLE statement; for example: CREATE TABLE t1 (a INT, b CHAR (20), PRIMARY KEY (a)) ENGINE=InnoDB; The ENGINE=InnoDB clause is not required when InnoDB is defined as the default storage engine, which it is ....frm Files MySQL stores data dictionary information for tables in .frm files in database ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-tables.html
The accounts table has USER and HOST columns to track connections per user and host combination. The Performance Schema tracks the connections as follows: The accounts table has four rows, for the user1/hosta, user1/hostb, user2/hosta, and ... When ...Each connection table has CURRENT_CONNECTIONS and TOTAL_CONNECTIONS columns to track the current and total number of connections per “tracking value” on which its statistics are ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
If you start the server as root without using --user=mysql, the server may create root-owned files in the data directory, such as log files, and these may cause permission-related problems for future server startups. This enables anyone to connect ...For instructions on assigning a password, see Section 2.9.4, “Securing the Initial MySQL ... If you have never assigned ...
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
Either create the account if it does not exist (see Create a mysql User and Group), or substitute the name of a different existing login account that you plan to use for running the server. The server creates a 'root'@'localhost' superuser account ...Data Directory Initialization Overview Data Directory Initialization Procedure Server Actions During Data Directory Initialization Post-Initialization root Password Assignment Data Directory Initialization Overview In the examples shown here, the server is intended to run under the user ID of the mysql login ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
You should also delete the anonymous user account that is installed by default. First and foremost, you should always run a MySQL Server as the mysql operating system user; this is no different from running MySQL in a standard (non-Cluster) ... In ...