How Do I Create an Ubuntu User with a Home Directory?

On an Ubuntu server, you might encounter a problem when it comes time to create a new user manually. Running the “useradd” command will create a user but do nothing else. It will not ask you to create a password or create a home directory. There are two easy solutions for this:
1. Run useradd […]

How to Remove MySQL Databases and Users

You may spend a good portion of any given day adding users and databases to your MySQL server, but you might not spend much time removing them, even after you or your users no longer need them. Nevertheless, it is very important to not leave unattended databases and users lying around for would-be attackers […]

How to Manage Users in Webmin

On a dedicated server, managing users does not have to be a difficult affair. While the command-line tools are not overly complicated, you may at times want to use a graphical interface or run batch user operations. Webmin’s “Users and Groups” module may be exactly what you need.
You can find the Users and Groups module […]

How to Find Things in a MySQL Database

Most modern websites run on some type of dynamic content management system. Many of them are powered by MySQL databases. In the event that you need to manually search for some information, there are two primary ways that you can search your database: 1) the MySQL command-line interface, and 2) a web-based interface like phpMyAdmin.
Command […]

How to Delete Users from Your Server

Part of the regular housekeeping of a dedicated server is cleaning out remnants of past users.  The last thing you want is for former users (especially former employees) to continue to log onto your server.  This is especially dangerous if you had given them SSH access.
The solution is to delete users as soon as they […]

How to Login to a Linux Server as a Different User

When you login to your dedicated server via SSH, there are normally two options: your own username and root.  It is inadvisable to login directly as root, but you can always use “su” or “sudo” to run root commands.  In some circumstances, however, it may actually be more convenient and useful to login as another […]

7 Ways to Troubleshoot Database Connections

With most of the world using dynamic websites, databases have become a regular part of the web hosting experience. Even if your database always works and run smoothly, you may have users on your dedicated server who are not so fortunate. Because many applications, scripts, and users may attempt to access the database […]

How to Manually Grant MySQL Privileges

Under normally functioning circumstances, you may never need to manually grant privileges in MySQL. When creating databases in cPanel, phpMyAdmin, or any other web-based interface, you can easily accomplish the same task without accessing the command line. In rare instances, however, those frontends may not work or may not be easily accessible to […]