New database "x" with new user "x" with password "p".
CREATE DATABASE x CHARACTER SET utf8 COLLATE utf8_unicode_ci ;
CREATE USER 'x'@'localhost' IDENTIFIED BY 'p';
GRANT ALL ON u.* TO 'x'@'localhost';
Use collation specific to your language, e.g. "utf8_czech_ci" if you want better sorting accuracy.
No comments:
Post a Comment