Of course, simply connecting to the MySQL server isn’t going to accomplish much. Chances are you will want to select a database to work with. This is accomplished in one of two ways:
Connecting to the MySQL Server For the First Time
The MySQL client program, also known as the MySQL monitor, is an interface that allows the user to connect to the MySQL server, create and modify databases, and execute queries and view their results. This program is started by executing the command mysql at the shell prompt. In general, the syntax for this command is:
Understanding MySQL Configuration File
It’s very likely that the first task the administrator will want to undertake is proper configuration of MySQL’s configuration file. This file, entitled my.cnf, stores default startup options for both the server and for clients. Correct configuration of this file can go a long way towards optimizing MySQL, as various memory buffer settings and other valuable options can be set here.
Assigning a Dedicated IP to the Website in WHM
Log into WHM on your dedicated or cloud server.
1. Under the IP Functions select the Change Site’s IP Address.
2. Now choose the account or website to which you want to assign a dedicated ip and the ip you are going to give
3. Save the changes
Suspend and Unsuspended an Account in WHM
Log into WHM on your dedicated or cloud server.
1. Click on the Accounts Function link.
2. Scroll down and click on the Suspend / Un-suspend an Account link.
Creating a New Hosting Account in WHM
Log into your WHM on your dedicated or cloud server.
1. Click on to the Account Functions listed on the left sidebar.
2. Click on the Create a new account option. Once you click it fill all the required fields and click on the Create button on the top. You will get the account information of the recently created account.
How to Manage the Bandwidth in WHM/cPanel
Log into WHM on your dedicated or cloud server.
1. Click on to the “Account Functions”.
2. Once you click onto “Account Functions” to get options.
Enabling Backups in WHM / cPanel
Log into the WHM for your dedicated or cloud server.
1. On the main Screen Find the Backup and simply click on it.
2. Click the Configure Backup icon
3. It will show you various options with frequency that backup run and can be configured on this page.
Changing to Static IP Address on Windows Server 2012
Log into your dedicated or cloud server as administrator.
Click on: Start
Click on: Server Manager
How to Re-install Bootstrap Code (GRUB)
If you have repaired your system from a backup, or have installed another OS that may have overwritten the master boot record (MBR), you will need to repair the bootstrap area.
Re-install bootstrap code (GRUB)
