airadb-创建数据

CREATE USER 'dbname'@'localhost' IDENTIFIED BY 'dbpssword';
GRANT USAGE ON *.* TO 'dbname'@'localhost' WITH MAX_USER_CONNECTIONS 0 MAX_QUERIES_PER_HOUR 10000;
CREATE DATABASE IF NOT EXISTS `dbname` CHARACTER SET utf8 COLLATE utf8_general_ci;
GRANT ALL PRIVILEGES ON `dbname`.* TO 'dbname'@'localhost';
GRANT ALL PRIVILEGES ON dbname.* TO 'dbname'@'localhost';
GRANT ALL PRIVILEGES ON `dbname\_%`.* TO 'dbname'@'localhost';flush privileges;

/apps/mysql-5.7.14/bin/mysql -u ****** -p -S /tmp/mysql_3306.sock