MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 391 to 400 of 408 total results

2.7.1 Installing MySQL on Solaris Using a Solaris PKG

https://dev.mysql.com/doc/refman/5.7/en/solaris-installation-pkg.html

You must have root privileges to perform this operation: $> pkgadd -d mysql-5.7.44-solaris11-x86_64.pkg The following packages are available: 1 mysql MySQL Community Server (GPL) (i86pc) 5.7.44 Select package(s) you wish to process (or 'all' to ...

13.4.3.1 START GROUP_REPLICATION Statement

https://dev.mysql.com/doc/refman/5.7/en/start-group-replication.html

If super_read_only=ON and the member should join as a primary, super_read_only is set to OFF once Group Replication successfully starts. A server that participates in a group in single-primary mode should use skip_replica_start=ON. Otherwise, the ...

13.4.2.5 START SLAVE Statement

https://dev.mysql.com/doc/refman/5.7/en/start-slave.html

START SLAVE [thread_types] [until_option] [connection_options] [channel_option] thread_types: [thread_type [, thread_type] ... ] thread_type: IO_THREAD | SQL_THREAD until_option: UNTIL { {SQL_BEFORE_GTIDS | SQL_AFTER_GTIDS} = gtid_set | ...

2.9.2.1 Troubleshooting Problems Starting the MySQL Server

https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html

If you get Errcode 13 (which means Permission denied) when starting mysqld, this means that the privileges of the data directory or its contents do not permit server access. This section provides troubleshooting suggestions for problems starting ...

13.4.3.2 STOP GROUP_REPLICATION Statement

https://dev.mysql.com/doc/refman/5.7/en/stop-group-replication.html

As soon as you issue STOP GROUP_REPLICATION the member is set to super_read_only=ON, which ensures that no writes can be made to the member while Group Replication stops. Any other replication channels running on the member are also stopped. Warning ...

13.4.2.6 STOP SLAVE Statement

https://dev.mysql.com/doc/refman/5.7/en/stop-slave.html

] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication threads. Recommended best practice is to execute STOP SLAVE on the replica before stopping the replica server (see Section 5.1.16, “The Server Shutdown ...

12.8 String Functions and Operators

https://dev.mysql.com/doc/refman/5.7/en/string-functions.html

To use this function, the file must be located on the server host, you must specify the full path name to the file, and you must have the FILE privilege. For functions that operate on string positions, the first position is numbered 1. For functions ...

13.1.34 TRUNCATE TABLE Statement

https://dev.mysql.com/doc/refman/5.7/en/truncate-table.html

Logically, TRUNCATE TABLE is similar to a DELETE statement that deletes all rows, or a sequence of DROP TABLE and CREATE TABLE statements. To achieve high performance, it bypasses the DML method of deleting data. Thus, it cannot be rolled back, it ...

13.7.3.4 UNINSTALL PLUGIN Statement

https://dev.mysql.com/doc/refman/5.7/en/uninstall-plugin.html

It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. UNINSTALL PLUGIN plugin_name This statement removes an installed server plugin. plugin_name must be the name of ...

13.8.4 USE Statement

https://dev.mysql.com/doc/refman/5.7/en/use.html

This statement requires some privilege for the database or some object within it. USE db_name The USE statement tells MySQL to use the named database as the default (current) database for subsequent statements. The named database remains the ...

Displaying 391 to 400 of 408 total results