How to install and configure ownCloud on Debian

According to its official website, ownCloud gives you universal access to your files through a web interface or WebDAV. It also provides a platform to easily view, edit and sync your contacts, calendars and bookmarks across all your devices. Even though ownCloud is very similar to the widely-used Dropbox cloud storage, the primary difference is […]
Continue reading…

 

How to find and kill misbehaving MySQL queries

Sometimes the complexity of a relational database system can be overwhelming. Fortunately, that complexity is an advantage, as with MySQL’s tools for managing queries. In this tutorial, I will show you how to find and kill any misbehaving MySQL queries. To view the currently-running queries, log in to the MySQL console and run the ‘show […]
Continue reading…

 

How to repair a crashed WordPress database table

A WordPress database may experience failure and corruption under various circumstances. One of common problems with it is “crashed database.” When that happens, you will find the following error in WordPress error log: WordPress database error Table ‘./my_home/wp_posts’ is marked as crashed and last (automatic?) repair failed for query SELECT post_date_gmt FROM wp_posts WHERE post_status […]
Continue reading…

 

How to set up a lightweight web server on Raspberry Pi

There are a variety of web server software available for Linux-based platforms including Raspbian. Using one of those available web server software, we can turn Raspberry Pi into a 24/7 available portable web server. In this case, however, we must understand that Raspberry Pi has hardware limitations in terms of CPU clock speed, memory, etc. […]
Continue reading…

 

How to monitor common services with Nagios

Nagios comes with a wide range of built-in scripts for monitoring services. This tutorial will cover the process of using some of these scripts for checking common services, such as MySQL, Apache web server, DNS, etc. To keep the article focused on service monitoring, we will not be configuring hostgroups or templates, as they have […]
Continue reading…

 

How to install and configure Cacti on Linux

Any system admin working in a service provider network would certainly agree that Cacti is one of the most widely used tools in network management solutions. It is open source, has built in user authentications and user permission features, shipped with frequently used graph templates like bandwidth, 95th percentile, hard disk usage, CPU usage, load […]
Continue reading…

 

How to set up web-based database management system with Adminer

A web-based database management system offers several advantages for any business operating databases. It allows databases to be administered from anywhere in the world, which increases productivity and efficiency of database administration. Also, having a web-based management interface means you don’t need to install a separate database client, but use a cross-platform web browser. Security […]
Continue reading…

 

How to install MySQL server and client on Linux

MySQL is the most popular open-source database management system supporting transactional relational databases. MySQL runs in a server-client architecture, where a MySQL server manages persistent databases and provides SQL query interfaces, while MySQL clients query the MySQL server to access MySQL databases. In this tutorial, I will describe how to install MySQL server and client […]
Continue reading…

 

How to log in to MySQL server without password

In order to log in to a MySQL server, you can run mysql command along with your login credentials and server’s IP address as arguments. For example: $ mysql -u $MYSQL_ROOT -p $MYSQL_PASS -h 192.168.10.1 However, besides the inconvenience of typing extra arguments, using plain-text login credentials in a command line like above is really […]
Continue reading…