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).

up vote 1 down vote accepted

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.

  • Thanks. i sorted it out a while ago. cant remember how but I just changed the password. – Hawk007 Dec 13 '16 at 18:29

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.