How to show open database connections in MySQL

  • 07 April 2020
  • ADM

How to show open database connections in MySQL using show status and show processlist command.


How to export and import a .sql file in MySQL from command line

  • 03 February 2017
  • ADM

How to export and import a .sql file in MySQL from command line. Simple commands with multiple parameters.


How to reset MySQL / MariaDB Root Password

  • 01 February 2017
  • ADM

How to reset MySQL / MariaDB Root Password. Simple 6 steps to reset the password.


How to build a LAMP stack (Linux, Apache, MySQL, PHP) on CentOS 7

  • 31 January 2017
  • ADM

How to build a LAMP stack (Linux, Apache, MySQL, PHP) on CentOS 7. The article includes the install + the firewall settings for public access.


How to define one-to-one relationship in MySQL

  • 08 July 2016
  • ADM

How to define one-to-one relationship in MySQL using the foreign key and unique property to limit the row count from the child table


Configure database connection in Eclipse

  • 04 July 2016
  • ADM

How to configure database connection in Eclipse. Configure new Connection Profile to any database engines.