Recently Added Articles
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…