PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html
To dump grant table contents as logical definitions in the form of CREATE USER and GRANT statements, use the --users option and suppress all database dumping: mysqlpump --exclude-databases=% --users In the preceding command, % is a wildcard that ...
https://dev.mysql.com/doc/refman/5.7/en/user-names.html
There are several distinctions between the way user names and passwords are used by MySQL and your operating system: User names, as used by MySQL for authentication purposes, have nothing to do with user names (login names) as used by Windows or ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
If you know the root password and want to change it, see Section 13.7.1.1, “ALTER USER Statement”, and Section 13.7.1.7, “SET PASSWORD Statement”. This enables anyone to connect without a password and with all privileges, and disables ... If ...The following sections provide instructions for Windows and Unix and Unix-like systems, as well as generic instructions that apply to any ...
https://dev.mysql.com/doc/refman/5.7/en/set-character-set.html
SET CHARACTER SET sets three session system variables: character_set_client and character_set_results are set to the given character set, and character_set_connection to the value of character_set_database. SET {CHARACTER SET | CHARSET} ...
https://dev.mysql.com/doc/refman/5.7/en/creating-database.html
For example: $> mysql -h host -u user -p menagerie Enter password: ******** Important menagerie in the command just shown is not your password. If the administrator creates your database for you when setting up your permissions, you can begin using ...Creating a database does not select it for use; you must do that ...Otherwise, you need to create it yourself: mysql> CREATE DATABASE menagerie; Under Unix, database names are case-sensitive (unlike SQL keywords), so you must always refer to your ...
https://dev.mysql.com/doc/refman/5.7/en/database-use.html
The test database often is available as a workspace for users to try things out. Use the SHOW statement to find out what databases currently exist on the server: mysql> SHOW DATABASES; +----------+ | Database | +----------+ | mysql | | test | | tmp ...For example, a database like this could be used by a farmer to keep track of livestock, or by a veterinarian to keep track of patient ...
https://dev.mysql.com/doc/refman/5.7/en/alter-database.html
See Section 13.1.16, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) If you change the default character set or collation for a database, any stored routines that are to use the new defaults must be dropped and recreated. ALTER {DATABASE | ...These characteristics are stored in the db.opt file in the database ...Note The UPGRADE DATA ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mysql-database.html
This pertains to statements such as GRANT, REVOKE, SET PASSWORD, RENAME USER, CREATE (all forms except CREATE TABLE ... The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or ...The ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...
https://dev.mysql.com/doc/refman/5.7/en/create-database.html
create_option: [DEFAULT] { CHARACTER SET [=] charset_name | COLLATE [=] collation_name } CREATE DATABASE creates a database with the given name. To use this statement, you need the CREATE privilege for the database. For information about character ... CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name [create_option] ...
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 ...