【 使用环境 】测试环境 单机最小化部署
【 OB or 其他组件 】OBSERVER
【 使用版本 】CE 4.2.0
【问题描述】新建租户后使用root@新建租户可以使用，但是新建用户并赋权后提示ERROR 1045 (42000): Access denied for user ‘testdba’@‘xxx.xxx.xxx.xxx’ (using password: NO)
【复现路径】问题出现前后相关操作
obclient -h127.0.0.1 -P2881 -uroot@test_tenant -p -A
CREATE USER ‘testdba’@’%’ IDENTIFIED BY ‘xxxx’;
grant select on test_tenant.* to testdba;
obclient -h127.0.0.1 -P2881 -utestdba@test_tenant -p -A
【问题现象及影响】
ERROR 1045 (42000): Access denied for user ‘testdba’@‘xxx.xxx.xxx.xxx’ (using password: NO)
obclient [(none)]> select * from mysql.user where user=‘gareadba’\G;
*************************** 1. row ***************************
host: %
user: gareadba
password: *0384a7cba7b23d800f43f97479a43624a5c18f6a
select_priv: N
insert_priv: N
update_priv: N
delete_priv: N
create_priv: N
drop_priv: N
reload_priv: N
shutdown_priv: N
process_priv: N
file_priv: N
grant_priv: N
reference_priv: N
index_priv: N
alter_priv: N
show_db_priv: N
super_priv: N
create_tmp_table_priv: N
lock_tables_priv: N
execute_priv: N
repl_slave_priv: N
repl_client_priv: N
create_view_priv: N
show_view_priv: N
create_routine_priv: N
alter_routine_priv: N
create_user_priv: N
event_priv: N
trigger_priv: N
create_tablespace_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
plugin: ob_native_password
authentication_string:
password_expired:
account_locked: N
drop_database_link_priv: N
create_database_link_priv: N
1 row in set (0.001 sec)
查看赋权好像并没有成功 赋权语句并没有问题