MySQL Administration Suite

  • 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

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

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Elvin Aslanov

Elvin Aslanov

Unix and Open Source Software passionate. Currently working as Tech Support / System Administrator at a Web Hosting company. https://www.linkedin.com/in/rwp0/