SQLite
SQLite is an open-source SQL database that stores data in a text file on a device.SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world as it is used today by several widespread browsers, operating systems, and embedded systems…
What Databases do we Provide?
A database allows multiple users to maintain, update, and edit stored information quickly, securely, and efficiently We provide MySQL (MariaDB) databases which provide improved performance on all of our hosting packages. These can be created in your cPanel account. We do not limit the number of databasesyou can create. Almost all common website applications (including…
Remote Database Connections
WordPress lives in its database, your content makes your site special and unique, and that content lives in the database. If you wish to pluck out your WordPress, what you will be taking is your MySQL database. In order to connect to a MySQL database remotely, you must have your configuration settings ready. Host name…
Database Privileges
A database (MySQL) is an entity for storing information in the form of tables. All data in its databases are stored in the form of logically connected tables, access to which is carried out with the help of query language SQL. MYSQL verify credentials and permissions so that people’s databases are not available to every…
Choosing Between VARCHAR and TEXT in MySQL
While creating a database for web applications, it is crucial to pick the correct data type for text data fields. In MySQL, all text fields use one or the other string data type. As there are various types under String and each has its unique characteristics, it is essential to know which one is best…
How to Create Separate Database Access
This is very useful when you want to provide access to one database only within the Cpanel account. You need to create separate phpMyAdmin access though the Softaculous App Installer. Then install direct phpmyadmin access under your site ulr (like https://newdomain.com/phpmyadmin/), and use it to connect with the database credentials set for your site. You can…
Two Easy Ways to Export and Import MySQL Databases
One of the most important components, when you make a website, is a database. Whether you use common CMS platforms like WordPress, Magento, Joomla, or other PHP frameworks such as Laravel, CakePHP, or CodeIgniter, you will probably need to integrate a database that stores the website data. In this article, we will focus on exporting…
Using phpMyAdmin
PHPMyAdmin is a tool for the management of MySQL databases. This tool lets you manipulate and manage data in the databases of your hosting—for instance, Magento stores user data, pages, and posts in a MySQL Database. You can use phpMyAdmin to delete or add records in a MySQL database. What are the basic functions of…
Using a MySQL Database Remotely with cPanel
If you have external contributors to your website or your database resides on a different server, it makes sense to use remote database connections from your cPanel. Here’s how you can go about it: If you’d like to remove database access that is no longer needed, just navigate back to the ‘Remote MySQL’ feature and…
Creating MySQL Databases and Users
Databases offer a way of managing large amounts of information over the web easily. They are needed to run many applications that are web-based, such as online retail shops, content management systems, and bulletin boards. In this article, we will go over the steps that you need to take to create a new database and…
