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/show-databases.html
Caution Because a global privilege is considered a privilege for all databases, any global privilege enables a user to see all database names with SHOW DATABASES or by examining the INFORMATION_SCHEMA SCHEMATA table. You see only those databases for ... SHOW {DATABASES | SCHEMAS} [LIKE 'pattern' | WHERE expr] SHOW DATABASES lists the databases on the MySQL server ...The WHERE clause can ...
https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html
You might have to run commands as the MySQL root user on the new machine until you have the mysql database in place. After you import the mysql database on the new machine, execute mysqladmin flush-privileges so that the server reloads the grant ...
https://dev.mysql.com/doc/refman/5.7/en/drop-database.html
Important When a database is dropped, privileges granted specifically for the database are not automatically dropped. If the default database is dropped, the default database is unset (the DATABASE() function returns NULL). DROP {DATABASE | SCHEMA} ...TEMPORARY tables are automatically removed when the session that created them ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-database-objects.html
When using the NDB storage engine, the maximum allowed length both for database names and for table names is 63 characters. In addition, the maximum offset for a fixed-width column of an NDB table is 8188 bytes; attempting to create a table that ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-database.html
row *************************** Database: test Create Database: CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET latin1 */ mysql> SHOW CREATE SCHEMA test\G *************************** 1. row *************************** Database: test Create ...
https://dev.mysql.com/doc/refman/5.7/en/symbolic-links-to-databases.html
Suppose that you have a database db1 under the MySQL data directory, and then make a symlink db2 that points to db1: $> cd /path/to/datadir $> ln -s db1 db2 The result is that, for any table tbl_a in db1, there also appears to be a table tbl_a in ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-database-structure.html
In your role as a database designer, look for the most efficient way to organize your schemas, tables, and columns. Starting with an efficient database design makes it easier for team members to write high-performing application code, and makes the ...As when tuning application code, you minimize I/O, keep related items together, and plan ahead so that performance stays high as the data volume ...
https://dev.mysql.com/doc/refman/5.7/en/database-count-limit.html
The underlying file system may have a limit on the number of directories. The underlying file system may have a limit on the number of files that represent tables.
https://dev.mysql.com/doc/refman/5.7/en/mysqldump-copying-database.html
$> mysqldump db1 > dump.sql $> mysqladmin create db2 $> mysql db2 < dump.sql Do not use --databases on the mysqldump command line because that causes USE db1 to be included in the dump file, which overrides the effect of naming db2 on the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/create-user.html
To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system database. Important Under some circumstances, CREATE USER may be recorded in server logs or on the client side in a history file such as ...Mark the password expired so that the user must choose a new one at the first connection to the server: CREATE USER 'jeffrey'@'localhost' IDENTIFIED BY 'new_password' PASSWORD EXPIRE; Example: Create an account that uses the sha256_password authentication plugin and the given ...