MySQL Performance: How To Leverage MySQL Database Indexing

Reading Time: 4 minutes
A Mysql Indexing Logo

Throughout this tutorial, we will cover some of the fundamentals of indexing. As part of the MySQL series, we will introduce capabilities of MySQL indexing and the role it plays in optimizing database performance. Liquid Web recommends consulting with a DBA before making any changes to your production level application.

Continue reading “MySQL Performance: How To Leverage MySQL Database Indexing”

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”

MySQL Performance: Identifying Long Queries

Reading Time: 6 minutes

Every MySQL backed application can benefit from a finely tuned database server. The Liquid Web Heroic Support team has encountered numerous situations over the years when some minor adjustments have made a world of difference in website and application performance. In this series of articles, we have outlined some of the more common recommendations that have had the largest impact on performance.

Continue reading “MySQL Performance: Identifying Long Queries”

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”

What is NoSQL and How is it Utilized?

Reading Time: 5 minutes

What is NoSQL?

A NoSQL or a NoSQL Database is a term used when referring to a “non SQL” or “not only SQL” database. NoSQL databases store data in a different format than a traditional relational database management systems. This is why NoSQL is often associated with the term “non-relational” database. Simply put, NoSQL databases are modern databases with high flexibility, blazing performance, and built for scalability. These databases are used when you require low latency and high extensibility while working with large data structures. The versatility of NoSQL is due to the nature of as being unrestricted in comparison to relational databases models such as MySQL or DB2. 

Continue reading “What is NoSQL and How is it Utilized?”

“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”

Create a MySQL User on Linux via Command Line

Reading Time: 2 minutes

Previous Series:
MySQL via Command Line 101: Basic Database Interaction

In this article, we will be discussing how to use MySQL to create a new user on Linux via the command line. We will be working on a Liquid Web core-managed server running CentOS version 6.5 as the root user. The commands used should also work on later versions of MySQL on CentOS as well.

MySQL is a relational database management application primarily used on Linux and is a component of the LAMP stack (Linux, Apache, MySQL, and PHP).

Preflight Check

  • Log in as the root user.
  • Have access to a terminal.
  • Basic knowledge of the command line.
Continue reading “Create a MySQL User on Linux via Command Line”

How to Install MongoDB on CentOS 7

Reading Time: 3 minutes

MongoDB is a NoSQL database intended for storing large amounts of data in document-oriented storage with dynamic schemas. NoSQL refers to a database with a data model other than the tabular format used in relational databases such as MySQL, PostgreSQL, and Microsoft SQL. MongoDB features include: full index support, replication, high availability, and auto-sharding.

Preflight Check

  • A Liquid Web Core Managed CentOS 7 node.
  • We are logged in as the root user.
Continue reading “How to Install MongoDB on CentOS 7”

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”