[SOLVED] Grant problem in mySQL for root user

Dag JNJ · 11-09-2022, 07:53 AM

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

sundialsvcs · 11-09-2022, 08:09 AM

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."

Dag JNJ · 11-09-2022, 10:11 AM

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

Dag JNJ · 11-09-2022, 03:35 PM

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`@`%`