PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
Setting the password for a named account (with a FOR clause) requires the UPDATE privilege for the mysql system database. SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. SHOW CREATE USER user This statement shows the CREATE USER statement that creates the named user. To name the account, ...
https://dev.mysql.com/doc/refman/5.7/en/show-engine.html
An internal buffer that is exposed as a table in the performance_schema database is named after the table, without parentheses. SHOW ENGINE engine_name {STATUS | MUTEX} SHOW ENGINE displays operational information about a storage engine. The ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS requires the SELECT privilege for the mysql system database, except to display privileges for the current user. SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of ...
https://dev.mysql.com/doc/refman/5.7/en/show-processlist.html
db The default database for the thread, or NULL if none has been selected. SHOW [FULL] PROCESSLIST The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. For a comparison of this ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-status.html
Replicate_Do_DB, Replicate_Ignore_DB The lists of databases that were specified with the --replicate-do-db and --replicate-ignore-db options, if any. SHOW SLAVE STATUS [FOR CHANNEL channel] This statement provides status information on essential ...
https://dev.mysql.com/doc/refman/5.7/en/source-installation.html
For a list of systems on which MySQL is known to run, see https://www.mysql.com/support/supportedplatforms/database.html. Building MySQL from the source code enables you to customize build parameters, compiler optimizations, and installation ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-types.html
For example, a system view named GEOMETRY_COLUMNS contains a description of geometry columns, one row for each geometry column in the database. The Open Geospatial Consortium (OGC) is an international consortium of more than 250 companies, ...
https://dev.mysql.com/doc/refman/5.7/en/start-slave.html
When a replication channel has gaps, the replica’s database is in a state that might never have existed on the source. START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
This is where it expects to find databases and where it expects to write log files. This section provides troubleshooting suggestions for problems starting the server. For additional suggestions for Windows systems, see Section 2.3.5, ...