TAG: MySQL

How to Install MySQL (CentOS 7)

An open source variation of the SQL database management system, MySQL is a very common system to find on a Linux based server. MySQL is used by a number of large companies across the internet such as Facebook and YouTube to store various bits of pertinent data. MySQL can also be used in tandem with…

How to Install MySQL in Ubuntu 14.04

MySQL is a very popular open source database management system that you’ll typically find in a Linux server environment as part of a LAMP stack. MySQL is used by a number of large companies across the internet such as Facebook and YouTube to store various bits of pertinent data. MySQL can also be used when…

How to Backup a MySQL Database in cPanel

How do I Backup a MySQL Database in cPanel? This article will cover how to perform a MySQL database backup in cPanel. Please note that you’ll need to be logged into cPanel before proceeding. If you’re not sure how to login to cPanel, please check out our guide: How to access cPanel. To generate a…

Change Root MySQL Password in Virtualmin

In Virtualmin, you can change the root MySQL password through the very user friendly GUI at any time. Of course, you’ll need to have Virtualmin installed and be logged into Virtualmin with Webmin access. If you’re not entirely sure how to do either of these tasks, please refer to the following guides: Install Virtualmin (CentOS…

MySQL Additional Access Hosts

How do I Allow Remote Access to my Database? You can allow remote access to your MySQL database in cPanel by doing the following: Login to cPanel Under the Databases section select Remote MySQL®     Put the IPs you want in the text box Click the Add Host button     Note: This interface also allows for…

Adding a MySQL user to a database

How do I Add a User to a MySQL Database? You can easily add a user to specific MySQL databases in cPanel by doing the following instructions below.    Go to Home > Databases > MySQL Databases     Scroll to the Add User To Database section Pick the desired user and database from the…

Managing MySQL User Permissions in cPanel

There are times when a database user does not need to have full permissions to a database in order to interact with a MySQL Database. If you ever need to create a user with restricted permissions, this guide will help you do just that. How do I Create Permissions for MySQL Databases? MySQL users can…

Creating a MySQL User

How Do I Create A MySQL User In cPanel? To create a MySQL user follow the guide below.  This guide assumes you have created a MySQL database already.  If you haven’t created a database and are unsure how to do it, please see our doc on Creating A MySQL database.  If you are unfamiliar with…

Application Cannot Connect to Database

What causes an application cannot connect to database error? There are several things that could cause an application cannot connect to database error. It means for some reason, the PHP code isn’t able to retrieve information from the database where everything is stored. You may be using the wrong database name, the wrong username/password, the…