ERROR 1064 (42000): You have an error in your SQL syntax

Bug #1900340 reported by Sumaiya Akhter Shafique on 2020-10-18
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Community Replication Monitor
Undecided
Unassigned

Bug Description

Hello, I am using Ubuntu 20.04.1 LTS. I am using mysql Ver 8.0.21-0ubuntu0.20.04.4. When I try to create a DB, user and password it shows:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'M@utic69'' at line 1

I google and find this is a BUG. Now I need help to overcome this situations.

sumaiya@CL:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.1 LTS
Release: 20.04
Codename: focal

sumaiya@CL:~$ mysql --version
mysql Ver 8.0.21-0ubuntu0.20.04.4 for Linux on x86_64 ((Ubuntu))

mysql> CREATE DATABASE mautic DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Query OK, 1 row affected, 2 warnings (0.08 sec)

mysql> GRANT ALL ON mautic.* TO 'umautic'@'localhost' IDENTIFIED BY 'M@utic69';
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'M@utic69'' at line 1
mysql>

Thanks

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers