E erick85 Verified User Joined Oct 20, 2020 Messages 65 Feb 22, 2021 #1 After upgrading mariadb to 10.5, when I try to change the password in DA, I get an error: Error altering user: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Click to expand... How to fix it? Edit. mysql_use_new_user_methods=1 Click to expand... in directadmin.conf solved the problem. Last edited: Feb 22, 2021
After upgrading mariadb to 10.5, when I try to change the password in DA, I get an error: Error altering user: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Click to expand... How to fix it? Edit. mysql_use_new_user_methods=1 Click to expand... in directadmin.conf solved the problem.
O Ohm J Verified User Joined Aug 16, 2019 Messages 1,813 Feb 22, 2021 #2 this case relate to Version 1.61.5 | Directadmin Docs DirectAdmin Knowledge Base www.directadmin.com Version 1.59.0 | Directadmin Docs DirectAdmin Knowledge Base www.directadmin.com Version 1.59.2 | Directadmin Docs DirectAdmin Knowledge Base www.directadmin.com It's already fixed, From 1.59.2 New installs will get the setting: mysql_detect_correct_methods=1 this oldest server or newest install ? You can provide more information to staff in this forum.
this case relate to Version 1.61.5 | Directadmin Docs DirectAdmin Knowledge Base www.directadmin.com Version 1.59.0 | Directadmin Docs DirectAdmin Knowledge Base www.directadmin.com Version 1.59.2 | Directadmin Docs DirectAdmin Knowledge Base www.directadmin.com It's already fixed, From 1.59.2 New installs will get the setting: mysql_detect_correct_methods=1 this oldest server or newest install ? You can provide more information to staff in this forum.
