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

What this article shares to you is about how to use the operation and maintenance panel to manage the mysql database. The editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article.

There are many management and maintenance tools for MySQL. In addition to the command line management tools of the system, 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 manage the database through the cloud helper of the OPS panel:

First, 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

3. Modify port

1. Click: more-> modify database port

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

IV. Backup

1. Backup

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

② click "create backup"

③ backup completed

two。 Restore / delete backup

V. 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

The cloud helper management panel can complete general database management, including database creation, modification, permission setting, backup and recovery.

The above is how to use the operation and maintenance panel to manage the mysql database. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

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.