IT. Expert System.

MYSQL

MySQL Programs


Description

This section includes an overview of the various MySQL Programs.

The following table lists some of the server related programs for MySQL:

Program Description
mysqld This is the MySQL server, which is the main program for MySQL
mysqld_safe A server startup script which attempts to start mysqld. This is the recommended method for starting the MySQL server on Unix as it provides restart and logging mechanisms
mysql.server A server startup script used on systems that use System V-style run directories that contain scripts that start system services for particular run levels. This script evenually calls mysqld_safe to start the server
mysqld_multi This program is used to manage multiple mysqld processes. It can be used to start or stop servers, or report their current status

The following table lists some of the installation related programs for MySQL:

Program Description
comp_err This program creates the errmsg.sys file for mysqld and is used to determine the error message to display for different error codes
mysq_install_db This program is used to initialize the MySQL data directory and creates the necessary system tables
mysql_secure_
installation

Improves the security of MySQL by:

  • Allows setting the password for root accounts
  • Allows removal of root accounts that are accessible from outside the local host
  • Allows removal of anonymous user accounts
  • Allows removal of the test database
mysql_tzinfo_
to_sql
Allows the loading of time zone tables in the MySQL database
mysql_upgrade Allows checking of tables in all databases for incompatibilities with the current version

The following table lists some of the client related programs for MySQL:

Program Description
mysql This is the MySQL command-line tool
mysqladmin This program is a client used to perform administrative operations. It can be used to check the server's status, configuration, manage tables, etc
mysqlcheck This program is a client that can be used to perform table maintenance by analyzing, optimizing, or repairing them
mysqldump Used to dump a MySQL database for backup or transfer to another server
mysqlimport Used to import data into the MySQL database
mysqlshow A client program that can be used to show databases, tables, table columns, or indiexes.

The following table lists some of the administrative / utilty related programs for MySQL:

Program Description
mysqlaccess This program is a diagnostic tool that checks the access privileges for a host name, user name, and database combination
mysqlbinlog This program is used to display the contents of the binary log files contents in text format
mysqlbinlog This program is used to display the contents of the binary log files contents in hex dump format


Content

Android Reference

Java basics

Java Enterprise Edition (EE)

Java Standard Edition (SE)

SQL

HTML

PHP

CSS

Java Script

MYSQL

JQUERY

VBS

REGEX

C

C++

C#

Design patterns

RFC (standard status)

RFC (proposed standard status)

RFC (draft standard status)

RFC (informational status)

RFC (experimental status)

RFC (best current practice status)

RFC (historic status)

RFC (unknown status)

IT dictionary

License.
All information of this service is derived from the free sources and is provided solely in the form of quotations. This service provides information and interfaces solely for the familiarization (not ownership) and under the "as is" condition.
Copyright 2016 © ELTASK.COM. All rights reserved.
Site is optimized for mobile devices.
Downloads: 60 / 159530710. Delta: 0.00199 с