Connecting to MySQL Using Python

Reading Time: 5 minutes

In this article, we will be discussing how to connect to MySQL using Python. Python is one of the most productive and widely used programming languages in use today. Its simple and elegant syntax makes it ideal for new programmers, while experienced programmers enjoy the extensive list of available modules and functionalities. 

MySQL is a robust open-source SQL-based, relational database management system that is used in many software programs and web servers. This article aims to show how to connect to use Python to connect to MySQL and perform some basic tasks. 

Continue reading “Connecting to MySQL Using Python”

How to Create and Use MySQL Views

Reading Time: 6 minutes

What is a MySQL View?

A MySQL view is simply an ordinary database object that can save SQL query writers a lot of time when used correctly. A view is a stored query that a user can reference just like a table. Many times users will find themselves using the same base query over and over to solve multiple problems. Views are a way of quickly saving that query and referencing it later.  

Continue reading “How to Create and Use MySQL Views”

“Password is Forbidden” PhpMyAdmin Login Error Solved

Reading Time: 2 minutes

Once in a while, perhaps on a Development server, MySQL will not be set up with a root password. The aforementioned configuration is generally thought of as against best practices, however, if it is what you’re dealing with, then it could also interfere with PhpMyAdmin.

This error relates to logging into phpMyAdmin, an open source tool used for the administration of MySQL.

Continue reading ““Password is Forbidden” PhpMyAdmin Login Error Solved”

Deleting Fields from Database Tables with PhpMyAdmin

Reading Time: 2 minutes

The scope of information needed in a table can change overtime, and you may find you no longer need a whole column of data. Removing a column from a table can help get rid of unwanted content, like if a project or product is no longer needed, to help free up disk space on a server, to clean up any empty or unused columns, or even just remove data that may have been duplicated. Removing a column is quick and easy to do in PhpMyAdmin.

This guide assumes that you have already logged in to PhpMyAdmin. We will go over how to delete a column within a table.

Starting on the home page of PhpMyAdmin, using the navigation menu on the left, click on the database name that the table we want to modify.

Continue reading “Deleting Fields from Database Tables with PhpMyAdmin”

Inserting Fields into Database Tables with PhpMyAdmin

Reading Time: 2 minutes

When working on a database, we sometimes find that additional data should be added for each record, but will not fit into any of the existing fields or structures. Adding a new column into an existing database can help with this problem, and it is very easy to accomplish with PhpMyAdmin.

This guide assumes that you have already logged in to PhpMyAdmin as the root user. Next, we will go over how to copy a table, and then review a few of the options PhpMyAdmin provides.

Continue reading “Inserting Fields into Database Tables with PhpMyAdmin”

Deleting Tables from a Database with PhpMyAdmin

Reading Time: 2 minutes

Managing databases and tables from within PhpMyAdmin is usually very straightforward. This guide will demonstrate how to remove columns and tables from a database using PhpMyAdmin.

We must first state that the potential for unintentional data removal can be elevated when working with any database. Before proceeding, it is highly recommended taking a backup before manipulating any data. Also, prior to amending data, we should confirm is not being used in a live environment.

Continue reading “Deleting Tables from a Database with PhpMyAdmin”

Modifying Fields in Database Tables with PhpMyAdmin

Reading Time: 2 minutes

The structure of a field inside a database table can be easily modified! There are a number of reasons why a column would need to be altered. For example, if the existing values needed to be modified to updated data, if a restructuring of tables were needed, or even to help with optimization. PhpMyAdmin makes modifying fields in database tables very straightforward to accomplish.

Continue reading “Modifying Fields in Database Tables with PhpMyAdmin”

Renaming Database Tables with PhpMyAdmin

Reading Time: 2 minutes

Renaming a table within a database is a task that may need to be done occasionally. You might just need to rename it for clarification purposes, to archive old data, to make a copy when a restore is being done, or any number of other reasons. PhpMyAdmin helps you rename a database quickly with just a few clicks.

Continue reading “Renaming Database Tables with PhpMyAdmin”

Exporting Databases and Tables with PhpMyAdmin

Reading Time: 3 minutes

Using PhpMyAdmin to export a database or table is a great way to make a backup you can save locally, or it can help you with transferring that information to another server quickly. A few simple steps can be a powerful tool to help you and your business. We will go over exporting all databases at once, a single database, and exporting a single table. This guide assumes that you have already logged in to PhpMyAdmin.

Continue reading “Exporting Databases and Tables with PhpMyAdmin”

Importing Databases and Tables with PhpMyAdmin

Reading Time: 4 minutes

Using PhpMyAdmin to import databases can help us in a few different situations, like when moving a database from one server to another, updating a table that is being developed elsewhere, or even restoring content from a backup. PhpMyAdmin helps make all those processes easy to accomplish through our browser.

This guide assumes that you have already logged in to PhpMyAdmin. We will go over what happens if we try to import into an existing database, importing a single table, and also partially restoring from a full database backup.

Continue reading “Importing Databases and Tables with PhpMyAdmin”