4
Good Evening Everyone,
I just installed wampserver, later I was accessing phpmyadmin, but I found something strange in the user accounts.
As users had only mysql.sys and root, being the "root" which I created.
Can someone tell me about it? And something from the phpmyadmin version?
7
Since Mysql 5.7.7, Schema to facilitate performance statistics managed by engine PERFORMANCE_SCHEMA, and he is just the sys.
This user has also been created (called DEFINER in this context):
'mysql.sys'@'localhost'
This was done to avoid problems, because before the DEFINER was the
'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:
thank you. Thank you.
@Marcostulio if solved, you can score with the blue V on the side of the score, to score as chosen answer
Browser other questions tagged php mysql
You are not signed in. Login or sign up in order to post.
If I’m not mistaken he’s the table user
test, This is since Mysql 5.7.– Inkeliz
Related: What’s the difference between Mysql and phpMyAdmin?
– Guilherme Nascimento