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

Post Reply
kombajnik
Posts: 22
Joined: Fri Feb 19, 2021 1:42 am

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?

Tags:
kombajnik
Posts: 22
Joined: Fri Feb 19, 2021 1:42 am

Ok,
mysql_upgrade -u root --force
helps.
alexmina301
Posts: 1
Joined: Mon Dec 18, 2023 9:23 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.
kombajnik
Posts: 22
Joined: Fri Feb 19, 2021 1:42 am

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.
Post Reply