GRANT USAGE ON *.* TO database_a;
DROP USER database_a;
CREATE USER database_a IDENTIFIED BY 'password';
DROP DATABASE IF EXISTS database;
CREATE DATABASE database COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON database.* TO database_a IDENTIFIED BY 'password';
FLUSH PRIVILEGES;
USE database;
No comments:
Post a Comment