Page 1 of 1

ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist

Posted: Thu Dec 07, 2023 9:41 am
by kombajnik
Hello, i'm trying via phpmyadmin on my server with myvestacp add some custom databases (3) and create user which have only access to these 3 databases. I'm login via root to phpmyadmin, i created databases but when im going to users i have error that I dont have enough premission to see users.

When I'm trying to select * from user; from mysql then receiving error:
MariaDB [mysql]> select * from user;
ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist
how to fix this?

Re: ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist

Posted: Thu Dec 07, 2023 5:50 pm
by kombajnik
Ok,
mysql_upgrade -u root --force
helps.

Re: ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist

Posted: Mon Dec 18, 2023 9:25 am
by alexmina301
I have same issue,couldnt find solution? any update? Pregnant papers templates typically include sections for essential details such as the mother’s name, expected due date, medical history, prenatal care records, and information related to the baby’s development. Free legal templates provide a structured format to document prenatal visits, track weight gain, record vital signs, note any complications or concerns, and keep a comprehensive record of the pregnancy progress.

Re: ERROR 1449 (HY000): The user specified as a definer ('mariadb.sys'@'localhost') does not exist

Posted: Tue Dec 19, 2023 11:45 am
by kombajnik
alexmina301 wrote: Mon Dec 18, 2023 9:25 am I have same issue,couldnt find solution? any update? Pregnant papers templates typically include sections for essential details such as the mother’s name, expected due date, medical history, prenatal care records, and information related to the baby’s development. Free legal templates provide a structured format to document prenatal visits, track weight gain, record vital signs, note any complications or concerns, and keep a comprehensive record of the pregnancy progress.
I posted resolution above, run

mysql_upgrade -u root --force

in putty.