Hello,
After upgrade mariadb version from 10.2 to 10.4 , i can't update existing user password. no problem with new user.
Error changing password
Error altering user 'lppdcia9': View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Error altering user 'lppdcia9': View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Error altering user 'lppdcia9': View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them User's System Quotas set User's System Quotas set
how to solve this ?
regards.
After upgrade mariadb version from 10.2 to 10.4 , i can't update existing user password. no problem with new user.
Error changing password
Error altering user 'lppdcia9': View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Error altering user 'lppdcia9': View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Error altering user 'lppdcia9': View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them User's System Quotas set User's System Quotas set
how to solve this ?
regards.