Create a Database Diagram in MySQL Workbench

It’s helpful to have a visual representation when designing a database. MySQL Workbench allows you to create entity-relation diagrams (ERD’s) and create relationships between the tables – i.e. one to one, one to many – and rearrange them as needed. Below we cover how to create a diagram from a downloaded SQL file. You can Read More >

What are Database User Privileges?

Databases are created and maintained using MySQL. Another MySQL function is to verify credentials and permissions. First, to initiate a connection to a database, MySQL must authenticate a database user and password combination (as well as the hostname from which the request was made). Once the connection is authorized, commands to manipulate a particular database Read More >

How to Create a MySQL Database Using the cPanel API

If you are running cPanel on your server, then you should use the cPanel API to create the database from the command line. Creating the database this way, allows for cPanel to integrate the necessary permissions for each cPanel user to access the databases they are granted access to. For instance, if you create a Read More >

How to Create a Database Using MySQL from the Command Line

If you need to create a database for your website there are multiple ways to do it. In this guide, you can learn how to create a MySQL database using the command line. IMPORTANT: This guide is inteneded for use with our Cloud VPS (and other hosting plans that do not include cPanel). If your Read More >

MySQL versus MariaDB

MySQL versus MariaDB Versioning Feature comparison New Features Performance Improvements Compatibility Issues The Back Story of MySQL and MariaDB MySQL and MariaDB share some common history, both are named after developer Michael Widenius’ daughters, My and Maria. MySQL was created in 1995 by a Swedish software company, MySQL AB. It grew in popularity over the Read More >

What is Percona DB

Percona DB Server for MySQL is an open-sourced database management system that is meant to replace MySQL. It offers everything in MySQL but includes additional tools for diagnostics, performance enhancement, and DB administrators/developers. Many of these features are not available with standard MySQL, or are only available on MySQL Enterprise Edition. What are the Benefits Read More >