Question

1

Do I need to change the mysql.sys password

rated 0 times [ 1] [ 0] / answers: 1 / hits: 5692 / 2 Years ago, thu, march 17, 2022, 5:44:06

This is probably a daft question, but do I need to change the mysql.sys password?

After doing a:

SELECT User,Host,Authentication_String FROM mysql.user;

to display the mysql users, hosts and passwords I see that the mysql.sys users password is set as follows:

mysql.sys | localhost | *THISISNOTAVALIDPASSWORDTHATCANBEUSEDHERE |

Mysql version is 5.7.13 and am having problems finding the code to change the password for another user. (test user).

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

pantkie

Add To Favorites

Follow

Total Points: 209

Total Questions: 112

Total Answers: 138

Location: Venezuela

Member since Sat, Apr 24, 2021

3 Years ago

answered 2 Years ago ranquctive · Accepted Answer

I think you should change this user password.

http://dev.mysql.com/doc/refman/5.7/en/sys-schema.html

As of MySQL 5.7.9, sys schema objects have a DEFINER of 'mysql.sys'@'localhost'. (Before MySQL 5.7.9, the DEFINER is 'root'@'localhost'.)

Use of the dedicated mysql.sys account avoids problems that occur if a DBA renames or removes the root account.

You can use sudo mysql_secure_installation to set root password and other secure conf. Then use root user change the mysql.sys password. As document say, not suggest del this user.