In this article, you will learn what is a database, DBMS, and Database Manager and also 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 a database application designed to be managed and accessed through the Internet 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 retrieval, storage, and modification of organized data in a database. MYSQL is a ubiquitous example of DBMS. Database Manager is the part of DBMS, and it 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. Contrast with file manager, which works with only one file at a time and is typically used interactively on a personal computer for managing the 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 not suitable 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 the Cloudways Platform with your credentials. Click on Applications in the top menu bar and then select your target application from the list.
Under Application Management, click on Access Details and click on 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.
That’s it! We hope this article was helpful. If you need any help, then feel free to search your query on Cloudways Support Center or contact us via chat (Need a Hand > Send us a Message). Alternatively, you can also create a support ticket.