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

Bug #1900340 reported by Sumaiya Akhter Shafique
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
MySQL Community Replication Monitor
New
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.