October 20, 2017

MySQL

How to Recover the MySQL root Password

MySQL Logo

Forgot your MySQL root password? No problem, you just need to start MySQL with a flag to tell it to ignore any username and password restrictions which might be in place. Once that is done you can successfully recover the MySQL root password by setting a new password.

[Read more...]

How to Install Zabbix on FreeBSD

Zabbix Logo

Zabbix is a very useful tool for availability and performance monitoring. Alerting you by E-Mail, Jabber or SMS once a service is not reachable is one of the key features of Zabbix.

Here is a short list of some features available in Zabbix:

  • auto-discovery of servers and network devices
  • low-level discovery
  • distributed monitoring with centralized web administration
  • support for both polling and trapping mechanisms
  • agent-less monitoring
  • secure user authentication
  • flexible user permissions
  • web-based interface
  • flexible e-mail notification of predefined events
  • high-level (business) view of monitored resources
  • audit log

In this tutorial we show you how to get a Zabbix server, the Zabbix agents and the Zabbix frontend running on FreeBSD.

[Read more...]

How to Backup and Restore a MySQL Database

MySQL Logo

Backing up MySQL databases is an area that is often forgotten. The only time you probably think of backing up your MySQL data is when you change your web host or switch to an other database server. With this instruction we will show you how easy it is to backup and restore a MySQL database.

[Read more...]

How to Install phpMyAdmin on CentOS

phpMyAdmin Logo

With phpMyAdmin you can easily handle your MySQL databases through a web interface. This web interface is almost as powerful as the MySQL Command-Line tool. You can execute SQL statements, create, modify and delete databases, tables, fields or rows and manage users or permissions.

[Read more...]

How to Install Confluence on CentOS

Confluence Logo

We think Confluence (developed and marketed by Atlassian) is the best enterprise wiki out there. It has a plugin system and is very easy to configure. Confluence is written in Java and is mainly used in corporate environments. This instruction is to install Confluence on CentOS. We are using Confluence on CentOS 6 with 64 bit. Please change the paths when it is required.

[Read more...]

How to set up a LAMP Server and OXID eShop on CentOS

CentOS Logo

With this tutorial we provide you a step-by-step instructions for installing a full-featured LAMP stack and OXID eShop on a CentOS system. In the following you will be instructed on setting up Apache, MySQL, PHP and OXID eShop.

[Read more...]

How to Install phpMyAdmin on FreeBSD

phpMyAdmin Logo

Now you can handle the administration of MySQL over the Web and on FreeBSD. It can manage a whole MySQL server as well as a single database. With phpMyAdmin you can easily browse through databases and tables, create, copy, rename, alter and drop databases and tables and many more.

[Read more...]