MySQL

To access and add content to a MySQL database, you must first establish a connection between the database and a PHP script. In this guide learn how to use PHP to connect to MySQL.

This article covers the basics of using the DROP USER statement to delete MySQL users. Follow the step-by-step instructions to quickly remove one or multiple accounts.

Your server's MySQL time zone and your own might be out of sync. Read this article to learn 2 ways of editing your MySQL time zone and make it easier for you to read server logs and data.

The 'Command Not Found' error is a general error not only found in MYSQL. By learning how to deal with it, you will learn how to fix it in other situations as well. The three major operating systems are covered in this comprehensive tutorial.

Killing a MySQL process can help you boost the performance of your server. By running a few commands, you can identify which processes might be holding back your system and then kill individual processes or all of them.

As an administrator, you may need to rename a MySQL database. However, for security, the command to rename a database directly was removed in MySQL 5.1.23. This guide will provide four alternate methods to rename a database.

MySQL is a versatile RDBMS that can be used for anything from simple product databases to complex WordPress website. Exporting a database puts it in a dump file that can later be imported to another system. This guide will walk you through how to export the database and import it from a dump file in MySQL.

MariaDB is an open source, fully compatible, relational database management system. It is commonly used as a replacement for MySQL due to its fault tolerance, speed, and scalability. In this tutorial, learn how to install MariaDB on Ubuntu.

When you install MySQL on your system, the root user may not be able to access it. Using the ALTER command, you can modify the root user and allow it access to MySQL.

Data types are important to understand as a name and a data type define each column in a database table. Learn all about MySQL data types and when to use them in this comprehensive guide.