``` CREATE USER 'user'@'%' IDENTIFIED BY '123456'; CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci; CREATE DATABASE IF NOT EXISTS dbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci; GRANT all privileges ON dbname.* TO 'user'@'%'; GRANT all privileges ON dbname.* TO 'user'@'%'; GRANT all privileges ON dbname.* TO 'user'@'%'; FLUSH PRIVILEGES;