10.1 The Error Log The error log contains information indicating when mysqld was started and stopped and also any critical errors that occur while the server is running. If mysqld notices a table that needs to be automatically checked or…
9.1 Server System Variables [client] [mysqld] [mysqldump] [myisamchk] [mysqlhotcopy] auto_increment_increment Controls the interval between successive column values. auto_increment_offset determines the starting point for the AUTO_INCREMENT column value. Autocommit log-error skip-networking init_connect A string to be executed by…
8.1 myisamchk ― MyISAM Table-Maintenance Utility The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables. You can also use the CHECK TABLE and REPAIR TABLE statements to check…
7.1 mysql ― The MySQL Command-Line Tool mysql is a simple SQL shell (with GNU readline capabilities). It supports interactive and noninteractive use. When used interactively, query results are presented in an ASCII-table format. When used noninteractively (for example, as…
6.1 Comparing Transaction and Nontransaction Engines Transaction-safe tables (TSTs) have several advantages over nontransaction-safe tables (NTSTs): They are safer. Even if MySQL crashes or you get hardware problems, the database will be in a consistency form. You can combine many…
We can create User Accounts in two ways. By using CREATE USER or GRANT statements. (Recommended Method) By manipulating the mysql grant tables with statements like INSERT and DELETE. Using CREATE USER and GRANT statements: Creating a User: By…
Installing MySQL from RPM Packages on Linux For non-RPM Linux distributions, you can install MySQL using a .tar.gz package. MySQL-server-VERSION.glibc23.i386.rpm The MySQL server. You need this unless you only want to connect to a MySQL server running on another…
MySQL is a database management system A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add,…
MySQL Instance Manager MySQL Instance Manager is been deprecated in MySQL 5.1 and is removed in MySQL 5.5. Using mysqld_multi for Managing Multiple MySQL Servers mysqld_multi is designed to manage several mysqld processes that listen for connections on different Unix…
General Security Guidelines Do not ever give anyone (except MySQL root accounts) access to the user table in the mysql database! This is critical. Learn the MySQL access privilege system. The GRANT and REVOKE statements are used for controlling…