Tencent Cloud MySQL cloud database activation, database account creation and authorization

If we are building a normal website project, we choose the cloud server (VPS) to configure the WEB environment, and then the database is usually placed in the cloud server directly with the website files. However, for some projects, we may not use ECS, or we need to separate files from databases, so we will use Cloud database 。 For example, Alibaba Cloud and Tencent Cloud have cloud database products.

The advantage of using cloud database is its high security, so that the database will not fail due to the problems of the cloud server, and the migration is relatively simple. You can directly grant authorization and change the binding address. However, according to some netizens' feedback, if we want to separate the database from the website, we'd better be in the same region, otherwise it is easy to have connection timeout failures. Before that, I also considered whether the website could solve the problem of putting domain name websites without BA on foreign hosts, storing static files on a third party, and then putting databases on domestic cloud databases to achieve faster access.

In this article, just one netizen needs to initialize and add a database account in the Tencent Cloud MySQL database, so they will take a screenshot and share it together for reference when some netizens need it.

About Tencent Cloud:

1、 How to select and set custom security group configuration for Tencent ECS

2、 Tencent ECS uses elastic public IP to replace dynamic IP and fixed IP for servers

3、 Image and text tutorial of Tencent ECS image/snapshot backup and recovery rollback data

First, preparations

In this article, we share the product of Tencent Cloud Database MYSQL, so we can only refer to the added account application and authorization of this product. We need to have a cloud database first, and we can purchase it on the official website of Tencent Cloud（ You can go directly to the official website here ）。 I remember that they were also doing activities before, and the minimum memory of 256MB cloud database was 12 yuan per month.

After the purchase, we can initialize the database in the database list. To initialize, we need to set the ROOT administrator password of the database. This needs to be remembered because it is necessary to log in to database management.

Second, enable access to the Internet

The default Internet address is closed. If we only use the intranet, we don't need to open it. If we need to remotely reference the database, we must open it. After opening the address, we need to remember that we need to use it when configuring the website.

Third, create a new database name

We need to create a database in the database management tool.

Here we directly use the database management tool of Tencent Cloud to create a new database.

Here, you can set the database name, select the character set, and sort rules.

Fourth, create a database account

Here we create an account.

Set the account, password and host name according to the prompt.

V. Authority

After adding databases and users, we also need to bind permissions, if not unavailable.

Here you can see "Modify Permission" in the account.

Then select the library we created earlier, check All, and click OK.

In this way, it seems complicated, but in fact, it can be completed with a few mouse steps Tencent cloud database The process of creating a cloud MYSQL database user and authorization. The default is MYSQL5.6, which can be upgraded to MYSQL5.7, depending on the actual project.