Some Benefits of FUSE on a Linux Server

FUSE stands for Filesystem in Userspace. As the name implies, it allows a user with limited privileges to create a functional filesystem without requiring root (administrative) privileges. Because the filesystems exist in userspace, they are technically virtual filesystems. They, nevertheless, function as though they are not. Does FUSE have any use on a […]

How to Grant MySQL Privileges with PHPMyAdmin

Managing MySQL from the command line is not exactly what one would call quick and easy. Also, there may be times when you do not have immediate access to SSH or have the time to type in multiple commands. Fortunately, phpMyAdmin offers a user-friendly and fast approach to managing your databases. For example, you can […]

How to Setup Remote MySQL Access

Under normal circumstances, your MySQL server may only allow applications to connect to it locally, meaning both are running on the same server. If, however, you run MySQL on a separate machine, you will need to configure it to permit remote connections.
(Note: Replace terms in italics with the correct information from your own server)
Step […]

How to Manage MySQL Users in Webmin

In a previous post, we looked at some of the ways in which you can manage a MySQL user from the mysql command-line prompt. Today, you will learn about managing MySQL users from within Webmin’s web-based control panel.
To begin managing MySQL in webmin, do the following:

Login to webmin and find the section called “Servers”
Click “MySQL […]

MySQL User and Password Management

As you manage your dedicated server, you will invariably come across times when you need to reset passwords, add or delete accounts, or generally perform maintenance on your database users. When working with MySQL, there are a couple of simple ways to manage user accounts. The first involves accessing it from the command line, while […]

How to Copy All of the Tables from One Database to Another

Under normal circumstances, one of the easiest ways to copy the contents of one MySQL database to another is to use phpMyAdmin to dump the database to a file. You can then import the contents into your destination database. This usually works, but I recently encountered a situation where phpMyAdmin could not handle a particularly […]

How to Disable Direct Root Login

On a Linux server, root is the administrator of everything, the king of the hill. Root can do whatever he wants, whenever he wants. With full access and full privileges, root is the most powerful user on the server. While it may be convenient to login to your server as root and get to work, […]

Restricting Shared Hosting Accounts

Shared hosting is a type of web hosting where multiple users share the same server. If you have a dedicated server, you might offer shared hosting accounts to your users who need hosting accounts with their own domains but are not ready for a VPS or dedicated server of their own.
Because shared hosting users have […]

Should Shared Hosting Customers Have SSH Access?

Over at The Hosting News, we asked the question, “Do you need SSH with shared hosting?” This is a common question among shared hosting users, particularly those who are more adept at technologly. Here at Server School, we focus on dedicated servers, so the question for you is different. Should shared hosting customers have […]

How to Deal with Unauthorized Users

One day, while monitoring your server, you notice a user you do not recognize logged in through SSH or another method. What should you do in this situation?
First of all, do not panic. It may seem horrible, but is probably not as bad as you think. The fact that you still have control and a […]

How to Manage MySQL Users in cPanel

MySQL is a powerful database server that you can use in conjunction with server-side scripting like PHP to enhance your websites with dynamic content.  By default, the only way to manage MySQL is from the command line. Fortunately, there are web-based tools like phpMyAdmin and cPanel that provide other options.
In cPanel, you can create and […]

Granting Users Access to Privileged Files

Linux dedicated servers set permissions for every file, including applications.  Fortunately, it is very quick and easy to change the permissions of files in order to give specific users access.
First, it is important to understand how ownership and permissions work in Linux.  Every file has an owner, and that owner […]

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 Reset a Lost MySQL Password

Chances are, you have at least a dozen passwords for your server, computers, phones, email, social network, and bank account. It is tough enough to remember commonly-used passwords without even thinking about your MySQL password. The general perception is that, if you lose your MySQL administrative password, you are up a creek without […]

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 […]