Hostwinds Tutorials
Tools and instructions enabling you to maximize the potential of your Hostwinds product and service experience.
Search results for:
Latest Tutorials Tagged with Mysql
cPanel provides you the ability to connect to the databases on your account from another location. We are happy to offer Hostwinds clients the ability to use this feature in our Shared hosting and Business web hosting services . Additionally, you can use any software that...
Restic is capable of reading data from stdin, which can be used for saving the output of a program. In this article, we will discuss how to use this functionality to take MySQL backups through the use of mysqldump. As with any interaction with Restic, you must first...
If you are applying an update to the software or a rolling restart of the server, restarting the SQL service may be required to interrupt any occurring processes safely. This guide will walk you through how to perform this in WHM. Before proceeding, we suggest making sure...
While tools like phpMyAdmin interact with MySQL / MariaDB databases very easily, sometimes one must access the database directly from the command line. This article will touch on getting into a database and some common tasks but will not provide a full education on SQL...
If you would like to reset the password for the root user's MySQL password, this guide will help you through that process. Reset MySQL Password Stop the MySQL Server You will want to have the correct version before continuing with this guide and can get it using this command...
mysqldump lets you quickly and efficiently take a backup of a single database, multiple databases, or even all of the databases on your server. This requires shell access to the server you wish to perform the commands on and the MySQL login credentials for your user(s). SSH...
This is a guide for shared hosting users who have ordered our backup service addon. Verification of Backed-up Data You're responsible for managing and verifying your backed-up data to ensure that the data stored is accurate and complete. If you believe there's an issue with...
In some cases, you may need to change your root MySQL password. This can be done via SSH, or you can do this quite easily through WHM. Let's take a look at the steps required to change the root MySQL password through WHM in this guide. Please note that you'll need to be...
MySQL is a prevalent 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 several large companies across the internet, such as Facebook and YouTube, to store various bits of pertinent data....
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 many large companies across the internet, such as Facebook and YouTube, to store various bits of pertinent data. MySQL can also be...
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 in to cPanel before proceeding. If you're not sure how to log in to cPanel, please check our guide: How to access...
How to create a new database in Virtualmin Like other control panels, such as cPanel or Plesk, Virtualmin provides a user-friendly interface to create and manage MySQL databases. To create a new database within Virtualmin, please refer to the following steps. Login to...
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...
There are times when a database user does not need to have full permissions to a database 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?...
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...
How do I set up a separate server for MySQL in WHM? You can set up a server to handle MySQL, which can help if your site(s) get a lot of traffic or are running big databases. (See below for important notes) Install MySQL on the remote MySQL server if it's not already...