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/charset-database.html
The CREATE DATABASE and ALTER DATABASE statements have optional clauses for specifying the database character set and collation: CREATE DATABASE db_name [[DEFAULT] CHARACTER SET charset_name] [[DEFAULT] COLLATE collation_name] ALTER DATABASE db_name ... Every database has a database character set and a database ...All database options are stored in a ...
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/alter-user.html
To use ALTER USER, you must have the global CREATE USER privilege or the UPDATE privilege for the mysql system database. Important Under some circumstances, ALTER USER may be recorded in server logs or on the client side in a history file such as ...