Table of Contents
In this article, you will learn about databases, DBMS, and Database Manager and how to use the Cloudways Database Manager to manage the databases.
What is the Database?
A database is a structured, organized set of data. A Web database is an application designed to be managed and accessed online or electronically from a computer system. In terms of computing terminology, a database refers to software used to store and organize data. Think of it as a file cabinet where you store data in different sections called tables. When you need a particular file, you look into that specific section (table) and get the file (data) you need.
What is the DBMS & Database Manager?
DBMS refers to Database Management System; it is a software or set of software programs to control the retrieval, storage, and modification of organized data in a database. MYSQL is a ubiquitous example of DBMS. Database Manager is part of DBMS, which handles the organization, retrieval, and storage of data. A database manager creates a bridge or links two or more files together and is the foundation for developing conventional business systems. This contrast with file manager, which works with only one file at a time and is typically used interactively on a personal computer for managing personal and independent data and files.
How to Use Cloudways Database Manager
You can use the Cloudways Database Manager to manage your application databases from within the console.
Cloudways Database Manager is unsuitable for managing large databases (i.e. larger than 200MB). To manage massive databases, please use other Cloudways-supported methods, such as MySQL remote connections or SSH tunnel for MySQL clients.
Log in to the Cloudways Platform with your credentials. Click on Applications in the top menu bar and select your target application from the list.
Under Application Management, click Access Details and Launch Database Manager under the MySQL Access option.
The Database Manager is secured using a self-signed certificate, but it may generate a warning in your browser, although it is valid. You can safely ignore it if you see it (don’t ignore it when connecting to other sites unless you know what you are doing). Here’s how you can proceed further:
Click on Advanced first.
Now, click on Proceed to Unsafe to accept the self-signed certificate.
The Cloudways Database Manager will open in a new tab, and you can start working with your database.