How to drop 'user'@'%'
on the MySQL CLI using the mysql -e
command?
mysql -uroot -p -e "'myuser'@'%'";
This does not work.
command lineMySQL
How to drop 'user'@'%'
on the MySQL CLI using the mysql -e
command?
mysql -uroot -p -e "'myuser'@'%'";
This does not work.
Best Answer
You have to surround the
%
character with single quotesor put the user in single quotes as well
From the CLI, you would run something like this
An alternative method would be delete it from
mysql.user