1CREATE USER 'username'@'localhost' IDENTIFIED BY 'password';
2
3GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' WITH GRANT OPTION;
4
5CREATE USER 'username'@'%' IDENTIFIED BY 'password';
6
7GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' WITH GRANT OPTION;
8
9FLUSH PRIVILEGES;
10