1、错误现象
SQL> grant sysdba to test;grant sysdba to test*ERROR at line 1:ORA-01994: GRANT failed: password file missing or disabled
SQL> ho oerr ora 0199401994, 00000, "GRANT failed: passwo...
增删改查的权限grant select on testdb.* to common_user@'%'
grant insert on testdb.* to common_user@'%'
grant update on testdb.* to common_user@'%'
grant delete on testdb.* to common_user@'%'grant se...
网上查到的grant方式大多会报错,主要原因是mysql版本8.0后不能再使用原来的方式
查询mysql版本
select version();
在8.0版本下
grant all privileges on test.* to test@'%' identified by '123456';
报错
err...