Search Results
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
After MySQL is installed, the data directory must be initialized, including the tables in the mysql system schema: For some MySQL installation methods, data directory initialization is automatic, as described in Section 2.9, “Postinstallation ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system schema that define MySQL accounts. This section describes how to assign a password to the initial root account created during ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
Where can I find documentation for MySQL stored procedures and stored functions? A.4.3. Where can I find the ANSI SQL 2003 specification for stored procedures? A.4.5. Is there a way to view all stored procedures and stored functions in a given ...
https://dev.mysql.com/doc/refman/8.4/en/ibd2sdi.html
ibd2sdi is a utility for extracting serialized dictionary information (SDI) from InnoDB tablespace files. ibd2sdi can be run on file-per-table tablespace files (*.ibd files), general tablespace files (*.ibd files), system tablespace files (ibdata* ...
https://dev.mysql.com/doc/refman/8.4/en/ldap-pluggable-authentication.html
Note LDAP pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition supports an authentication method that enables MySQL Server to use LDAP (Lightweight Directory Access Protocol) ...
https://dev.mysql.com/doc/refman/8.4/en/making-trace-files.html
If the mysqld server does not start or it crashes easily, you can try to create a trace file to find the problem. To do this, you must have a mysqld that has been compiled with debugging support. If the version number ends with -debug, it is ...
https://dev.mysql.com/doc/refman/8.4/en/mrr-optimization.html
Reading rows using a range scan on a secondary index can result in many random disk accesses to the base table when the table is large and not stored in the storage engine's cache. With the Disk-Sweep Multi-Range Read (MRR) optimization, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-data-directories.html
Each MySQL Instance on a machine should have its own data directory. There are different methods of setting up a data directory for a new instance: Create a new data directory. Warning Normally, you should never have two servers that update data in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-install-debian.html
The section provides information about installing NDB Cluster on Debian and related Linux distributions such Ubuntu using the .deb files supplied by Oracle for this purpose. Oracle also provides an NDB Cluster APT repository for Debian and other ...
https://dev.mysql.com/doc/refman/8.4/en/mysqld-safe.html
mysqld_safe is the recommended way to start a mysqld server on Unix. mysqld_safe adds some safety features such as restarting the server when an error occurs and logging runtime information to an error log. A description of error logging is given ...