Importing large MySQL databases (typically over 50MB) in shared hosting environments presents unique challenges due to server limitations, timeout restrictions, and memory constraints. This guide provides proven methods and best practices for successfully…

The name of a MySQL database consists of a prefix, which is your cPanel username, followed by a “_” sign and the actual database name. For example, if your cPanel username is user and you create a database db, the database name will be user_db. If you…

How to Setup Custom Name ServersOverview Yes, you can setup custom nameservers with iFastNet hosting. Custom nameservers allow you to use your own domain name for nameserver addresses (like ns1.yourdomain.com) instead of the default iFastNet nameservers.…

On paid premium accounts the database server host name is always : localhost The MySQL port is 3306 (standard) To use a MySQL database with your PHP scripts; 1) Make a database in your cpanel/ Mysql section 2) Make a database user in your cpanel/ Mysql section…

If a database or new databases are not showing in phpmyadmin OR you are having troubles accessing phpmyadmin, then trying the following can fix most the time. 1) log into your cPanel 2) Reset your cPanel password. 3) Log out 4) Login and test. If that does…

Understanding and Changing MySQL Character Set and CollationOverview This guide explains what MySQL character sets and collations are, how to identify the current settings, and how to change them using phpMyAdmin. What are Character Sets and Collations?Character…

You do not need to own your own domain name to open an account with us, all of our plans include a free domain or subdomain you can use to get started.

ODBC Support for MySQL on cPanel Premium HostingArticle Information Article ID: KB-ODBC-001 Last Updated: August 12, 2025 Difficulty Level: Beginner to Intermediate Estimated Time: 5-10 minutes Quick Answer Yes, ODBC for MySQL is supported on iFastNet's cPanel…

How to Change MySQL Database CollationTable of Contents What is Database Collation? Before You Start Step 1: Access cPanel Step 2: Open phpMyAdmin Step 3: Select Your Database Step 4: Change Database Collation Step 5: Change Table Collations Step 6: Test…

The easiest way to empty a MySQL database is through phpMyAdmin. Once in phpMyAdmin, select the database you wish to empty. A list with all the database’s tables will appear. Click [Check All] to select all tables. Click the box [With selected:] and choose…

In order to access phpMyAdmin directly from: http://yourdomain.com/phpmyadmin you need to install phpMyAdmin on your hosting account. This way you won’t have to first log in to your cPanel when you want to use phpMyAdmin. Follow the steps below to complete…

How to automatically Backup All Your Databases on iFastNet cPanel Hosting This guide will help you create an automated backup of all your MySQL databases using a simple script on your iFastNet CloudLinux cPanel server. What This Script Does Automatically…

# How to Backup a Database in cPanel ## Overview Database backups are essential for protecting your data against hardware failures, software errors, accidental deletions, and security breaches. This guide covers multiple methods to backup MySQL/MariaDB databases…

How to Change MySQL Database Collation to UTF-8 Using phpMyAdminArticle Information Article ID: KB-MySQL-001 Last Updated: August 12, 2025 Difficulty Level: Intermediate Estimated Time: 15-30 minutes Overview This knowledge base article provides step-by-step…

Changing MySQL Database Engine Using phpMyAdmin in cPanelTable of Contents Understanding MySQL Storage Engines When to Change Database Engines Accessing cPanel Accessing phpMyAdmin Identifying Current Engine Types Changing Database Engine via Operations Tab…

How to Change MySQL Timezone for Your WebsiteOverview When developing your website, you may need to compare a certain date/time with the current date/time on the server. Understanding how to work with different timezones in MySQL is essential for accurate…

Changing MySQL User Passwords in cPanelTable of Contents Understanding MySQL User Management When to Change MySQL User Passwords Accessing cPanel Locating MySQL Databases Section Changing MySQL User Passwords Updating Application Configurations Testing Database…

How to Export Large MySQL Databases - Multiple MethodsOverview This knowledge base article provides multiple methods for exporting large MySQL databases when standard phpMyAdmin exports fail due to size limitations, timeout issues, or memory constraints.…

Please note there is a 300MiB upload limit on Free hosting accounts. And on premium accounts the PHPMyAdmin import limit is 1GB. If you are having problems trying to import a large database using PHPMyAdmin then we suggest using the following MySQL dump importer:…

How to Optimize a MySQL Database Using phpMyAdmin Article ID: KB-2025-001 Category: Database Management Last Updated: August 12, 2025 Applies To: iFastNet hosting accounts with MySQL database access Overview This knowledge base article provides comprehensive…

How to Optimize a MySQL Database Using phpMyAdmin Article ID: KB-2025-001 Category: Database Management Last Updated: August 12, 2025 Applies To: iFastNet hosting accounts with MySQL database access Overview This knowledge base article provides comprehensive…

How to Reset MySQL User Passwords in cPanel - Simple GuideTable of Contents What You Need to Know Before You Start Step 1: Access cPanel Step 2: Find MySQL Databases Step 3: Reset the Password Step 4: Update Your Website Files Step 5: Test Your Website Getting…

How to Use MySQL Triggers on cPanel Accounts with Definers MySQL triggers are special stored programs that automatically execute (or "fire") in response to specific events on a particular table or view in a database. When working with cPanel hosting accounts,…

Stored procedures are precompiled SQL statements stored in your MySQL database that can be executed repeatedly. They offer improved performance, enhanced security, and code reusability. This guide covers creating, managing, and executing stored procedures…

Your user does not have enough privileges for creating or dropping databases in PhpMyAdmin because of security restrictions. The only way you can add or drop databases is through cPanels mysql database menu.

In order to solve this issue follow these steps: Open the MySQL dump with a text editor on your local PC / MAC; Delete the line saying "CREATE DATABASE yourdbname". Usually this line is found at the very beginning of the file; Save the file and try to import…

This error indicates that the syntax of your query is not correct. Reasons for incorrect mysql queries vary and require programming knowledge for debugging. You can paste the query and error into Claud AI and get really good help here: https://claude.ai/…

How to Fix Remote MySQL Database Access IssuesProblem You're unable to connect to your MySQL database from a remote location or application outside of your hosting server. Solution Overview Remote MySQL access issues are typically caused by security restrictions…

Setting Up MySQL Database in cPanelWhat This Guide Will Help You Do This guide will walk you through creating a MySQL database for your website or application using cPanel. We'll use simple language and show you exactly where to click. By the end of this…

How to Change MySQL Database Collation to UTF-8 Using phpMyAdminArticle Information Article ID: KB-MySQL-001 Last Updated: August 12, 2025 Difficulty Level: Intermediate Estimated Time: 15-30 minutes Overview This knowledge base article provides step-by-step…