Files
sql-scratch-statements/Scripts/mariadb-create-user.sql

8 lines
201 B
SQL

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;