How to Convert MyISAM to INNODB in phpMyAdmin

MySQL has a number of options for database storage. Two popular storage engines are MyISAM and INNODB. Each method has its advantages, and the purpose of this brief tutorial is not to debate which one is greater. If, however, you decide that you need to switch from one to the other, this guide should […]

How to Tunnel a MySQL Connection Through SSH

In a previous post, we highlighted some of the benefits of tunneling with SSH. Now, you will learn how to use an SSH tunnel to connect to MySQL remotely. With this method, you will connect to SSH, forwarding all information on port 3306 (the MySQL port) through this encrypted connection.
To get started, connect via SSH: […]

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

Graphical Tools for Managing Cassandra

Apache Cassandra is a free and open source NoSQL database system, an alternative to relational database management systems (RDMS) such as MySQL. Originally developed by Facebook, Cassandra is designed to handle large amounts of data, heavy loads and high traffic sites. It comes with management tools such as cassandra-cli and node-tool, but those looking to […]

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

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 Manage PHP Resource Limits in Webmin

PHP resource limits refer to the maximum amount of resources PHP can use to perform various operations. For example, if you have content management system (CMS) that allows you to upload media, PHP may have set a certain limit on the size of file that you can upload. Similarly, when working with MySQL databases in […]

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 Add and Drop MySQL Users

Most MySQL users manage their databases using some type of graphical user interface (GUI), whether it is a web-based tool like phpMyAdmin or a desktop tool like MySQL Administrator. For a dedicated server system administrator, however, there are times when it may actually be more convenient to use queries in the MySQL text-only command line […]

Connecting to MySQL from a Remote Location

The most common way to work with and manage MySQL is directly, using the command line or a web-based tool such as phpMyAdmin.  If, however, you have more than one database server or need to do routine complex tasks, the former may be too tedious, and the latter may be too simple.  Another possible reason […]

How to Optimize MySQL Databases in SSH

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

MySQL Administration with phpMyAdmin

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