MySQL Workbench is a graphical design tool for MySQL databases. It is used for database server administration, database design, creation, security management and server as well as database maintenance. Install MySQL Workbench on Ubuntu: sk@sk:~$ sudo apt-get install mysql-workbench Add Database Server connection Now open MySQL Workbench from Menu or Dash. The main page of […]
StatusNet is open-source software used to setup micro-blogging site similar to Twitter. In this article, I use CentOS 6.4 to setup this website. My hostname and IP Address are server.unixmen.com and 192.168.1.200/24, respectively. Change these values as per your setup. Prerequisites Install the following prerequisites to install and configure StatusNet: [root@server ~]# yum install mysql […]
Piwik is an open-source and free alternative to Google Analytics tool. It tracks and displays reports about the location of user visits, Where they came from (i.e website, directly, or something else), the visitors browser, screen size, operating system details, what the visitors did on your website, the time of visits and more. In this […]
This article describes you how to upgrade MySQL to MariaDB in ten simple steps. We have already shown you How to Migrate from MySQL to MariaDB on FreeBSD. I assume that you already have installed MySQL latest version and it’s up and running now.
MySQL replication allows you to have multiple copies of data on many systems and data is automatically copied from one database (Master) to another database (Slave). If one server goes down, the clients still can access the data from another (Slave) server database. In this article, let us see how to configure MySQL Master-Slave replication. […]
Monit is a free open-source tool used to manage and monitor processes, programs, files, directories and filesystems on a local or remote LINUX/UNIX systems. Monit conducts automatic maintenance and repair and can execute meaningful causal actions in error situations.
Web browsers are software used to access and view the internet and webpages. We all know about some of the popular web browsers such as Mozilla Firefox, Google Chrome, Opera and others. Surfing the web from the command-line can be somehow scrappy, but you can give it a try as well. Most users doesn’t know […]
Hi Unixmen readers, Fedora 19 ‘Schrödinger’s Cat‘ has just been released in its Beta stage with a bunch of features. Today we’ll see some of the features, but won’t cover everything until the final release. But we wanted to make sure our readers are the first to read/know about this incredible upcoming release by the […]
Telnet is a network protocol which is used to connect to remote computers over TCP/IP network. You can make a connection to a remote host using telnet. Once you establish a connection to the remote computer, it becomes a virtual terminal and will allow you to communicate with the remote host from your computer. Installing […]
We have already shown you how to create a local repository on Ubuntu systems. Today we are going to learn about setting up local yum repository on CentOS 6.4 and other RPM based distributions. As I noted in my previous tutorial about local repository, if you have to installed software, security updates and fixes often […]