Shulou(Shulou.com)05/31 Report--

MySQL in how to use the operation and maintenance panel for one-click installation and management of the database, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail, people with this need can come to learn, I hope you can gain something.

There are many database management and maintenance tools, in addition to the system's own command line management tools, there are many other management tools. MySQL is a very popular small relational database management system, which was acquired by Sun on January 16, 2008. At present, MySQL is widely used in small and medium-sized websites on Internet. Because of its small size, high speed and low total cost of ownership, especially open source, many small and medium-sized websites choose MySQL as the website database in order to reduce the total cost of ownership.

Next, I will give you a detailed description of how to install and manage the database with one click through the cloud helper of the operation and maintenance panel, including database creation, modification, permission setting, backup and recovery.

One-click installation of the database

In the-> Environmental Management module of the Cloud help hand panel, open-> Software Market

It comes with different versions of environment components, supports one-click installation environment deployment in different scenarios, does not need to build your own framework, and is very friendly to pure rookies for quick and convenient one-click configuration and installation.

SQL database: MySQL, SQLServer

WEB servers: IIS, Nginx, Apache

FTP server: FileZilla Server

Environmental framework: PHP, .NET Framework

Management tools: phpMyAdmin, TightVNC

Select the appropriate version of the database for one-click installation and deployment

Second, create a database

1. Click "add Database" to display the pop-up box for creating a database

After filling in the relevant information, click OK

two。 The list shows the databases that have been created

Change the ROOT password

1. Click "modify ROOT password" to display the pop-up box for changing the database ROOT password.

two。 Modify the password

3. Click "modify" to indicate that the modification is successful

4. Modify port

1. Click: more-> modify database port

two。 Modify the port (refer to the note, modify it according to the actual needs)

5. Backup

1. Backup

① clicks "backup" to display the database backup management pop-up box

② click "create backup"

③ backup completed

two。 Restore / delete backup

VI. Management

Click "manage" to display the "permissions", "re-encryption", "Delete" options

① clicks "permissions" to display the pop-up box for modifying database permissions.

② clicks "change Secret" to display the pop-up box for changing the database password.

③ clicks "Delete" to display the pop-up box to delete the database

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.