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