What mysql.sys?

4

Good Night Personal,

I just installed wampserver, later I was able to access phpmyadmin, but I found something strange in user accounts.

As users only had mysql.sys and root, being the root that I created.

Can anyone tell me about this? And something from the phpmyadmin version?

    
asked by anonymous 28.01.2017 / 23:04

1 answer

7

Since MySQL 5.7.7 a Schema is created to facilitate the performance statistics managed by engine PERFORMANCE_SCHEMA , and it is just the sys .

This user was also created (called DEFINER in this context):

'mysql.sys'@'localhost'

This was done to avoid problems, because before DEFINER was

'root'@'localhost'

and this created a lot of problems when the user root was renamed, which is a very common security procedure.

Creating a dedicated, local-only user was the solution found.


More details in the manual:

  

link

    
28.01.2017 / 23:11