LinuxQuestions.org - [SOLVED] Grant problem in mySQL for root user

- Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)

- - Grant problem in mySQL for root user (https://www.linuxquestions.org/questions/linux-newbie-8/grant-problem-in-mysql-for-root-user-4175718594/)

Grant problem in mySQL for root user

Hi
I just installed Apache2 and MySQL 8.031 on fresh installed Mate 22.04.1. I used mysql_secure_installation for root. So I logged in to MySQL with mysql -u root -p
I created a database called 'konsum' and a user called 'db_user'.
I wanted to give the db_user full privileges to the db konsum, but mysql tells me, that I am not allowed to use GRANT.
Can anyone please tell me what I missed?
I am thankful for any help, best regards,
Dag JNJ

Please provide the verbatim command that you attempted to use, and the exact text of the message that you received in response. "The devil is in the details."

mysql> GRANT ALL PRIVILEGES ON konsum.* TO db_user@localhost;
ERROR 1410 (42000): You are not allowed to create a user with GRANT

It worked as I did it this way:

Quote:

GRANT APPLICATION_PASSWORD_ADMIN,AUDIT_ABORT_EXEMPT,AUDIT_ADMIN,AUTHENTICATION_POLICY_ADMIN,BACKUP_ADMIN,B INLOG_ADMIN,BINLOG_ENCRYPTION_ADMIN,CLONE_ADMIN,CONNECTION_ADMIN,ENCRYPTION_KEY_ADMIN,FIREWALL_EXEMP T,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,GROUP_REPLICATION_ADMIN,GROUP _REPLICATION_STREAM,INNODB_REDO_LOG_ARCHIVE,INNODB_REDO_LOG_ENABLE,PASSWORDLESS_USER_ADMIN,PERSIST_R O_VARIABLES_ADMIN,REPLICATION_APPLIER,REPLICATION_SLAVE_ADMIN,RESOURCE_GROUP_ADMIN,RESOURCE_GROUP_US ER,ROLE_ADMIN,SENSITIVE_VARIABLES_OBSERVER,SERVICE_CONNECTION_ADMIN,SESSION_VARIABLES_ADMIN,SET_USER _ID,SHOW_ROUTINE,SYSTEM_USER,SYSTEM_VARIABLES_ADMIN,TABLE_ENCRYPTION_ADMIN,XA_RECOVER_ADMIN ON *.* TO `db_user`@`%`