Databases
Create, manage, connect to, and troubleshoot your databases.
65 articles
- How to Allow a Remote IP Address to Connect to MySQL or MariaDBThis article explains how to authorize a specific remote IP address to connect to your MySQL or MariaDB databases. This is necessary when you need to connect to your databases…
- How to Back Up a Microsoft SQL Server Database With SQL Server Management StudioYou can create a backup of a Microsoft SQL Server database using SQL Server Management Studio (SSMS). This process allows you to create a restorable copy of your database, which…
- How to Change a MySQL Database Character Set or Collation SafelyYou can change the character set or collation of a MySQL or MariaDB database to ensure your website displays special characters, symbols, and non-English characters correctly. This process is performed…
- How to Connect to a Hostek Microsoft SQL Server Database With SQL Server Management StudioYou can connect to a Microsoft SQL Server database hosted on a Hostek server using SQL Server Management Studio (SSMS). This guide provides the steps for a customer to establish…
- How to Connect to a Hostek MySQL or MariaDB Database With MySQL WorkbenchConnect to your MySQL or MariaDB database using the MySQL Workbench desktop application. This guide is intended for customers who need to manage their database locally using a dedicated GUI…
- How to Export a Microsoft SQL Server Database as a SQL ScriptYou can export a Microsoft SQL Server database as a SQL script using SQL Server Management Studio (SSMS). This process creates a .sql file containing the SQL commands necessary to…
- How to Export a MySQL or MariaDB Database With phpMyAdminYou can export a MySQL or MariaDB database using the phpMyAdmin web interface. This process creates a .sql file containing the database structure and data, which can be used for…
- How to Grant a Microsoft SQL Server User Access to One DatabaseGrant a specific Microsoft SQL Server user access to a single database using SQL Server Management Studio (SSMS). This procedure allows you to control permissions for a specific user without…
- How to Grant an IIS Application Write Access to a Microsoft Access DatabaseThis article explains how to configure Internet Information Services (IIS) permissions to allow a web application to write data to a Microsoft Access database. This is required when a web…
- How to Identify a Slow Microsoft SQL Server QueryYou can identify slow Microsoft SQL Server queries using SQL Server Management Studio (SSMS) to determine which specific database actions are impacting your application's performance. This process allows you to…
- How to Identify a Slow MySQL QueryIdentify and isolate slow-running MySQL or MariaDB queries to improve website performance and database responsiveness. This process is available to any customer with access to their database via phpMyAdmin or…
- How to Import a MySQL Database That Exceeds the phpMyAdmin Upload LimitYou can import a MySQL or MariaDB database into your Hostek account even if the file size exceeds the phpMyAdmin upload limit. This process uses the command line to bypass…
- How to Import a MySQL or MariaDB Database With phpMyAdminYou can import a MySQL or MariaDB database into your hosting account using the phpMyAdmin web interface. This process allows you to restore a database from a .sql or .sql.gz…
- How to Optimize MySQL Tables SafelyYou can optimize MySQL tables to reclaim unused space and improve performance for your database. This procedure is intended for customers who need to maintain a MySQL or MariaDB database…
- How to Repair a Corrupted Microsoft Access DatabaseYou can repair a corrupted Microsoft Access database file using the built-in Compact and Repair tool. This process is intended for use by customers who have identified a corrupted .accdb…
- How to Repair a Crashed MySQL TableYou can repair a crashed MySQL or MariaDB table using the phpMyAdmin interface or the command line. This process restores the integrity of a database table that has become corrupted…
- How to Resolve a Microsoft SQL Server Certificate Trust ErrorYou can resolve a Microsoft SQL Server certificate trust error by configuring your client application to trust the server's certificate or by installing the server's certificate into your local trusted…
- How to Restore a Microsoft SQL Server Database With SQL Server Management StudioYou can restore a Microsoft SQL Server database to a previous state using SQL Server Management Studio (SSMS). This process allows a customer to recover data from a backup file…
- How to Troubleshoot a Microsoft SQL Server Network or Instance-Specific Connection ErrorThis article helps you identify and resolve connection issues between your application and a Microsoft SQL Server database. This guide is intended for customers who are experiencing network-level connectivity problems…
- How to Troubleshoot a Microsoft SQL Server Transaction Log Full ErrorA "Transaction Log Full" error occurs when the Microsoft SQL Server transaction log file reaches its maximum size or when the disk space containing the log file is exhausted. This…
- How to Troubleshoot a MySQL “Access Denied for User” ErrorThe "Access Denied for User" error occurs when a MySQL or MariaDB database rejects a connection attempt because the provided credentials (username or password) are incorrect or the user does…
- How to Troubleshoot a MySQL “Too Many Connections” ErrorThe "Too Many Connections" error occurs when the number of active connections to your MySQL or MariaDB database exceeds the maximum limit allowed by the server configuration. This prevents new…
- How to Troubleshoot Microsoft Access Database File LockingThis article helps you identify and resolve issues where a Microsoft Access database file is locked, preventing users from opening or editing the file. This applies to customers using Microsoft…
- How to Troubleshoot Microsoft SQL Server Login Failed Error 18456The Microsoft SQL Server Login Failed error 18456 indicates that the server successfully received the login request but rejected it due to invalid credentials or insufficient permissions. This article helps…
- How to Update an Application's Microsoft SQL Server Connection StringUpdate the connection string for an application to ensure it can successfully connect to a Microsoft SQL Server database. This process is performed by a customer to update application configuration…
- How to Update an Application's MySQL Connection SettingsUpdate the database connection settings for an application to ensure it can communicate with your MySQL or MariaDB database. This process is required when you change your database name, username,…
- How to Export and Import a MySQL Website Database During a MigrationThis guide explains how to export a database from your current host and import it into your new Hostek account. This process ensures that all your website's content, such as…
- How to Perform a Final Website and Database Synchronization Before CutoverPerform a final synchronization of your website files and database to ensure both components are identical on the Hostek server before you update your public DNS records. This process is…
- How to Prevent Two Copies of a Database-Driven Website From Accepting Changes During CutoverThis article explains how to prevent data inconsistencies when migrating a database-driven website to Hostek. A customer can use these techniques to ensure that no new data (such as new…
- How to Update Application Database Credentials After a MigrationAfter migrating a website to Hostek, you must update the application's configuration files to point to the new database credentials. This ensures the website can successfully connect to the new…
- How to Verify Website, Database, SSL, and Email Service After CutoverAfter completing a migration to Hostek, you must verify that your website, database, SSL certificates, and email services are functioning correctly. This process ensures that the transition from your previous…
- How to Change Website and Database Credentials After a CompromiseAfter a security breach, changing your website and database credentials is a critical step to lock out unauthorized users and secure your data. This procedure allows a customer to update…
- How to Back Up a Microsoft SQL Server Database in Windows Control PanelYou can create a backup of a Microsoft SQL Server database using the Windows Control Panel (WCP). This process allows an Account User to secure a copy of their database…
- How to Create a Microsoft SQL Server Database and User in Windows Control PanelYou can create a Microsoft SQL Server database and a corresponding database user within the Windows Control Panel (WCP). This process allows you to set up the necessary infrastructure for…
- How to Create a MySQL or MariaDB Database and User in Windows Control PanelYou can create a new MySQL or MariaDB database and a corresponding database user within the Windows Control Panel (WCP). This process allows you to set up the necessary infrastructure…
- How to Restore a Microsoft SQL Server Database in Windows Control PanelYou can restore a Microsoft SQL Server database using the Windows Control Panel (WCP) to recover data from a previous point in time. This process is available to Account Users…
- How to Sign In to phpMyAdmin From Windows Control PanelYou can access the phpMyAdmin database management tool directly from the Windows Control Panel (WCP) to manage your databases. This process allows you to manage your database without needing to…
- How to Allow a Remote IP Address to Connect to MySQLYou can allow a remote IP address to connect to your MySQL database in cPanel. This process allows you to manage your database from a remote location or application while…
- How to Assign a MySQL User to a DatabaseAssign a MySQL user to a specific database in cPanel to grant that user the necessary permissions to manage the database. This process ensures that your database credentials are correctly…
- How to Change a MySQL User Password in cPanelYou can change the password for a MySQL user directly within the cPanel interface. This allows you to update credentials for database users while maintaining their existing permissions and database…
- How to Change a MySQL User's Database PrivilegesChange the permissions of a specific MySQL user for a database within your cPanel account. This allows you to control what actions a specific database user can perform, such as…
- How to Create a MySQL Database and User With Database WizardYou can create a MySQL database and a corresponding database user simultaneously using the Database Wizard in cPanel. This process ensures that the user is correctly assigned to the database…
- How to Create a MySQL Database in cPanelYou can create a new MySQL database within your cPanel account to store data for your website or application. This process allows you to establish a dedicated database and then…
- How to Create a MySQL User in cPanelYou can create a MySQL user in cPanel to manage specific database permissions for your website or application. This process allows you to assign a unique username and password to…
- How to Create and Manage a PostgreSQL Database in cPanelYou can create and manage PostgreSQL databases directly within the cPanel interface. This process allows you to set up a new database, create a dedicated user, and assign specific permissions…
- How to Delete a MySQL Database or Database UserYou can remove a MySQL database or a specific database user from your cPanel account. This action is permanent and will result in the loss of all data contained within…
- How to Download a MySQL Database BackupYou can download a backup of a MySQL database directly from your cPanel account. This process allows you to save a copy of your database for local storage or for…
- How to Export a MySQL Database With phpMyAdminYou can export a MySQL database to a .sql file using the phpMyAdmin tool in cPanel. This process allows you to create a local copy of your database for migration,…
- How to Import a MySQL Database With phpMyAdminYou can import a MySQL database into your cPanel account using the phpMyAdmin tool. This process allows you to move a database from one location to another or restore a…
- How to Remove a MySQL User From a DatabaseYou can remove a MySQL user's access to a specific database within your cPanel account. This action prevents that specific user from logging into or performing actions on the selected…
- How to Repair or Optimize a MySQL Database in phpMyAdminYou can repair or optimize a MySQL database using the phpMyAdmin tool to resolve table errors or improve performance. This process is available to cPanel Account Users and is performed…
- How to Restore a Database From a Server BackupYou can restore a MySQL or MariaDB database from a server-level backup using the cPanel interface. This process allows you to restore a database to its previous state using a…
- How to Restore a MySQL Database Backup in cPanelYou can restore a MySQL database from a backup file using the MySQL® Databases tool in cPanel. This process allows you to restore a database to its previous state after…
- How to Restore a Customer Database From a Server BackupYou can restore a specific MySQL or MariaDB database for a customer account using a backup file from the server. This process allows you to recover lost data or restore…
- How to Change a MySQL User Password in WHMChange the password for a specific MySQL user within the WHM interface. This procedure allows a Server Administrator to update database credentials for any account on the server.
- How to Change the MySQL Root Password in WHMChange the MySQL root password within the WHM interface to update the primary administrative password for the MySQL database server. This action is performed by a Server Administrator and affects…
- How to Configure Remote MySQL Access Hosts Server-WideConfigure the list of IP addresses or hostnames permitted to connect to your MySQL or MariaDB databases from outside the server. This procedure is performed in WHM and applies to…
- How to Create a MySQL Database for a cPanel Account in WHMCreate a MySQL database for a specific cPanel account using the WHM interface. This procedure allows a server administrator to provision a database and assign it to a user account.
- How to Create and Assign a MySQL User in WHMCreate a new MySQL user and assign it to a specific database within the WHM interface. This process allows a server administrator to manage database permissions at the user level…
- How to Map an Existing Database to a cPanel AccountA server administrator can map an existing MySQL or MariaDB database to a specific cPanel account using WHM. This process links a database that already exists on the server to…
- How to Repair a MySQL Database in WHMRepair a MySQL or MariaDB database directly from the WHM interface. This procedure is intended for server administrators to resolve table corruption or structural issues within a specific database.
- How to Restore a MySQL Database From a WHM BackupYou can restore a MySQL database from a backup file directly within the WHM interface. This process allows a Server Administrator to restore a specific database to its previous state…
- How to Review and Stop a MySQL Process in WHMYou can identify and terminate specific MySQL or MariaDB processes that are consuming excessive system resources. This task is performed by a Server Administrator within the WHM interface to maintain…
- How to Troubleshoot a Failed MySQL or MariaDB UpgradeIf a MySQL or MariaDB upgrade fails during the update process in WHM, this article provides the steps to identify the cause and resolve the issue. This procedure is intended…
- How to Upgrade MySQL or MariaDB in WHMUpgrade the MySQL or MariaDB database engine to a newer version using the WHM interface. This procedure is performed by a Server Administrator to ensure the server is running on…
