Databas
32 articles
-
Steps to View MariaDB databases in SSH
When managing databases in cPanel using MariaDB, the interfaces remain the same as those used for MySQL. MariaDB is des…
-
How to Open an SQL File in Windows?
SQL files contain code for modifying relational databases and their structure. In Windows, you can open these files usi…
-
How to Connect a Microsoft Access Database(MDB) in Windows Plesk?
Connecting a Microsoft Access database (MDB) to your Plesk hosting environment enables your applications to interact wi…
-
How to Connect your Database Remotely through SQL Management Studio?
This guide shows you how to establish a remote connection to your Microsoft SQL Server database using SQL Server Manage…
-
How to Fix “MySQL Command Not Found” Error?
If you encounter the "mysql: command not found" error while attempting to execute the mysql command, it indicates that …
-
How to Grant all Privileges to a User in MySQL with cPanel?
This guide shows you how to grant a MySQL user full privileges to a database through cPanel. The MySQL privilege system…
-
Learn to Remove PostgreSQL
Occasionally, during software installation, interruptions or incomplete downloads can occur, leaving you with partial f…
-
How to Import and Export MySQL Database via Command Line (SSH)?
If you have advanced user skills, you can use SSH to import and export MySQL databases via command line. This method pr…
-
How to Optimize a MySQL Database Using SSH?
Optimizing your MySQL database tables reorganizes table and index data, reducing space usage and improving I/O efficien…
-
How to Delete/Remove a Database in Webuzo?
This guide explains how to delete or remove a MySQL database in Webuzo. Deleting a database permanently erases all data…
-
How to Delete your MySQL Database in DirectAdmin?
This guide shows you how to delete a MySQL database from your DirectAdmin control panel. Before proceeding, it's advisa…
-
How to Modify Database User Privileges in DirectAdmin?
This guide explains how to modify database user privileges in DirectAdmin's MySQL Management interface. Adjusting privi…
-
How to Add a Remote MySQL Access Host in Webuzo?
Webuzo allows you to configure remote MySQL access, enabling external applications and services to connect to your webs…
-
How to Add/Create Database in Webuzo?
Creating a database in Webuzo is a straightforward process that allows you to set up MySQL databases for your web appli…
-
How to Add/Create a Database User in Webuzo?
Creating a database alone is insufficient. To effectively manage and deploy it for your website, you need to add a data…
-
How to Remove/Delete a Database User in Webuzo?
Efficient database management involves monitoring databases for optimal server resource utilization. Occasionally, remo…
-
The Easiest Way to Connect to a Database via MySQL Workbench
MySQL Workbench is an open-source tool that enables you to connect to server databases from any computer. This guide wa…
-
How to Modify Table Columns in phpMyAdmin?
phpMyAdmin is a versatile tool that enables you to modify table columns in MySQL and MariaDB databases. This guide show…
-
Learn to change MySQL collation settings in phpMyAdmin
MySQL provides language flexibility with various character sets for data storage and processing. For operations like st…
-
How to Reduce/Shrink the SQL File Size?
SQL log files can grow excessively large over time, consuming disk space and potentially causing performance issues. Th…
-
How To Change a MySQL Database User’s Password in cPanel?
Changing a MySQL database user's password in cPanel is a straightforward process that helps maintain database security.…
-
Drop Columns from a Database with PHPMyAdmin: A Comprehensive Tutorial
PHPMyAdmin enables users to modify MySQL and MariaDB databases through a web interface. This guide shows how to safely …
-
Learn to import .sql file into a Postgre database
This guide shows you how to import a .sql file into a PostgreSQL database using phpPgAdmin in cPanel. The process invol…
-
Learn to Create a PostgreSQL User
This guide shows you how to create a new PostgreSQL database user in cPanel and grant it access to an existing database…
-
Ideas To Fix Corrupted Tables in MySQL
MySQL tables can become corrupted, leading to unreadable data and potential server crashes. This guide walks you throug…
-
PHP Installation Appears To Be Missing the MySQL Extension
The error "PHP installation appears to be missing the MySQL extension" commonly occurs when setting up WordPress on a n…
-
Learn to Create a PostgreSQL Database
Creating a PostgreSQL database in cPanel is a quick process that allows you to set up databases for your applications. …
-
How To Install the Latest MySQL on Ubuntu 18.04?
MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQ…
-
How to Create a MySQL Database in Plesk
To manage your website's data effectively, you may need to create a MySQL database in Plesk, Internetport's web hosting…
-
Getting Started with phpMyAdmin: A Beginner's Guide
Welcome to the Internetport Knowledge Base guide on getting started with phpMyAdmin, a popular web-based tool used for …
-
How to Export and Import a MySQL Database (SQL Dump)
This guide will walk you through the process of exporting and importing MySQL databases using SQL dump files. Whether y…
-
Common MySQL Errors and How to Fix Them
This guide addresses some of the most frequently encountered MySQL errors and provides detailed steps on how to resolve…