Shulou(Shulou.com)06/02 Report--

What is MYSQL 8 user management? in view of this question, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

This tone, probably immediately hang up the phone, but MYSQL 8 user management, veterans, newcomers, it is better to understand, of course, if you already have ORACLE, PG, SQL SERVER and other database experience, you will find that MYSQL is getting more and more "old", change words, mature.

MYSQL 5.X MYSQL user management, those people (You know what I am talk about.) are incomplete, no roles, no more subdivided rights management (in fact, there is, but you may not know), MYSQL 8 will brush the concept of these disabilities to the end, in other words, MYSQL 8 user management, you can not pick anything.

First of all, let's talk about externalization. With regard to database security, no matter which kind of database, you need to pay attention to what the default account should be. Here I borrow MYSQL official one statment.

Do not ever give anyone (except Mysql root Accounts) access to the user table in the mysql system database! That is critical.

I estimate that 99.99% of people can't do it, including me, and it seems that there is more work to be done on security.

Let's start with the changes in user management and security in MYSQL 8.

1 the password encryption mode of the user has changed

2 plugins about users have changed

It is not so much the way the plug-in has changed, but the concept that the overall MYSQL 8 treats the plug-in. The whole MYSQL 8 can be seen as a component, and everything else is a component, a bit of a programmatic micro-service, maybe.

In addition, 8.015 of PERCONA is used in

INSTALL COMPONENT 'file://component_validate_password';

The reason for reporting an error is that this component has been installed and is at peace with the old plug

How to replace the old plug-in to the new component, we'll talk about it some time.

Without installing new components, the following two configurations cannot take effect, and MYSQL cannot be started. At the same time, if you use the official version, RPM, SUSE, and other installation methods, the new components will be installed automatically, while if they are compiled and binary, they will probably not be installed automatically. It should be noted that PERONCA binary comes with its own default installation.

Validate_password.length=10

Validate_password.number_count=2

Back to the point, since MYSQL 8 supports ROLE, we have to learn how to establish a ROLE, give permissions to ROLE, and give users ROLE is what we need to know right away.

The following is

The figure above shows some simple commands for granting and reclaiming between roles and users.

At the same time, MYSQL 8.0 can also create a COPY where one user grants permissions to another user.

In addition, the user password encryption in PERCONA 8.015 has already used caching_sha2_password, so the plan to migrate the account through the pt tool can be stopped, because that tool does not support it and will report an error.

This is the answer to the question about what is MYSQL 8 user management. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

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.