[Solved] Dropping database user gives an error

Reported by: geeknmi
Created: 7 days ago
Last reply: 11 months 26 days ago
Views: 59

-MySQL Error: 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 'IF EXISTS `test`@`localhost`' at line 1
DROP USER IF EXISTS `test`@`localhost`;

Was able to drop with just like... DROP USER 'test'@'localhost';

IF EXISTS for user drop was added in MySQL 5.7.
Should be fine in v292.

Join our Discord server
Write a reply Edit a reply