Anonymous 2419
When I run these commands:

```
/* Create USER */
CREATE USER
  'student'@'localhost' 
IDENTIFIED WITH 
  mysql_native_password
BY 
  'student5Password!';

/* Create DATABASE */
CREATE DATABASE studentshop;

/* Grant the PRIVILEGES to the created USER */
GRANT ALL ON studentshop.* TO 'student'@'localhost';
```

I get this error:

```
#1064 - 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 'BY   'student5Password!'' at line 5
```
Top Answer
Jack Douglas
This is now possible as all MariaDB engines are now running on FireCracker with higher permissions than before.

However you have a couple of syntax errors in your `create user` statement, it should be something like [this](https://dbfiddle.uk/?rdbms=mariadb_10.6&fiddle=1fb8d1b58e268116d04fd0339c0af2d1):

```
CREATE USER
  'student'@'localhost' 
IDENTIFIED via 
  mysql_native_password
USING 
  PASSWORD('student5Password!');
```

This room is for discussion about this question.

Once logged in you can direct comments to any contributor here.

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.