Search Results
https://dev.mysql.com/doc/refman/9.7/en/performance-schema-user-defined-functions-table.html
The file is located in the directory named by the plugin_dir system variable. The mysql.func system table also lists installed loadable functions, but only those installed using CREATE FUNCTION. The user_defined_functions table contains a row for ...
https://dev.mysql.com/doc/refman/9.7/en/perl-support-problems.html
Add the path name of the directory where libmysqlclient.so is located to the LD_RUN_PATH environment variable. The -L option should specify the path name of the directory where libgcc.a is located on your system. If Perl reports that it cannot find ...
https://dev.mysql.com/doc/refman/9.7/en/rename-table.html
Regardless of the statement used, if the rename operation would move the table to a database located on a different file system, the success of the outcome is platform specific and depends on the underlying operating system calls used to move table ... RENAME TABLE tbl_name TO new_tbl_name [, tbl_name2 TO new_tbl_name2] ...
https://dev.mysql.com/doc/refman/9.7/en/rename-user.html
When the read_only system variable is enabled, RENAME USER additionally requires the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). To use RENAME USER, you must have the global CREATE USER privilege, or the UPDATE privilege for the ... RENAME USER old_user TO new_user [, old_user TO new_user] ...
https://dev.mysql.com/doc/refman/9.7/en/replication-sbr-rbr.html
Note Statements that update the information in the mysql system schema, such as GRANT, REVOKE and the manipulation of triggers, stored routines (including stored procedures), and views, are all replicated to replicas using statement-based ...For ...
https://dev.mysql.com/doc/refman/9.7/en/show-tables.html
Matching performed by the LIKE clause is dependent on the setting of the lower_case_table_names system variable. The optional FULL modifier causes SHOW TABLES to display a second output column with values of BASE TABLE for a table, VIEW for a view, ... SHOW [EXTENDED] [FULL] TABLES [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLES lists the non-TEMPORARY tables in a given ...
https://dev.mysql.com/doc/refman/9.7/en/stored-routines-privileges.html
If the automatic_sp_privileges system variable is 0, the EXECUTE and ALTER ROUTINE privileges are not automatically granted to and dropped from the routine creator. The MySQL grant system takes stored routines into account as follows: The CREATE ...
https://dev.mysql.com/doc/refman/9.7/en/symbolic-links.html
You might want to do this, for example, to move a database to a file system with more free space or increase the speed of your system by spreading your tables to different disks. To determine the location of your data directory, use this statement: ... You can move databases or tables from the database directory to other locations and replace them with symbolic links to the new ...
https://dev.mysql.com/doc/connectors/en/connector-python-installation.html
Make sure Python is installed on your platform: Python comes preinstalled on most Unix and Unix-like systems, such as Linux, macOS, and FreeBSD. If your system does not have Python preinstalled for some reasons, use its software management system to ...For Microsoft Windows, a Python installer is available at the Python Download website or via the Microsoft ...
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-trace-source.html
The trace source is configured within the system.diagnostics section of the file. The .NET tracing architecture consists of four main parts: Source - This is the originator of the trace information. Switch - This defines the level of trace ...