create user 'alex'@'%' identified by '123'; GRANT ALL PRIVILEGES ON `UCareDBHY`.* TO 'test'@'%'
jdbc:mysql://cc-architect-1:3307/UCareDBhy?characterEncoding=UTF-8&useUnicode=true&useSSL=false
原因是:url的数据名h小写了,与与授权时的大写不一致,workbench不需要指定数据库
create user 'alex'@'%' identified by '123'; GRANT ALL PRIVILEGES ON `UCareDBHY`.* TO 'test'@'%'
jdbc:mysql://cc-architect-1:3307/UCareDBhy?characterEncoding=UTF-8&useUnicode=true&useSSL=false
原因是:url的数据名h小写了,与与授权时的大写不一致,workbench不需要指定数据库