For security, you have the ability to create individual MySQL users to use with one or more database each with their own unique username and password including what privileges each user has. Creating a MySQL User A new MySQL user will be created with the username format of webuser_mysqluser Attaching MySQL Users to Databases In order […]
Category: cPanel
How to reset cPanel Password, File manager, Cronjobs, Style, etc.
Managing Database Data with phpMyAdmin
phpMyAdmin is a de facto standard for administrating databases in an easy point-n-click manner and makes editing and updating tables manually very easy. Accessing phpMyAdmin Once open you will be presented with your databases on the left which you just click to open and on the right will be where all of your tables show […]
How to transfer your accounts from your old host
– login to cPanel– click backups– click ‘Home Directory’ under Partial Backups– choose a location on your computer to save the file– select any/all databases – save those to your computer– select any/all email filters – save those to your computer– select any/all email forwards – save those to your computer– once complete – login to cPanel on new host– click […]
How to manage files via cPanel File Manager
You can also use the built-in File Manager capabilities of your cPanel which is easy and doesn’t require anything but a web browser to use. Accessing File Manager Uploading Files via File Manager That is how you can upload files via File Manager and best of all new upload boxes will be added as you […]
How to enable Remote MySQL Usage/Management
If you need to connect to your databases remotely through MySQL management software such as MySQL Administrator or similar, you can do this easily by enabling Remote MySQL connections. How do I enable Remote MySQL? After doing so, that remote IP or domain will be able to access your databases using valid MySQL connection information […]
How to create and delete Databases
Databases are used by many scripts to make storing a lot of information really simple and easy, instead of say, using thousands of files, a script can use a single database with several tables. Creating a Database A new database will be created with the full name of webuser_databasename and is ready for use with your scripts. […]
How to create an Addon Domain
IntroductionThis article will go over creating an Addon Domain under your cPanel account. Procedure1. Log into cPanel on the account to add the domain on.2. Click “Domains” under the “Domains” section.3. Click the “Create A New Domain” button.4. Enter the domain name to add in the “Domain” text box.5. Deselect the “Share document root (/home/username/public_html) […]
How to create a subdomain
IntroductionThis article will go over creating a Subdomain under your cPanel account. Procedure1. Log into cPanel on the account to add the subdomain on.2. Click “Domains” under the “Domains” section.3. Click the “Create A New Domain” button.4. Enter the subdomain name to add in the “Domain” text box.5. Deselect the “Share document root (/home/username/public_html) with […]
How to Upload Files via the cPanel File Manager
You can use cPanel’s inbuilt file manager instead of an FTP program. 1. Log in to your cPanel account. 2. In the Files section, click on File Manager. 3. In cPanel File Manager, navigate to the directory where you want to upload your files to. For example, should you wish to upload your files to the public HTML directory, you must […]
How to Reset cPanel’s Account Password
If you have access to your cPanel account, follow these steps to reset your password: 1. Log in to your cPanel account. 2. In the Preferences section, click on Password & Security. 3. Enter your old password.4. Enter your new password or use a password generator.5. Click on Change your password now.If it displays a success message, it means that the password has been […]