Following this guide:

https://phoenixnap.com/kb/how-to-create-mariadb-user-grant-privileges

root@svr11248:~# mysql -h localhost -u root
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MariaDB connection id is 48
Server version: 10.11.6-MariaDB-0+deb12u1 Debian 12

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

MariaDB [(none)]> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| projectsend        |
| sys                |
+--------------------+
5 rows in set (0.000 sec)

MariaDB [(none)]> SELECT User from mysql.user;
+-------------+
| User        |
+-------------+
| mariadb.sys |
| mysql       |
| projectsend |
| root        |
| user1       |
+-------------+
5 rows in set (0.001 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON 'projectsend'.* TO 'projectsend'@localhost;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''projectsend'.* TO 'projectsend'@localhost' at line 1
MariaDB [(none)]>