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 [...]
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 [...]
MySQL is one of the most widely used database management systems. It is free and open source and works very well with dedicated servers designed to power websites. On Linux servers, a program called “top” allows you to see real-time load averages and usage for all running programs. If, however, you just want to see [...]
In part one, we defined big data, and in part two, we talked a little about why companies might need big data and how an open source solution might be the best way to go. In this part, we will take a look at one open source solution that is making headlines. It is called [...]
In part one, we defined big data, but the name big data really only tells you what the problem is. It does not address the solution. You have this massive amount of unstructured data, and you have no way of organizing it. What should you do? This is where big data solutions come [...]
The business world is abuzz with talk of “big data”, but many people probably still do not have a firm grasp on what it means and how it will impact the IT world. If you manage servers for a living, there is a good chance that you will soon encounter an employer or client who [...]
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 [...]
Databases come in many sizes and flavors. Knowing which one is best for the type of application/website and data you are using can save you a lot of time and money in the long term. The following are three common database types as well as scenarios when you might want to use them.
Flat-file Database – [...]
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 [...]
Optimizing your MySQL database can help it run better, reduce fragmentation, and ultimately give you a boost in performance. In many cases, you can optimize your MySQL database using a graphical frontend, such as phpMyAdmin, but in some instances it is quicker and easier to run the command from within an SSH session, especially if [...]
Because most of today’s websites are dynamic and use server-side scripting, it is pretty much expected for dedicated servers to have some form of database management, either in the form of a full database server or a set of database libraries. MySQL is one of the most widely-used relational database management systems (RDBMS). [...]
MySQL is a great database server for small, medium, and large websites, but large sites may find that the database alone can consume a great deal of system resources. Ideally, you should be able to increase resources (i.e. more processors and more memory) in order to get better performance. In reality, however, there are some [...]
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 [...]
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 [...]
MySQL administration from the command line is an excellent skill to know, just in case you need it, but sometimes, graphical interfaces are easier and faster. Web-based configuration is also important if your dedicated server hosts websites for other users. You might not want them poking around in MySQL via SSH. In [...]
Most websites these days rely on content management systems, blogging software, and other types of web applications and scripts to update, manage, and configure them. Rather than static HTML pages stored in the user’s home directory, most content is now stored in databases.
As a dedicated server administrator, it is imperative that you have backups [...]
There are a few reasons why you might need to export a MySQL database. If you ever need to transfer your data to a new server, backup your databases, or provide a former client with their website content, being able to quickly and easily backup a database is important.
With phpMyAdmin and other web-based management [...]
More performance! When it comes to Mysql database hosting the issue of more speed and performance is always paramount. So to help you achieve that we want to provide you some tips for understanding the query cache and optimizing it based on your usage for the best database performance.
The query cache operates independently [...]
Running a dedicated server can be time consuming. There are a myriad of logs, services, and users to check and recheck. Any automation you can setup will greatly reduce your daily, weekly, and monthly work load. Cron is a handy way to automate tasks, as we have previously demonstrated.
MySQL databases, in particular, [...]
