常用SQL

2019-03-10 本文已影响0人半个王国

MySQL

连库 $ mysql -u root -p
建库 CREATE DATABASE keystone;
建本地用户 GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'localhost' IDENTIFIED BY 'KEYSTONE_DBPASS';
建远程用户 GRANT ALL PRIVILEGES ON keystone.* TO 'keystone'@'%' IDENTIFIED BY 'KEYSTONE_DBPASS';