enterprise-support team mailing list archive

[Sumaiya Akhter Shafique <1900340@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: mysql-replication-monitor
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1900340

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

To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-replication-monitor/+bug/1900340/+subscriptions