To make the most of the features of this database, it is important to know the main MySQL commands and operations. In this article, we will explore the main MySQL commands, from managing databases and tables, to creating and managing users and permissions. So, by the end of this article, we will learn...
When working with strings in Bash, it is often necessary to compare them in order to execute commands based on their values. In Bash, as in other programming languages, string comparisons are done with the if conditionals and comparison operators. In this article, we’ll cover how these operators are used to compare...
The primary function of the MySQL privilege system is to authenticate a user who connects from a given host and to associate that user with privileges on a database such as SELECT, INSERT, UPDATE, DELETE etc. In general, Mysql Grant All Privileges ensures that one user has access to one or more databases and/or table. How...
MySQL is an open source relational database management system. MySQL is a component of the LAMP web application software stack, which is an acronym for Linux, Apache, MySQL, PHP. A web application using MySQL database have to authenticate via a MySQL user and password who has sufficient privileges on that particular database....
We read about how an OpenVPN Server can be setup and made ready to connect from an OpenVPN client in the article Configuring OpenVPN in Ubuntu using TUN/TAP Let’s see how to set it up in a windows machine at home and how it can be used to connect to the OpenVPN server. I currently use a windows 8.1 machine. I will...
A device which connects a computer to another computer or network is called a network device. Normal network devices (say for example eth0) will have a hardware component or a wire connected to it. On the oposite, there are virtual network devices which are completely controlled by software. They are the tun/tap devices. These...
For years, MySQL is the favorite database system for developers worldwide. After the acquisition of MySQL by Sun Microsystems, and later by Oracle, the original founders of MySQL forked MySQL and created another RDBMS called MariaDB. It is actually a perfect replacement for MySQL and has more features and better performance...
Databases are an important part of any website or software. With relatively large amount of data, all applications use one or the other database method to store data. PostgreSQL, commonly known as Postgres is an open source, object – relational database management system (RDBMS). It was originally designed for unix...
To recover or reset MySQL root password in Ubuntu, you should simply follow some steps. This process may vary according to the operating system. Ubuntu offerts a possibility to restore the root password via dpkg, which is a native package management system. Recovering the database root access: reset MySQL root password...
To install MySQL in Ubuntu, need to have root access to an Ubuntu server. This tutorial applies either to a dedicated server and a cheap vps hosting server. The first step is to login by SSH into your server. First of all, we have to update all the packages of the server sudo apt-get update sudo apt-get upgrade Now we...
This article shows the steps required to install Apache in Ubuntu 14. Apache web server is the most used and reliable web server of the world. This tutorial assumes you have an Ubuntu server, with full root access. The first step is access your Ubuntu server with root by SSH. We will explain how to install Apache httpd...
Proftpd is the world’s most popular FTP Server for Linux. It allows you to connect to your Linux server using an FTP client, in order to transfer files. This tutorial will show you how to install Proftpd in CentOS Linux. It takes less than 5 minutes. This tutorial assumes you: Have a CentOS 6 Linux installed. Have...
