CREATE DATABASE IF NOT EXISTS primavpdb001 ; 检查数据库primavpdb001是否存在,不存在则创建 GRANT ALL ON primavpdb001.* TO primavpdb001_f@localhost IDENTIFIED BY 'changeme' ; FLUSH PRIVILEGES ; 赋予用户primavpdb001_f在localhost上对primavpdb001数据库中所有数据表的全局权限,密码设置为changemeUSE primavpdb001; 打开数据库primavpdb001
检查数据库primavpdb001是否存在,不存在则创建
GRANT ALL
ON primavpdb001.*
TO primavpdb001_f@localhost
IDENTIFIED BY 'changeme' ;
FLUSH PRIVILEGES ;
赋予用户primavpdb001_f在localhost上对primavpdb001数据库中所有数据表的全局权限,密码设置为changemeUSE primavpdb001;
打开数据库primavpdb001