0

With adminer, user root, in debian busters, a table in a mariadb database isn't read:

table not shown

Why cannot I see the table UserHistory like the others?

I suppose that the mariadb root user has all the privileges like the linux root user... or am I wrong?

Improve this question
2
  • Can you check what privileges are reported by SHOW GRANTS;?
    – grawity_u1686
    Commented Jan 18, 2020 at 13:48
  • Grants for root@localhost: GRANT ALL PRIVILEGES ON . TO 'root'@'localhost' IDENTIFIED BY PASSWORD 'xxxxxxxxx' WITH GRANT OPTION
    – Paolo Benvenuto
    Commented Jan 18, 2020 at 14:02

1 Answer 1

Reset to default
2

The UserHistory table is a view which is why the additional statistics aren't there.

Its still viewable. SELECT * FROM UserHistroy LIMIT 10 and you'll get an answer.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .