Please enable privileged commands in MariaDB - db<>fiddle

TopAnswers db<>fiddle

Meta

Databases

TeX

Code Golf

APL

C++

.net

db<>fiddle

Java

*nix

PHP

PowerShell

Python

Rust

टेक्-मराठी

Typst

Web Client Dev

Web Server Dev

Please enable privileged commands in MariaDB

feature-request completed add tag

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!');
```

1 Answer