Utilities and Programs for MySQL

In addition to the MySQL database server (mysqld), the MySQL “suite” includes a number of programs for administering the databases and the database server. These programs were installed when you installed via the RPM. isamchk and myisamchk are utilities that verify and repair database tables and files. mysqlaccess is used to grant, modify, and revoke user permissions. mysqladmin is a utility for higher-level administration, such as creating databases and shutting down the myslqd server. mysqldump comes in handy for exporting data or backing up tables in a pinch; it outputs data in SQL insert statements in such a way that the output file can be fed back into a MySQL server (or other database) and the rows will ...

Get MySQL Building User Interfaces now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.