Author: Rahul

While working with the databases, many times you may need to rename a database. For security purposes, MySQL had dropped the direct command to rename a database from MySQL 5.1.23. So there is no direct command to the T-SQL statement available for renaming a database in MySQL server. You can follow one of the below instructions to rename a MySQL database with the help of cPanel, phpMyAdmin, or command line as per the availability. After renaming the database, remember that you need to reconfigure the permission on the new database for the users. In this tutorial, you will find three…

When we talk about accessing servers remotely, the first thing that comes to our mind is SSH. It is a network protocol and a secured version of Telnet and encrypts the connection so others cannot access the information being transmitted. With advancements in the technology world, hackers are becoming more sophisticated every day. Even your SSH connection is not secure if you are using the traditional or default installation settings. Therefore, it has become necessary to secure your SSH server from unwanted data breaches and malicious attacks by taking some crucial precautions. In this article, we will introduce you to…

In this tutorial, you will learn how to change a MySQL user password using SQL statements for different versions. MySQL changed the SQL statement syntax for changing user passwords from 5.7.6 and newer versions. So, you must check the MySQL server version before running the correct SQL query to change the user password. Identify MySQL Version First, connect to the database server by running the following command. The below command will connect to the MySQL database server running on localhost. mysql -h localhost -u root -p Enter the MySQL root account password to authenticate. Once the authentications are successful, You…

Roundcube is a web-based email client; an email client is a computer program that allows the user to read, write and manage their email. It runs on IMAP (Internet Message Access Protocol) which is a standard email protocol that allows the user to access email from anywhere, anytime. It stores emails on the server and enables the user to manage them as if they are stored on the user’s system. This helps the user in the organization and classification of different emails(This helps the user to organize and classify different emails into different folders). In this how-to guide, we will…

RDP is a protocol developed by Microsoft, that allows a user to access remote systems graphically. The default Windows servers allow only one remote desktop session at a time. But, in some cases, we are required to enable remote desktop for multiple users to allow access at a time. You can achieve this by making little changes to the system registry keys. Once the changes are done, multiple users can connect to your system using the RDP client. You can also limit the number of users who can connect at a time. In this tutorial, we will discuss enable and…

Want to use Linux but want to feel like using Mac at the same time? You can surely try out these Linux distributions. These are the ultimate distributions you can go with that look just like Mac. With this, you will get the same feeling like you are using Mac. Along with the looks, we have also kept in mind the features and most importantly, your privacy. We know Mac users love privacy. Hence, our first pick is the best Linux OS for privacy. You can surely try out any of these OS. You will surely feel like you are…

Accessing computers remotely has become an important part of the IT world especially in today’s scenario where everyone is working from home due to covid19. There are mainly two ways of connecting machines remotely depending on your operating system like SSH for Linux and RDP for Windows. But every time we try to connect with our remote server, we have to enter a password. So how to set up a passwordless SSH login? In this tutorial, we will guide you on the same. SSH works by installing SSH server and SSH application respectively on destination(remote) and source(Client) machine. After installing…

FTP (File Transfer Protocol) is a network transmission standard that is used to transfer data from client to server and vice versa. It uses TCP (Transmission Control Protocol) which ensures that the data is actually arriving at its destination. TCP is what makes FTP reliable. FTP is very helpful for businesses as it allows them to perform important functions such as the transfer of large and bulky files on a routine basis. These activities cannot be done over email or through other basic file-sharing programs. It is also used to upload and manage website files to the server. The FTP…

Linux ip command is a command-line utility used for show/update ip address, kernel routing tables, network devices, interfaces, and tunnels. This command is a part of iproute2 package. With the help of ip command, the system administrators assign an address to a network interface and/or configure network parameters on an interface. IP (Internet Protocol) address is a numerical label assigned to a network interface of a computer that allows the communication of the system over the internet. On a computer network, a system communicates with another system by its IP address. The older operating systems were uses the ifconfig. Which…

One of the directories has millions of files, which is no more required. When trying to delete all files from that folder using the rm command, I got this error message /bin/rm : Argument list too long If there are a large number of files in a single directory, Then the traditional rm command can not delete all files and ends with an error message Argument list too long. To resolve this issue and delete all files use xargs command-line utility with the find command. First change to the directory where all files exists: cd dir_contains_file Then execute command to…