SELECT User, Host FROM mysql.user WHERE Host <> 'localhost'; drop user 'ghost'@'%'; CREATE USER 'ghost'@'%' IDENTIFIED BY 'ghost'; GRANT ALL PRIVILEGES ON ghost.* TO 'ghost'@'%' WITH GRANT OPTION;