MySQL Administration Suite

Elvin Aslanov
1 min readJul 9, 2022


MySQL includes client programs to administer its server software.

mysql80-client package provides these tools to administer mysql80-server on FreeBSD operating system, and namely the mysqld(8) daemon located at /usr/local/libexec directory by default.

  • mysql: Execute SQL commands on databases
  • mysqladmin: CREATE new or DROP existing databases hosted on the server
  • mysqlshow: Show databases, tables, and columns (wildcard)
  • mysqldump: Export table structure and data as SQL
  • mysql_config_editor: Set “login pathes” (host, port, user, and password)
  • my_print_defaults: Show default options for client programs (as defined in option groups)
  • perror: Convert MySQL error codes to error messages

There are also included server programs to administer the MySQL daemon:

Configuration Files

MySQL configuration files are used to keep default options for client and server programs.

  • my.cnf: system’s MySQL defaults
    located within /usr/local/etc/mysql (on FreeBSD)
  • .my.cnf: user’s MySQL defaults
    located within ~ (user’s home directory)
  • .mysql_history: mysql statements history
    located within ~ (user’s home directory)
  • .mylogin.cnf (binary): login paths as created by mysql_config_editor
    located within ~ (user’s home directory)
  • hostname.err: MySQL log file
    located within the database directory



Elvin Aslanov

Unix and Open Source Software passionate. Currently working as Tech Support / System Administrator at a Web Hosting company.